Import Excel to DB with Excel Plugin

Question

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 columns Now 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

ankitab0001 · Accepted Answer

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

Import Excel to DB with Excel Plugin

Top Replies