Proxy Server

I have a requirement of following -
1. Transfer excel spreadsheet from desktop to unix server
2. Open the spreadsheet and read the sql row by row at a time
3. Run each sql on database using unix and then send output back to spreadsheet that was uploaded earlier and then transfer file back to desktop results.

I'm dummy and need help

Hi Analabhatla,

Welcome to the forum.
It would be great if you could answer the following questions.

1, Is this task a one time activity or you want to automate this?
2, Do you know whether your proxy/network/firewall supports ftp/sftp/both/none?
3, Is there any restriction/Policy which blocks uploading data local to remote?
4, Do you have at least basic Unix OS experience?

If everything above works, then, Is it allowed if you upload plaintext file (csv) instead of xls to the server? that would save lot of your work.

1, Is this task a one time activity or you want to automate this? No ; its an Automation requirement
2, Do you know whether your proxy/network/firewall supports ftp/sftp/both/none? - Yes ftp and sftp
3, Is there any restriction/Policy which blocks uploading data local to remote? No
4, Do you have at least basic Unix OS experience? - yes but not having the scripting experience.

I tried scp and ftp host name of windows (using cmd>>ipconfig info) but none of them have worked.

Did you try other way? Try connecting from Unix box.

i'm able to transfer file from unix server to desktop by using ftp from cmd. the viceversa is not working.

I tried ftp / scp method from unix server the following way and nothing has worked out. Looks like i'm missing something could you please guide me?

1. logged in to putty
2. then tried ftp <<hostname of desktop >> (got the host name from cmd >>ipconfig /all)

it throws error saying as the hostname not known .

It's not always necessary that vice versa works. Check whether the ports are open at desktop end.

telnet <HOST> <PORT>

default port for ftp and sftp is 21 and 22

I took the hostname of the desktop from cmd and run the command on Unix and it says the hostname not found. any other suggestions?

Could we have an option to cut the columns from the .csv file once uploaded in to unix? I need the last column in the excel sheet to run against the database.