Hi guys,
I have a very simple CSV file which contains 4 columns. They have exactly same columns type and columns name as database.
On the Cloud Appian, I can manually import the CSV on cloud DB by select import functions, and without any issues, all data come in.
But now I want to use Process model then I used:
But every times the importing is failed, here is my settings:
I leave Column Names and Encrypted columns name as empty because the CSV header is exactly match with my table structure.
Here is the error I read from Logs:
Unknown column 'PlaceAliasID' in 'field list' com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'PlaceAliasID' in 'field list'what is "" ? and please help me guys!
Discussion posts and replies are publicly visible
Looks like a hidden character in your CSV.If you open this in notepad. do the name match?
Yes I find the root cause, the CSV file I receiving is in UTF - 8 DOM format.
Appian doesn't support UTF-8-DOM format.
What I can do for this>