Import Database Data from CSV Error

I assume you are exporting a select query . Can you make sure your query works fine in your database sql ?

HI Am using the plugin mentioned above , and it doesn't have any such options...

what version of MySQL are you using ? This smart service is depreciated in MySQL 5.6

docs.appian.com/.../Appian_Cloud_Changes_January_2014.html


Make-sure you choose the right design

Hi Raman,

Thanks for your reply,

Am using a different one which does excatly opposite of the smart service mentioned above in the deprecation i.e. parsing file data and storing in DB . Also i was able to solve the issue.

Reason for error: when the DB column names have spaces (As the smart service requires the table to have same headers as in file) it errors out. when the columns names don't have spaces in them it works fine.

Cheers!!

I see you are using different one . what is the smart service name ?

" Import Database Data from CSV " it helps to import CSv data into DB without having to parse it into the Process instance. It helps in saving process memory .