Skip to main content
1-Visitor
Sep 26, 2018 12:53 AM UTC
Solved

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

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.
LuistecAnswer
1-Visitor
Sep 27, 2018 2:45 AM UTC

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

 

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

4 replies

5-Regular Member
Sep 26, 2018 3:20 AM UTC

What's in the  Script Error Log ?

Translate
Luistec1-VisitorAuthor
1-Visitor
Sep 26, 2018 4:21 AM UTC

The same Log Message.

Screen.PNG

Translate
1-Visitor
Sep 26, 2018 1:14 PM UTC

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

Translate
Luistec1-VisitorAuthorAnswer
1-Visitor
Sep 27, 2018 2:45 AM UTC

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

 

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

Translate