LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dvs79

I have a CSV-file with semicolumn as a field delimiter. I've added a parameter FieldDelimiter into "Parameters 2" tab in a CSV-node edit window. And changed value from "," to ";". But when run, the error occurs:
Error while starting execution of node 'CSV+File'
Error executing node: Process exited before ENDIO message received.

Installing log (06/09/2011 18:46:15) ...
2011-06-09 18:46:15; Level: 2; Type: 0; Desc: "...exception seen"; File: ".\ConvertNodeControl.cpp"; Line: 173; Context: "Salmon::NED::Convert::ConvertNodeControl::getColu mnDelimiterFromProperties()"
2011-06-09 18:46:15; Level: 2; Type: 0; Desc: "...exception seen"; File: ".\ConvertNodeControl.cpp"; Line: 142; Context: "Salmon::NED::Convert::ConvertNodeControl::getSett ingsFromProperties()"
2011-06-09 18:46:15; Level: 2; Type: 0; Desc: "...exception seen"; File: ".\NodeControl.cpp"; Line: 259; Context: "Salmon::NED::NodeControl::initialize()"
Uninstalling log (06/09/2011 18:46:15) ...


What is the problem?

Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

It sounds like you should be using the Delimited File node. If your field is delimited by ";", than it isn't, technically a CSV (Comma-Separated Value) file, even if the extension happens to be ".csv". The CSV node doesn't easily allow you to override the field delimiter character. However, in the Delimited File node, which it is based off, you can provide a FieldDelimiter value, in the Parameters 1 tab.

Let me know if this works, or if you need more help.
Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dvs79

Hi!
I've tryed Delimited File node, inserted ";" in parameters. Nevertheless, error occurs. In attachement ErrorLog and test csv-file
Attachments:
csv_semicolumn_error.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Not sure how you are parameterizing your node. I had no problem reading the test file you sent, with just using a Delimited File node, and only supplying values to three parameters:

Field delimiter had a value of ;
record delimter had a value of \n
and File had a value of C:\Users\RichBoccuzzi\Desktop\test.csv

Everything else was blank, and I successfully read 590 records from the test file.

If you continue to have problems, please post your .brg so I can see how you are configuring your node.

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dvs79

Thanks a lot, rboccuzzi!

I've found a mistake: /n instead of \n.

I promise to write 100 times on the blackboard: "I'll always check spelling twice"