Skip to main content
August 3, 2023
Question

Import excel to database plugin not working

  • August 3, 2023
  • 8 replies
  • 0 views

Hii All,

       i am trying to import the data in the excel sheet to the database using Import Excel to Database smart service plugin but the data is not importing to the database even the process workflow is working fine and executes without any error. I have used the upload file field in the interface then using the start process function i am triggering the process model. Can anyone please help me in this?

    8 replies

    stefanhelzle0001
    August 3, 2023

    Did you check the output parameters of the import node? Does it return any error message?

    How do you check for the imported data? Through the record or via "Cloud Database"? Records are not automatically synced.

    August 3, 2023

    Check the output parameters of smart service and which DB you are using to upload a file?

    August 11, 2023

    It was a datasource error mistakenly i have give the other datasource in the DB.

    csteward
    August 3, 2023

    I always always suggest using the related function provided by the Excel Tools plugin, fn!readexcelsheetpaging().  This allows you to build an expression rule that will convert the excel file to a CDT, then you can use the Write to Datastore service to persist the CDT to the DB.  This allows much more debugging capability and flexibility for converting values as they map to the CDT, etc.

    You can upload a sample document to your environment and use it as a rule input to see the conversion occurring this way, much easier to work with.

    Sometimes these smart services are finicky where a blank line or value can throw the whole thing off without warning.  This is easily avoidable with the function instead.

    stefanhelzle0001
    August 3, 2023

    Yeah ... but this can get you into scalability and memory consumption issues ...

    csteward
    August 3, 2023
    Yeah ... but this can get you into scalability and memory consumption issues ...

    That is always good to consider, but I have not run into any of these issues in all my experience with this function which I use in a number of areas, starting when the function fn!readexcelsheet() was introduced.  Have you experienced any issues related to these?