Import excel to database

Question

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.

Sandeep · Answer

Hi, 
 in "New Columns" you should give column name of you table and in "New Columns Value", the value which you want to store.

asimrasool · Answer

Trick is the to remove the last column in your excel file and use it under "New Columns" with it's value under "New Column Values". 
 For example, in my CDT, the last column is always "isActive". Now when I would want to import Excel to database, I will not include "isActive" column on excel file, rather, I will input "IsActive" as Value under 'New Columns' and "1" as value under 'New Column Values'. 
 As sandeepr373 mentioned, these were supposed to be optional fields, however, the node fails if they aren't populated, for some reason. 
 Keeping rest of the parameters as desired, the node should pass. It worked for me considering below: 
 
 Do not add primary field in the excel file to be imported. If it's auto-incremented, it will automatically get created 
 Column headers as in the excel file and database should be same 
 If there are boolean fields, ensure there is no "null" or blank cell. It should either be 1 or 0 
 To be cent percent sure, I exported my CDT as CSV, converted it to excel file, and used that format for data backfill/import 
 I'm using "jdbc/appian" as Data Source Name 
 Sheet Number starts from 0 to n 
 Excel Document should be the file name only (without extension). Use browse and select the file to be sure

Import excel to database

Top Replies