Page 1 of 1
CSV wont transfer
Posted: 2019-05-07 23:25
by jeb2431
I have to send data to a parent company through the SFTP system. When I send the data all of the cells are missing and there is only a long string of words separated by commas. I do know what CSV is, but is there anyway to keep it in the proper format.
Re: CSV wont transfer
Posted: 2019-05-08 06:52
by botg
Looks like the receiving end is using Windows and does not know about the line ending format used by more modern platforms.
Convert the line ending format of your file from Unix to Windows with your favorite line ending conversion tool.
Re: CSV wont transfer
Posted: 2019-05-08 20:44
by jeb2431
Thank you for the help. Do you think I need to get new software to share the data by CSV?
Re: CSV wont transfer
Posted: 2019-05-08 22:13
by botg
No.
Re: CSV wont transfer
Posted: 2019-05-08 23:10
by boco
The problem is that the SFTP protocol version used in FileZilla does transfer all files in binary, in other words, line-endings will not be converted between different OS. If you did transfer using FTP, instead, they would be converted between CRLF (Windows) and LF (UNIX) format upon transfer (as ASCII).
So, your options are:
1. Transfer using FTP,
2. convert line endings to Windows format on your system before uploading,
3. convert line endings on the server after upload.