Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Sftp transfer doing as single row

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sftp transfer doing as single row
# 1  
Old 07-16-2015
Sftp transfer doing as single row
Hi All,
I have a file in windows when I transfer it using sftp it is getting as single line. I tried to do both ascii and binary

File:
Quote:
<?xml version="1.0" encoding="utf-8"?>
<DataDictionary xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ppf.xsd">
<Description>E.E. Kids Panel 2015</Description>
<Survey>
<StartDate>2015-03-30</StartDate>
<EndDate>2015-06-26</EndDate>
<ClosingDate>201526</ClosingDate>
<Projectable>Yes</Projectable>
</Survey>
<FieldList>
<Field name="hhid" range="true" col="1" len="8">
is transfered as
Quote:
<?xml version="1.0" encoding="utf-8"?>^M<DataDictionary xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ppf.xsd.xsd">^M <Description>E.E. Kids Panel 2015</Description>^M <Survey>^M <StartDate>2015-03-30</StartDate>^M <EndDate>2015-06-26</EndDate>^M <ClosingDate>201526</ClosingDate>^M <Projectable>Yes</Projectable>^M </Survey>^M <FieldList>
<Field name="hhid" range="true" col="1" len="8">^M
Can you please let me know how can do the transfer as same as XML file

Thanks,
Arun
Last edited by rbatte1; 07-16-2015 at 09:02 AM.. Reason: Converted some CODE tags to ICODE to help it read better.
# 2  
Old 07-16-2015
Hi Arun,
You could use the solution noted in this post once the file is transferred:

Need to remove ^M charecters from all files

Thanks,
Tony
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Execute a script after SFTP transfer

Hi All, I am having an issue with the script execution. I am having a SFTP process that send files to a location . I want to execute a script once it transfer the file to that location. Right now I am leveraging autosys file watcher to do that. Is there any way like MFT PPA that can execute... (2 Replies)
Discussion started by: arunkumar_mca
2 Replies

2. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies

3. Shell Programming and Scripting

File transfer using SFTP

Hi, I want to a transfer file from remote machine to a local machine using SFTP where both my local and remote machines are Ubuntu machines.So i wanted to write a unix bash script which uses SFTP command to transfer the file from remote to local machine. My remote server is 178.28.30.106. ... (14 Replies)
Discussion started by: shree11
14 Replies

4. Shell Programming and Scripting

Passwordless file transfer using sftp

Hello all, I have a requirement, in which we need to stage a package to Unix remote server in an automation (we cant use ssh key generation) , do u have any idea how we can transfer the package to remote server using sftp .if you have any script plz share it to me (4 Replies)
Discussion started by: Ramji Sundaram
4 Replies

5. Shell Programming and Scripting

Sftp : not able to print the echo statements after the sftp transfer

I had the below sftp script working perfectly but the problem is I am not able to send the echo statements . #!/bin/sh echo "Starting to sftp..." sftp admin@myip << END_SCRIPT cd /remotepath/ lcd /localpath/ mget myfiles*.csv bye END_SCRIPT echo "Sftp successfully." echo echo... (11 Replies)
Discussion started by: scriptscript
11 Replies

6. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

7. UNIX for Dummies Questions & Answers

SFTP transfer does not complete

I am able to connect to a site and start a file transfer via SFTP, but when the file reaches "100%" -- the file does not complete and "stop". The 100% transfer status does not change (obviously), but the timer for SFTP keeps going and will not complete. This also happens when I try to get a file.... (2 Replies)
Discussion started by: loganban
2 Replies

8. Shell Programming and Scripting

SFTP with ASCII file transfer

Hello - I have text file and need to load the data in Oracle through sqlloader. I need to move this file to unix server and load into oracle. When i SFTP(unfortunately i do not have FTP) to unix box, each line is appended with ControlM character... since it is transferring in BINARY... (4 Replies)
Discussion started by: govindts
4 Replies

9. Shell Programming and Scripting

sftp file transfer

hi i am trying to login to remote server using SFTP Protocol and trying to upload a file butit is asking for the password. Note: I am trying to connect to FrontEnd server sftp SFTREGUP1@14.71.26.6 Connecting to 14.71.26.6... Password Authentication Password: Please help (14 Replies)
Discussion started by: Satyak
14 Replies

10. UNIX for Advanced & Expert Users

sftp command for file transfer

hi, I need to sftp a file from one unix system to another unix system. eg: filename is test.txt servername : abc@xyz please give me the sftp command for that. thanks in advance.. mohan.p (2 Replies)
Discussion started by: mohanpadamata
2 Replies
Login or Register to Ask a Question