Sponsored Content
Special Forums IP Networking Proxy Server Upload file from desktop to UNIX server via putty Post 302886364 by clx on Friday 31st of January 2014 01:55:10 AM
Old 01-31-2014
Quote:
Originally Posted by Analabhatla
1. I'm able to ftp the file from desktop to Unix directory via windows cmd. Will there be any way to perform this FTP operation via UNIX directly? I meant logging in to putty and then ftp to desktop location and then get the file to unix directory. This way it will help me to automate the uploading process for other csv files.
Sorry but cant help you in this, this is something you need to contact your network/admin to check at firewall side whether the relative port is open or not. you need to provide the windows hostname/ipaddress to them.


Quote:
Originally Posted by Analabhatla
2. The csv file has the 4 fields and sql's that i need to run on database are present in 3rd field. I need help in writing the command / script which reads the sql in 3rd field for all the records and run it against the database and fill the result back in to last field of the file?
Does this mean you want to extract third filed from CSV? If yes,
do something like,

Code:
while IFS=, read first second third forth
do
 # do stuffs here with any field you want
 # with $first, $second, $third and $forth variables
done < your_csv_file

 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
FTPCHROOT(5)						      BSD File Formats Manual						      FTPCHROOT(5)

NAME
ftpchroot -- list users and groups subject to FTP access restrictions DESCRIPTION
The file ftpchroot is read by ftpd(8) at the beginning of an FTP session, after having authenticated the user. Each line in ftpchroot corre- sponds to a user or group. If a line in ftpchroot matches the current user or a group he is a member of, access restrictions will be applied to this session by changing its root directory with chroot(2) to that specified on the line or to the user's login directory. The order of records in ftpchroot is important because the first match will be used. Fields on each line are separated by tabs or spaces. The first field specifies a user or group name. If it is prefixed by an ``at'' sign, '@', it specifies a group name; the line will match each user who is a member of this group. As a special case, a single '@' in this field will match any user. A username is specified other- wise. The optional second field describes the directory for the user or each member of the group to be locked up in using chroot(2). Be it omit- ted, the user's login directory will be used. If it is not an absolute pathname, then it will be relative to the user's login directory. If it contains the /./ separator, ftpd(8) will treat its left-hand side as the name of the directory to do chroot(2) to, and its right-hand side to change the current directory to afterwards. FILES
/etc/ftpchroot EXAMPLES
These lines in ftpchroot will lock up the user ``webuser'' and each member of the group ``hostee'' in their respective login directories: webuser @hostee And this line will tell ftpd(8) to lock up the user ``joe'' in /var/spool/ftp and then to change the current directory to /joe, which is rel- ative to the session's new root: joe /var/spool/ftp/./joe And finally the following line will lock up every user connecting through FTP in his respective ~/public_html, thus lowering possible impact on the system from intrinsic insecurity of FTP: @ public_html SEE ALSO
chroot(2), group(5), passwd(5), ftpd(8) BSD
January 26, 2003 BSD
All times are GMT -4. The time now is 09:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy