Problem with dumping data into database using import excel smart service

6 replies
32 views

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.

Y

yogip3177Answer

Brainy

Have you configured the 'Error Occurred' and 'Error Txt' fields in Result? If not, configure these fields to check errors if any.

Y

yogip3177

Brainy

If you are still facing the same issue, share the following:

Database table name
Import Excel to Database smart service configuration(Database Field Name, etc.)
Sample Excel file

Without all these details, it is difficult to help.

prasantap0900

Participating Frequently

As per [mention:c3d4bf332aba4695885fdc0e0110ec6e:e9ed411860ed4f2ba0265705b8793d05] , 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.

A

ankitas8394Author

New Participant

Thanks a lot for sharing. I tried but didn't help

Sign up

Login with SSO

Login to the community

Login with SSO