Import excel to database

Hi All,

I am trying to use import excel to database smart service (Excel tool plugin) for storing data in database. but its throwing me error in log file like : 

Cannot retrieve the value for key "Unknown column '' in 'field list'" from the bundle.
is anybody faced this issue? if yes, then please let me know the solution.

  Discussion posts and replies are publicly visible

Parents Reply
  • Hi Vadivelan,

    Even I am facing the same issue. 

    Batch Sixe : 1000
    Data Source Name: "jdbc/Appian"
    Excel Document: "SampleWithHeader.xlsx"
    New Columns: {"transId","projCode","bizId","blahblah","fixId"}
    New Columns Name: {"transId","projCode","bizId","blahblah","fixId"}
    Sheet Number: 0
    Table Name: "Sample"

    My excel file has header (I tried without header as well) and not working.

    I actually tried import csv to database (with and without headers) that isn't working as well. Not sure if plugin issue.

    Thanks.

Children
No Data