Skip to main content
S
saikiranp0001
July 15, 2022
Solved

Read a CSV File

  • July 15, 2022
  • 11 replies
  • 0 views

HI All,

I have a requirement to process a CSV file to my database. i have used a smart service(Export CSV to Database) from Excel Tools plugin. But some of the special characters are not read properly.
For example: 

The data i have received in CSV has : ~@ö<é;ó¿üäÖÇ*àÄ=É!"ѧæñ á½èçòíê°

after consuming the file i have got this in my database : ~@�<�;�����*��=�!"ѧ��������

Can anyone suggest if we have any alternative options for this please.

Thanks,
Sai Kiran Pannala.

Best answer by stefanhelzle0001

I think the plugin expects the data to be encoded in UTF-8. Please check that.

11 replies

stefanhelzle0001
stefanhelzle0001
July 15, 2022

So, you export data from Appian into a CSV and import it, where? Appian uses UTF-8 to export the data. Is the other DB set up to store unicode? Does the import read the data in unicode?

S
saikiranp0001Author
July 15, 2022

HI Stefan,

Apologies if my statements were unclear.

I am not exporting data from APPIAN.
Basically i am getting data in a CSV file through SFTP integration from an external source. We need to consume that file into pur APPIAN database.
While consuming the file i am using a smart service(Export CSV to Database) from Excel Tools plugin. And this smart service or plugin is unable to read few special characters as mentioned above.

stefanhelzle0001
stefanhelzle0001Answer
July 15, 2022

I think the plugin expects the data to be encoded in UTF-8. Please check that.

    Terms & ConditionsAccessibility statement