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?
Could you check Smart Service Output like errorOccurrd or errorText?
Is there any reason you can't use the Read Excel Sheet smart service and parse that manually into your CDT, then use a standard WTDS node only after you can confirm in your process that you have a valid data set waiting to be written? This would have the added benefit of allowing you to micromanage your data mappings, do column-by-column data cleanup, etc.
Yep I have just use the write to data store entity after storing the information with readexcelpaging. So I no longer need this smart service