Importing Excel to Database

Question

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?

mikes0011 · Accepted Answer

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.

stefanhelzle0001 · Answer

Do you see any error messages? This would really help a lot.

Sign up

Login with SSO

Login to the community

Login with SSO