Discussions

Expand all | Collapse all

API_ImportFromCSV XML parsing error on latin characters

  • 1.  API_ImportFromCSV XML parsing error on latin characters

    Posted 06-08-2018 20:28
    Hello 

    Whenever I use the API_ImportFromCSV to import records, it crashes on a certain row that contains the latin character '?'?" . When I open the spreadsheet using a plain text editor, this character is appear as <0x8d> which seems like it would crash the XML parsing. 

    I've trying adding <?xml version="1.0" encoding="utf8"> into my script, but it does not work. 

    Anyone have any suggestions of how I may fix solve this? 

    Thank you 


  • 2.  RE: API_ImportFromCSV XML parsing error on latin characters

    Posted 06-10-2018 12:18
    I am curious what the source of the text is (a teletype terminal?) because x8d is the "reverse line feed" character. I would remove the character before calling API_ImportFromCSV