CSV wont transfer

Come here to discuss FileZilla and FTP in general

Moderator: Project members

Post Reply
Message
Author
jeb2431
500 Command not understood
Posts: 2
Joined: 2019-05-07 23:19
First name: Joel
Last name: Brown

CSV wont transfer

#1 Post by jeb2431 » 2019-05-07 23:25

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.

User avatar
botg
Site Admin
Posts: 32472
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse
Contact:

Re: CSV wont transfer

#2 Post by botg » 2019-05-08 06:52

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.

jeb2431
500 Command not understood
Posts: 2
Joined: 2019-05-07 23:19
First name: Joel
Last name: Brown

Re: CSV wont transfer

#3 Post by jeb2431 » 2019-05-08 20:44

Thank you for the help. Do you think I need to get new software to share the data by CSV?

User avatar
botg
Site Admin
Posts: 32472
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse
Contact:

Re: CSV wont transfer

#4 Post by botg » 2019-05-08 22:13

No.

User avatar
boco
Contributor
Posts: 24784
Joined: 2006-05-01 03:28
Location: Germany

Re: CSV wont transfer

#5 Post by boco » 2019-05-08 23:10

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.
### BEGIN SIGNATURE BLOCK ###
No support requests per PM! You will NOT get any reply!!!
FTP connection problems? Do yourself a favor and read Network Configuration.
All FileZilla products fully support IPv6. http://worldipv6launch.org
### END SIGNATURE BLOCK ###

Post Reply