Scripted upload adds empty lines to csv-file :: Support Forum

bakker_be
Joined:: 2014-12-05
Posts:: 2

Scripted upload adds empty lines to csv-file

2014-12-05 13:52

Hi there, I'm trying to automate the upload of a csv file through FTP, but for some strange reason this command

c:\program files\winscp\winscp.com "/script=C:\Data\PLANNING\PLANNING_20141228.txt"

adds a blank line after each line in my csv.
Content of the script file:

open ftp://user:pwd@ftp
cd /data
put C:\Data\PLANNING\PLANNING_20141228.csv
close
exit

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,518
Location:: Prague, Czechia

Re: Scripted upload adds empty lines to csv-file

2014-12-09

How do you display the file to see that the blank line was added?
I would assume the CSV file has Windows line endings. Viewer expects Unix line endings and interprets the Windows line ending as an additional new line.
Try to use text transfer mode.
https://winscp.net/eng/docs/transfer_mode

Reply with quote

bakker_be

2014-12-09 13:32

Hi Martin,
I open the file with Notepad++ or Programmer's Notepad, both display additional lines which weren't visible in the original file. I'll look into text-transfer.

Reply with quote

Scripted upload adds empty lines to csv-file

Scripted upload adds empty lines to csv-file

Re: Scripted upload adds empty lines to csv-file

Documentation

Support

Associations

Follow Us