Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Exporting .csv from home directory

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Exporting .csv from home directory
# 1  
Old 06-20-2012
Exporting .csv from home directory
I have created 2 .csv files in my home directory in unix and trying to export them to my machine. Can anyone tell me the script to export those? 1 file name is columns.csv
# 2  
Old 06-20-2012
What do you mean by 'export'? Download?

Try scp.
Code:
scp username@host:/path/to/file.csv ./

# 3  
Old 06-20-2012
Yes I guess download it from my Unix home dir to my local machine

---------- Post updated at 02:51 PM ---------- Previous update was at 02:47 PM ----------

I ran this and I am not sure where on my local machine it is sending it to.
# 4  
Old 06-20-2012
The current directory (of the shell you ran it in).
# 5  
Old 06-20-2012
On which OS do your source & target PCs run ?
# 6  
Old 06-20-2012
Windows is my OS and the target is the same. The current directory is

tmill29@sasprd2:/home/prd/tmill29

The file in that directory I want to put on my local machine that is Windows is columns.csv and tables.csv

I am just not sure how to export it or download it to my machine.
# 7  
Old 06-20-2012
See, that's important. No wonder it didn't work -- you were running scp on the wrong machine, sending the file from one machine, to the same machine...

It will be much easier to tell Windows to retrieve the file than to tell UNIX to send it. Run winscp or pscp or the like on the Windows host.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

SunOS confusing root directory and user home directory

Hello, I've just started using a Solaris machine with SunOS 5.10. After the machine is turned on, I open a Console window and at the prompt, if I execute a pwd command, it tells me I'm at my home directory (someone configured "myuser" as default user after init). ... (2 Replies)
Discussion started by: egyassun
2 Replies

2. Shell Programming and Scripting

Remove duplicate commas after exporting excel file to csv

Hello everyone I'm new here and this is my first post so first of all I want to say that this is a great forum and I have managed to found most of my answers in these forums : ) So with that I ask you my first question: I have an excel file which I saved as a csv. However the excel file... (3 Replies)
Discussion started by: Spunkerspawn
3 Replies

3. Shell Programming and Scripting

Retaining the Unix CSV format in Excel format while exporting

Hi All, I have created a Unix Shell script whch creates a *.csv file and export it to Excel. The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example : if the Amount has the value as 3000000 User wants to be in 3,000,000 format. This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies

4. Shell Programming and Scripting

Exporting data as a CSV file from Unix shell script

Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome. Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ? The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies

5. Shell Programming and Scripting

Exporting .csv file into mysql server 2005 using script.

Hi, I have a .csv file created by a script with data in a tabular format. I need to insert all the value into mysql database which is running in a different machine. what is the command to export the .csv file into database using shell script. Thanks in advance. (3 Replies)
Discussion started by: ahamed
3 Replies

6. Solaris

Restricting SFTP user to a defined directory and home directory

Hi, I've created solaris user which has both FTP and SFTP Access. Using the "ftpaccess" configuration file options "guest-root" and "restricted-uid", i can restrict the user to a specific directory. But I'm unable to restrict the user when the user is logged in using SFTP. The aim is to... (1 Reply)
Discussion started by: sftpuser
1 Replies

7. Shell Programming and Scripting

exporting number into .csv file in text form (no other extra charc) from shell script

I have written a k shell program which is executing a sql and exporting data in numeric form like 0412323444 into .csv file. the problem i am facing is that , the data is coming in excel formatted in scientific form like 4.1+E08,while my requirement is to store data as such 0412323444 in excel ( no... (5 Replies)
Discussion started by: Deepak_Rastogi
5 Replies

8. Shell Programming and Scripting

Exporting text file data to csv

Could any one help me in basic shell script to export text file data to csv. I need to export only particular data from text file to csv column. I am a newbie to UNIX could anyone help me with sample script code (3 Replies)
Discussion started by: l_jayakumar
3 Replies

9. UNIX for Advanced & Expert Users

exporting a directory

How do I export a directory ? I am trying to link the directory from another machine. (2 Replies)
Discussion started by: brv
2 Replies
Login or Register to Ask a Question