Skip to main content
saikiranp0001
Participating Frequently
Jul 15, 2022 4:38 AM UTC
Solved

Read a CSV File

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.

stefanhelzle0001
stefanhelzle0001Answer
Brainy
Jul 15, 2022 6:07 AM UTC

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

View in thread

11 replies

stefanhelzle0001
stefanhelzle0001
Brainy
Jul 15, 2022 5:54 AM UTC

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?

saikiranp0001Author
Participating Frequently
Jul 15, 2022 6:01 AM UTC

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
Brainy
Jul 15, 2022 6:07 AM UTC

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

    Terms & ConditionsAccessibility statement