Skip to main content
L
Luistec1-Visitor
1-Visitor
September 26, 2018
Solved

Trouble with reading CSV file with CSV Parser Extension (Solved)

  • September 26, 2018
  • 2 replies
  • 2644 views

Hello everyone.

 

I am new at this and  there are many things that I don't understand, so I need your help.

 

So, I'm trying to read a CSV file (function ReadCSVFile) and save it in a InfoTable. I have downloaded the CSV Parser Extension and have boiled down to the bare minimum and have not been able to get it to work. When I launch the service, the following error appears:

 

Error executing service SImportCSV. Message :: Unable To Open [*******] in [********] : begin 0, end 18, length 13 - See Script Error Log for more details.

 

What could be the problem?

 

Thanks,

Luis

This topic has been closed for replies.
Best answer by Luistec

I found the error. The date type records were not correct. 

 

Incorrect date type: 2018/9/2 -------- Correct date type: 2018/09/02

2 replies

Z
zyuan15-Regular Member
5-Regular Member
September 26, 2018

What's in the  Script Error Log ?

    L
    Luistec1-VisitorAuthor
    1-Visitor
    September 26, 2018

    The same Log Message.

    Screen.PNG

    W
    wposner-21-Visitor
    1-Visitor
    September 26, 2018

    The out of the box CSV parser requires a carriage return at the end of the CSV.  Make sure your file has one.

      L
      Luistec1-VisitorAuthorAnswer
      1-Visitor
      September 27, 2018

      I found the error. The date type records were not correct. 

       

      Incorrect date type: 2018/9/2 -------- Correct date type: 2018/09/02

      Terms & ConditionsAccessibility statement