Upload file from desktop to UNIX server via putty


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
Upload file from desktop to UNIX server via putty

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
# 2  
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.
# 3  
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.
# 4  
Did you try other way? Try connecting from Unix box.
# 5  
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 .
# 6  
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
# 7  
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.
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

scp to get a file from windows desktop to UNIX server

Hi, I want to use scp to upload file to my unix server. i am using this: scp D:\testr.txt unixuser@unixhost:/path it returns an error: ssh: D: host/servname not known i am not sure how to tell path of my D drive in the command and how will command understand it has to pick from my... (5 Replies)
Discussion started by: Kohli
5 Replies

2. Shell Programming and Scripting

Generate file and Upload to SFTP server.

Xperts, My requirement is something like this, I have a sql script which i need to embed in a shell. The sql (oracle) script will generate a .csv file in some Unix directory. the approximate file size is around 10 mb which i need to upload to an sftp server. My concern here is how to make... (5 Replies)
Discussion started by: Showdown
5 Replies

3. Shell Programming and Scripting

Script to upload latest file to other server via FTP

Hello, I have a script that finds the latest version of a file in a folder on my Minecraft server. I'm trying to come up with something that will then FTP that file over to my fileserver. Here's what I have that finds the newest file: find /home/mc/archive/sbhouse -type f -mtime +45 -exec... (7 Replies)
Discussion started by: nbsparks
7 Replies

4. Shell Programming and Scripting

Upload files from desktop to unix through FTP

Hi , I want to upload some files from my desktop to unix server through FTP . The list of files are in a text file .Please suggest how to do it through scrip . Thanks in advance .. Anupam (8 Replies)
Discussion started by: anupamhalder
8 Replies

5. Shell Programming and Scripting

upload file to webdav server

Hi all i have a such question this is my shell script my script must upload file to webdav server ////////////////////////////////////////////////////////////////////////////////////////////////////////////// #!/bin/sh ###... (1 Reply)
Discussion started by: knut
1 Replies

6. UNIX for Advanced & Expert Users

Commands to copy a tar.gz file from a Remote Unix Server to Local Desktop.

Hi, Just wanted to know, how can I ftp/transfer/copy a (design.tar.gz) archive from a Unix Server (sdmc222.sdmc.cp-srv.com) which is at a remote location, to my Windows Desktop. Obviously, it is not possible at cmd prompt on my Windows using the following commands :- ftp... (3 Replies)
Discussion started by: marconi
3 Replies

7. Shell Programming and Scripting

upload excel file contents to server

Hi I have an excel file with only 5 rows .I want to uplaod those 5 rows to a database using a shell script.Is this possible.If so where do i start. Thnks (1 Reply)
Discussion started by: magikminox
1 Replies

8. Shell Programming and Scripting

stuck in perl cgi to upload a file to server

hi, i m working on a perl cgi script which uploads a file to the server. i m stuck. i hav written the errors. plz help. Sachin Kaw ______________________________________________________________________ #!/usr/bin/perl -w use CGI; use CGI qw(:standard); use strict; use POSIX... (4 Replies)
Discussion started by: sachin_kaw
4 Replies

9. UNIX for Dummies Questions & Answers

How to upload to the unix server?

I am having problems uploading files to my new server. I am new at this so im sure im doing it wrong. I tried using wsftp but that didnt work. please help me!! (4 Replies)
Discussion started by: rdog157h
4 Replies

Featured Tech Videos