Hello,
I've tried checking the posts but I can't understand on how to configure the tool:
- I've created an interface to upload the excel file- I've created a CDT with the same columnsNow I don't know how to save the data into DB and move to another interface to display the data just uploaded
How can I set up the ID of the document (it's stored in a pv)?
How to map columns?
thanks
Discussion posts and replies are publicly visible
Hi maurizio
If you are using a cdt to parse the excel document and display it on the interface, then I would suggest not to use this plugin, you can simply use Write to datastore smart service and provide your cdt to the smart service to store in the DB and use the same cdt to display it on the interface. This would save a redundant step of fetching the data from the DB.
The document id would be stored in the variable that you are using to upload the file into the system. While parsing the file you can store the its contents and the id into the cdt.
Thanks