Import CSV to Database error

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.

Thanks a lot Thoufiq...will try today and let you know. I am anew to Appian.

Hi thoufiq, still facing the same issue. Value in data source name field shows my data entity name. Am I missing something here?

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.

I used the same in my data store. But import excel tondb plugin has a filed called data source, what should I use ther

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

Applied ur suggestion, but now I am getting another error "??? Incorrect table name???"

Now I m getting "??? Unknown column " in field list???