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.
1. Check your CDT, have any column of type multiple
2. Check the Keys, I think you are giving wrong key value for storing.
column name and mapping is correct only. this smart service is working now for me when i provide value in attribute "New Columns" and "New Columns Values". But this attribute is optional, it should work without this also.
Could you please tell me, what values to be given to "New Columns" and "New Columns Values"
in "New Columns" you should give column name of you table and in "New Columns Value", the value which you want to store.
If the values that i want stored in the database are in the excel document, how should we get this smart service to work ?
did you have to parse the excel and then supply the data as a cdt into the "new column values" parameter of the smart service ?
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:
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.