Topic "Extra lines in CSV files"

Author Message
boudreaux27514
[View user's profile]

Joined: 2011-02-11
Posts: 2
I recently switched from WS-FTP to WinSCP to download CSV files for import into our database. When I view the file from one of our outsource companies it looks the same as it always has but when I attempt to import it, blank records appear between each line. Changing File Transfer mode from auto to ascii made no difference.

WinSCP Version 4.3.1 (Build 1099)
Microsoft Windows XP Professional version 5.1.2600 Service Pack 3 Build 2600
Transfer protocol FTP
Using GUI Commander
Connecting to UNIX Type: L8

. 2011-02-11 11:18:21.069 --------------------------------------------------------------------------
. 2011-02-11 11:18:21.069 WinSCP Version 4.3.1 (Build 1099) (OS 5.1.2600 Service Pack 3)
. 2011-02-11 11:18:21.069 Login time: Friday, February 11, 2011 11:18:21 AM
. 2011-02-11 11:18:21.069 --------------------------------------------------------------------------
. 2011-02-11 11:18:21.069 Session name: southern@secured-processing.com
. 2011-02-11 11:18:21.069 Host name: secured-processing.com (Port: 21)
. 2011-02-11 11:18:21.069 User name: southern (Password: No, Key file: No)
. 2011-02-11 11:18:21.069 Tunnel: No
. 2011-02-11 11:18:21.069 Transfer Protocol: FTP
. 2011-02-11 11:18:21.069 Ping type: C, Ping interval: 30 sec; Timeout: 15 sec
. 2011-02-11 11:18:21.069 Proxy: none
. 2011-02-11 11:18:21.069 FTP: FTPS: None; Passive: Yes [Force IP: No]
. 2011-02-11 11:18:21.069 Local directory: J:\Shared\allboutbaskets\AGBDone, Remote directory: /, Update: No, Cache: Yes
. 2011-02-11 11:18:21.069 Cache directory changes: Yes, Permanent: Yes
. 2011-02-11 11:18:21.069 DST mode: 1
. 2011-02-11 11:18:21.069 --------------------------------------------------------------------------
. 2011-02-11 11:18:21.069 Password prompt (no password provided or last login attempt failed)
. 2011-02-11 11:18:25.725 Connecting to secured-processing.com ...
. 2011-02-11 11:18:25.757 Connected with secured-processing.com. Waiting for welcome message...
< 2011-02-11 11:18:25.804 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
< 2011-02-11 11:18:25.804 220-You are user number 1 of 50 allowed.
< 2011-02-11 11:18:25.804 220-Local time is now 11:19. Server port: 21.
< 2011-02-11 11:18:25.804 220 You will be disconnected after 15 minutes of inactivity.
> 2011-02-11 11:18:25.804 USER southern
< 2011-02-11 11:18:25.851 331 User southern OK. Password required
> 2011-02-11 11:18:25.851 PASS ************
< 2011-02-11 11:18:25.960 230-User southern has group access to: secured
< 2011-02-11 11:18:25.960 230 OK. Current restricted directory is /
> 2011-02-11 11:18:25.960 SYST
< 2011-02-11 11:18:25.991 215 UNIX Type: L8
> 2011-02-11 11:18:25.991 FEAT
< 2011-02-11 11:18:26.054 211-Extensions supported:
< 2011-02-11 11:18:26.054 EPRT
< 2011-02-11 11:18:26.054 IDLE
< 2011-02-11 11:18:26.054 MDTM
< 2011-02-11 11:18:26.054 SIZE
< 2011-02-11 11:18:26.054 REST STREAM
< 2011-02-11 11:18:26.054 MLST type*;size*;sizd*;modify*;UNIX.mode*;UNIX.uid*;UNIX.gid*;unique*;
< 2011-02-11 11:18:26.054 MLSD
< 2011-02-11 11:18:26.054 AUTH TLS
< 2011-02-11 11:18:26.054 PBSZ
< 2011-02-11 11:18:26.054 PROT
< 2011-02-11 11:18:26.054 ESTA
< 2011-02-11 11:18:26.054 PASV
< 2011-02-11 11:18:26.054 EPSV
< 2011-02-11 11:18:26.054 SPSV
< 2011-02-11 11:18:26.054 ESTP
< 2011-02-11 11:18:26.054 211 End.
. 2011-02-11 11:18:26.054 Connected
. 2011-02-11 11:18:26.054 --------------------------------------------------------------------------
. 2011-02-11 11:18:26.054 Using FTP protocol.
. 2011-02-11 11:18:26.054 Doing startup conversation with host.
> 2011-02-11 11:18:26.054 PWD
< 2011-02-11 11:18:26.101 257 "/" is your current location
. 2011-02-11 11:18:26.101 Changing directory to "/".
> 2011-02-11 11:18:26.101 CWD /
< 2011-02-11 11:18:26.147 250 OK. Current directory is /
. 2011-02-11 11:18:26.147 Getting current directory name.
> 2011-02-11 11:18:26.147 PWD
< 2011-02-11 11:18:26.210 257 "/" is your current location
. 2011-02-11 11:18:26.210 Retrieving directory listing...
> 2011-02-11 11:18:26.210 TYPE A
< 2011-02-11 11:18:26.257 200 TYPE is now ASCII
> 2011-02-11 11:18:26.257 PASV
< 2011-02-11 11:18:26.304 227 Entering Passive Mode (67,227,214,178,145,65)
> 2011-02-11 11:18:26.304 LIST -a
< 2011-02-11 11:18:26.429 150 Accepted data connection
< 2011-02-11 11:18:26.694 226-Options: -a -l
< 2011-02-11 11:18:26.694 226 470 matches total
. 2011-02-11 11:18:26.726 Directory listing successful
. 2011-02-11 11:18:26.726 Startup conversation with host finished.
. 2011-02-11 11:18:26.835 Disconnected from server
. 2011-02-11 11:18:31.742 File: "/201102110705.txt"
. 2011-02-11 11:18:31.742 Copying "/201102110705.txt" to local directory started.
. 2011-02-11 11:18:31.742 Ascii transfer mode selected.
. 2011-02-11 11:18:31.742 Starting download of /201102110705.txt
. 2011-02-11 11:18:31.757 Asking user:
. 2011-02-11 11:18:31.757 Local file '201102110705.txt' already exists. Overwrite?
. 2011-02-11 11:18:31.757
. 2011-02-11 11:18:31.757 New: 6413 bytes, 2/11/2011 8:05 AM
. 2011-02-11 11:18:31.757 Existing: 6423 bytes, 2/11/2011 8:05:00 AM ()
> 2011-02-11 11:18:33.195 TYPE A
< 2011-02-11 11:18:33.242 200 TYPE is now ASCII
> 2011-02-11 11:18:33.242 PASV
< 2011-02-11 11:18:33.288 227 Entering Passive Mode (67,227,214,178,6,223)
> 2011-02-11 11:18:33.288 RETR 201102110705.txt
< 2011-02-11 11:18:33.382 150-Accepted data connection
< 2011-02-11 11:18:33.382 150 6.3 kbytes to download
< 2011-02-11 11:18:33.382 226-File successfully transferred
< 2011-02-11 11:18:33.382 226 0.000 seconds (measured here), 40.59 Mbytes per second
. 2011-02-11 11:18:33.445 Download successful
. 2011-02-11 11:27:39.698 Disconnected from server
. 2011-02-11 13:11:12.689 --------------------------------------------------------------------------
. 2011-02-11 13:11:12.705 WinSCP Version 4.2.9 (Build 938) (OS 5.1.2600 Service Pack 3)
. 2011-02-11 13:11:12.705 Login time: Friday, February 11, 2011 1:11:12 PM
. 2011-02-11 13:11:12.705 --------------------------------------------------------------------------
. 2011-02-11 13:11:12.705 Session name: southern@secured-processing.com
. 2011-02-11 13:11:12.705 Host name: secured-processing.com (Port: 21)
. 2011-02-11 13:11:12.705 User name: southern (Password: No, Key file: No)
. 2011-02-11 13:11:12.705 Tunnel: No
. 2011-02-11 13:11:12.705 Transfer Protocol: FTP
. 2011-02-11 13:11:12.705 Ping type: C, Ping interval: 30 sec; Timeout: 15 sec
. 2011-02-11 13:11:12.705 Proxy: none
. 2011-02-11 13:11:12.705 FTP: FTPS: None; Passive: No [Force IP: No]
. 2011-02-11 13:11:12.705 Local directory: J:\Shared\allboutbaskets\AGBDone, Remote directory: /, Update: No, Cache: Yes
. 2011-02-11 13:11:12.705 Cache directory changes: Yes, Permanent: Yes
. 2011-02-11 13:11:12.705 DST mode: 1
. 2011-02-11 13:11:12.705 --------------------------------------------------------------------------
. 2011-02-11 13:11:12.736 Password prompt (no password provided or last login attempt failed)
. 2011-02-11 13:11:16.441 Connecting to secured-processing.com ...
. 2011-02-11 13:11:16.707 Connected with secured-processing.com. Waiting for welcome message...
< 2011-02-11 13:11:16.754 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
< 2011-02-11 13:11:16.754 220-You are user number 1 of 50 allowed.
< 2011-02-11 13:11:16.754 220-Local time is now 13:12. Server port: 21.
< 2011-02-11 13:11:16.754 220 You will be disconnected after 15 minutes of inactivity.
> 2011-02-11 13:11:16.754 USER southern
< 2011-02-11 13:11:16.801 331 User southern OK. Password required
> 2011-02-11 13:11:16.801 PASS ************
< 2011-02-11 13:11:16.894 230-User southern has group access to: secured
< 2011-02-11 13:11:16.894 230 OK. Current restricted directory is /
> 2011-02-11 13:11:16.894 SYST
< 2011-02-11 13:11:16.926 215 UNIX Type: L8
> 2011-02-11 13:11:16.926 FEAT
< 2011-02-11 13:11:16.973 211-Extensions supported:
< 2011-02-11 13:11:16.973 EPRT
< 2011-02-11 13:11:16.973 IDLE
< 2011-02-11 13:11:16.973 MDTM
< 2011-02-11 13:11:16.973 SIZE
< 2011-02-11 13:11:16.973 REST STREAM
< 2011-02-11 13:11:16.973 MLST type*;size*;sizd*;modify*;UNIX.mode*;UNIX.uid*;UNIX.gid*;unique*;
< 2011-02-11 13:11:16.973 MLSD
< 2011-02-11 13:11:16.973 AUTH TLS
< 2011-02-11 13:11:16.973 PBSZ
< 2011-02-11 13:11:16.973 PROT
< 2011-02-11 13:11:16.973 ESTA
< 2011-02-11 13:11:16.973 PASV
< 2011-02-11 13:11:16.973 EPSV
< 2011-02-11 13:11:16.973 SPSV
< 2011-02-11 13:11:16.973 ESTP
< 2011-02-11 13:11:16.973 211 End.
. 2011-02-11 13:11:16.973 Connected
. 2011-02-11 13:11:16.973 --------------------------------------------------------------------------
. 2011-02-11 13:11:16.973 Using FTP protocol.
. 2011-02-11 13:11:16.973 Doing startup conversation with host.
> 2011-02-11 13:11:16.988 PWD
< 2011-02-11 13:11:17.035 257 "/" is your current location
. 2011-02-11 13:11:17.035 Changing directory to "/".
> 2011-02-11 13:11:17.035 CWD /
< 2011-02-11 13:11:17.082 250 OK. Current directory is /
. 2011-02-11 13:11:17.082 Getting current directory name.
> 2011-02-11 13:11:17.082 PWD
< 2011-02-11 13:11:17.129 257 "/" is your current location
. 2011-02-11 13:11:17.129 Retrieving directory listing...
> 2011-02-11 13:11:17.129 TYPE A
< 2011-02-11 13:11:17.160 200 TYPE is now ASCII
> 2011-02-11 13:11:17.160 PORT 192,168,0,88,4,82
< 2011-02-11 13:11:17.207 200 PORT command successful
> 2011-02-11 13:11:17.207 LIST -a
< 2011-02-11 13:11:17.285 150 Connecting to port 1106
< 2011-02-11 13:11:17.520 226-Options: -a -l
< 2011-02-11 13:11:17.520 226 470 matches total
. 2011-02-11 13:11:17.770 Directory listing successful
. 2011-02-11 13:11:17.770 Startup conversation with host finished.
. 2011-02-11 13:11:23.507 File: "/201102110705.txt"
. 2011-02-11 13:11:23.507 Copying "/201102110705.txt" to local directory started.
. 2011-02-11 13:11:23.507 Ascii transfer mode selected.
. 2011-02-11 13:11:23.507 Starting download of /201102110705.txt
. 2011-02-11 13:11:23.523 Asking user:
. 2011-02-11 13:11:23.523 Local file '201102110705.txt' already exists. Overwrite?
. 2011-02-11 13:11:23.523
. 2011-02-11 13:11:23.523 New: 6413 bytes, 2/11/2011 8:05 AM
. 2011-02-11 13:11:23.523 Existing: 6423 bytes, 2/11/2011 8:05:00 AM ()
> 2011-02-11 13:11:27.603 TYPE A
< 2011-02-11 13:11:27.634 200 TYPE is now ASCII
> 2011-02-11 13:11:27.634 PORT 192,168,0,88,4,83
< 2011-02-11 13:11:27.681 200 PORT command successful
> 2011-02-11 13:11:27.681 RETR 201102110705.txt
< 2011-02-11 13:11:27.790 150-Connecting to port 1107
< 2011-02-11 13:11:27.790 150 6.3 kbytes to download
< 2011-02-11 13:11:27.790 226-File successfully transferred
< 2011-02-11 13:11:27.790 226 0.000 seconds (measured here), 45.70 Mbytes per second
. 2011-02-11 13:11:28.025 Download successful
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
What line endings has the source file? What line endings should the destination file have? Have you tried using binary mode?
_________________
Martin Prikryl
Guest




prikryl wrote:
What line endings has the source file? What line endings should the destination file have? Have you tried using binary mode?


Yes, binary mode corrects the problem.

Mark Boudreaux
Mahshid

Guest


This is the ideal aneswr. Everyone should read this
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License