I am having same field names in database table as well as in my excel file. Also configured it in data store correctly. But while using import excel smart service to dump data, even after providing same table name as database table, data source name- "jdbc/Appian", and excel document having similar fields, there is no error populating but I cannot see my data in my database, nothing's happing there.
Discussion posts and replies are publicly visible
Sure,
Here are the details:-
Datbase table name- AE_TEST_ImportExcel
Database field names-
excel file- name- AE_TEST_ImportExcel
Excel field names-
smart service configuration-
data source name- ="jdbc/Appian"
table name- ="AE_TEST_ImportExcel"
document- =todocument(pv!employeeDetails.documnetId) // I am able to locate the document in the folder with the document Id
datastore table- AE_TEST_ImportExcel
Have you configured the 'Error Occurred' and 'Error Txt' fields in Result? If not, configure these fields to check errors if any.
Oh yes, thank you so much for helping. I got the error and able to correct it now. In my excel in date field, the format I entered is of another type whereas in database it is of different format.
I am able to dump the data into the database now after I matched the format.
Thanks a lot. I really appriciate it !