Saving data from xl to Oracle table

Question

Hi All, I have one question that from the user interface user will be uploading xl file where may contain 5000 rows of data and 3 columns . Now can save process this data in Appian I.e can I use export from xl to CDT smart service and then write them to Oracle table . If this is not the right way to handle then how can I proceed .

Vinay Kumar Rai · Accepted Answer

Hi, 
 
Using Import CSV to Database, will directly store the CSV data to Oracle Database 
 
Plug-In forum.appian.com/.../summary 
 
You need to first convert the use data format to CSV then used the above plug-in to insert the data,

Thanks

arikd · Answer

Hi Bhargav, 
 
You can try with the below approach: 
 
Step 1.Use Parse Excel to CDT smart service 
 
 >> the Parse Excel to CDT smart service within Excel Tools should allow you to load the data present in the Excel to CDT 
 
Step 2: Then use Execute Stored Procedure smart service. 
 
>>Using Execute Stored Procedure smart service you can directly write the data from the CDT to Oracle table using Oracle Stored Procedure. 
 
Please try the same and hopefully it will work.

manishk0001 · Answer

I am agree with Vinay Post.If you are using excel sheet to upload the data to DB .. than you need to put the data in CDT which will consume the memory and again from CDT to DB use any SP or other operation ..It is always good to push data using import CSV to database . you just need to do the table mapping in the smart service ..