CSV Writer

[Gabor]

Hi,

I am trying to use CSV writer to export my report in submission format. I noticed there is an empty row after the last row of the report… I tried to use Python node but the result was the same.

Any idea?

Thanks in advance!

Gabor.

[AlexanderFillbrunn]

Hi,
there is a newline character after the last line, but in my opinion that does not constitute an empty row (that would be two newline chars). Does the submission format explicitly disallow a trailing line break?
Kind regards
Alexander

[serendipitytech]

Hello @AlexanderFillbrunn, I’m going to try and tag on to this thread -
I’m using CSV writer to create a file that is then used as an infile for MySQL. MySQL reads the last line in, and fails since the table being imported to cannot have null value in the first two cells.

[tobias.koetter]

Hello serendipitytech,
you can also use the DB Loader node to bulk upload data into MySQL which also uses the INFILE command.
Bye
Tobias