Hi, everyone! I need to import a spreadsheet data into a database table and I'm using Import Excel to Database smart service for that matter with parameters described below:
So basically excel header names I got from a document are in respective order as database field names. Also there are other database columns which I'm populating with other data than spreadsheet. The problem is that a smart service returns Error Occured = true, but no Error Txt. So I can't localize an issue
Discussion posts and replies are publicly visible
Without any information, we will not be able to support you. Did you check the tomcat_stdout log for any details?
Additionally, strange issues from some of these services are why I always recommend using fn!readexcelsheetpaging() within an expression rule, instead of the service directly. This will allow much more flexibility and troubleshooting. The rule can use this function to read the document, and you can export a CDT after any data manipulations, then plug it into the standard Write to Datastore service.
Excel Tools
Try to avoid using special character in the headers. It seems you have "/" in "Material/TOT". It might be causing an issue.