Importing Excel to Database

Hello, I'm currently trying to use the import excel to database smart service within my process model and it's completing but not updating my data store entity.

Process model:
Start -> User form -> Import Excel to DB smart service -> End

The file that I input in the form is an excel file and gets saved, and I have also configured the smart service so that the data source is a constant that contains the text which is my datasource: "jdbc/{name}". Table name: {SQL database table name}", excel file: Process variable which is stored excel document. 

After configuring all of these as followed by a youtube video that showcased this smart service, the data is not saving.

I made sure that my column headers(A1,B1,C1) are exactly as stated within my CDT and matches the data type.

How would I fix this/do this differently?

  Discussion posts and replies are publicly visible

Parents Reply
  • There are no errors. It just runs as if its processing the information.


    Just clarifying the steps I took:

    Made CDT matching excel columns
    Added entity to Data store
    Created constant for data store entity, constant for sql database name "dbo.{...}", and constant for data source: "jdbc/..."
    Configured the excel smart service with those values.
    Heres my excel file with example values:

    I made sure the CDT had boxID(text), prodDescription(text), emptyWeight(Number Float), dimension(text)

Children