CSV wont transfer
Moderator: Project members
-
- 500 Command not understood
- Posts: 2
- Joined: 2019-05-07 23:19
- First name: Joel
- Last name: Brown
CSV wont transfer
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
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.
Convert the line ending format of your file from Unix to Windows with your favorite line ending conversion tool.
-
- 500 Command not understood
- Posts: 2
- Joined: 2019-05-07 23:19
- First name: Joel
- Last name: Brown
Re: CSV wont transfer
Thank you for the help. Do you think I need to get new software to share the data by CSV?
Re: CSV wont transfer
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.
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.
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org