cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

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

Luistec
7-Bedrock

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

ACCEPTED SOLUTION

Accepted Solutions
Luistec
7-Bedrock
(To:Luistec)

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

 

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

View solution in original post

4 REPLIES 4

What's in the  Script Error Log ?

Luistec
7-Bedrock
(To:zyuan1)

The same Log Message.

Screen.PNG

wposner-2
14-Alexandrite
(To:Luistec)

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

Luistec
7-Bedrock
(To:Luistec)

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

 

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

Announcements


Top Tags