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 -> EndThe 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
Do you see any error messages? This would really help a lot.
There are no errors. It just runs as if its processing the information.Just clarifying the steps I took:Made CDT matching excel columnsAdded entity to Data storeCreated 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)
Can you check in logs if some error is reported there?