Import CSV to Database error

Question

Hi, 
 I've used Import CSV to database smart services and configured the parameters. But when I debug, it throws " java.lang.ClassCastException: org.apache.naming.NamingContext cannot be cast to javax.sql.DataSource " error. 
 Can someone pls help me the step by step guide how to configure the below 2 smart services. I assume, I am missing some configs. 
 1. Import CSV to Database 
 2. Import Excel to Database 
 
 Reg/Mp

mohamedt808 · Accepted Answer

Create a constant and store the value "jdbc/Appian" and use that constant as the value in Data source of the smart service!!

mohamedt808 · Answer

HI , 
Please validate the below configurations, 
 
Excel to database : 
Document-> Your excel document 
columns to read in a row -> exact count of columns you want to read from the file 
data source name -> Your data source name in your data store 
new column (optional)->Can be used to add more data that i snot contained in the file. For Example Batch ID can help in extracting all rows inserted part of file import.mention it as text array i.e. {"Batch ID", "Date of import"} 
new column value (optional)-> Value for new column. i.e.{ri!batchID,today()} 
 
you have to ensure your column names matches the file header names. 
 
If you still face issues please share a sample file , table structure and you rconfiguration so that can help you better to resolve this!! 
 
Thanks, 
Thoufiq.

mohamedt808 · Answer

Hi, 
 You have to use the "Data Source" name in your Datastore(this is the drop down that you select to define your Database - connection ). 
 See the attached image. 
 
 Regards, 
 Thoufiq.

Import CSV to Database error

Top Replies