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
As per Yogi Patel , it is difficult to tell without those details, but last time I have seen same problem in community, and they have said that the reason can be for the naming convention like your excel table name in "upper case" but database table name in "camel case". I am not sure, but you can check with those.
Thanks a lot for sharing. I tried but didn't help
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 !