BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
Expand all | Collapse all

Uploading Excel File and Displaying Data in Table in IBM BAW

  • 1.  Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Sun November 24, 2024 10:53 PM

    I want to to enable users to upload an Excel sheet through a file upload control in a Coach view and once the file is uploaded, its contents should be read and displayed in a table on the same page.



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------


  • 2.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon November 25, 2024 02:53 AM

    I think this GitHub - IBM-BAW-Assets/excel-reader-tk: Excel Reader Toolkit toolkit will be helpful for you.



    ------------------------------
    [ahmed] [shaheen]
    [System developer]
    [valleysoft-eg]
    [Cairo] [Egypt]
    [+20-01015699307]
    ------------------------------



  • 3.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon November 25, 2024 04:54 AM

    Thank you for the reply, but we don't have the marked service in our current BAW platform. Please find the below attached screenshot for the reference.



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------



  • 4.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon November 25, 2024 05:09 AM

    You can add it by adding the out of the box dependency toolkit with name "Content management" if your BAW version is V18 and higher and the same toolkit exist for BPM 8.5.7 and 8.6



    ------------------------------
    [ahmed] [shaheen]
    [System developer]
    [valleysoft-eg]
    [Cairo] [Egypt]
    [+20-01015699307]
    ------------------------------



  • 5.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Tue December 03, 2024 12:48 AM

    Here, when I upload the .jar file to the IBM BAW platform above attached error has occurred, can you please suggest me to solve this issue.



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------



  • 6.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Thu December 05, 2024 01:55 PM

    Hello !

    You selected the wrong option in the drop down. To use integration JARs, you should select the option "Java service from server file" and reference a JAR asset that you previously uploaded in the "Files > Server File" section of the Web Designer

    See the official IBM Documentation about using External Services JARs here:

    https://www.ibm.com/docs/en/baw/24.x?topic=services-calling-external-service#topic_vfp_wq2_gx__title__4 

    (And here for Java Class development guidelines https://www.ibm.com/docs/en/baw/24.x?topic=service-invoking-java )

    Happy coding ! 



    ------------------------------
    Pierre D.
    IBM Tech Specialist // Business Automation
    ------------------------------



  • 7.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Fri December 13, 2024 01:20 AM

    We are facing this issue while importing .jar file can u help with this issue?



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------



  • 8.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon December 16, 2024 05:00 AM


    Now we are facing this issue while importing .jar file can u help with this issue? 



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------



  • 9.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon December 16, 2024 02:16 PM

    So Ravindu ,

    you are getting this error because you are trying to run a jar or its dependency build with java 17 in java 8 run time on your WebSphere server. Build with java 8 (update target to 1.8) , import new jar and try again.



    ------------------------------
    Sameera Fonseka
    ------------------------------



  • 10.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon December 16, 2024 10:43 PM

    Dear Sameera,

    we are already build with java 8, can you give us another solution. 



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------



  • 11.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Wed December 11, 2024 10:35 PM


    Here how to make connection between attached service and attached Client Side Human Service can you explain?



    ------------------------------
    Ravindu Kodithuwakku
    ------------------------------



  • 12.  RE: Uploading Excel File and Displaying Data in Table in IBM BAW

    Posted Mon November 25, 2024 08:02 AM

    It appears that the Excel Reader Toolkit could be a good option for a mostly server-side-based solution.  Another option that we have used to achieve this client-side is to just convert the Excel file contents into HTML for display in a browser using sheet.js: https://docs.sheetjs.com/docs/solutions/output/



    ------------------------------
    Don Williams
    ------------------------------