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,
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)
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)
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)
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)
Hi all
i have a such question this is my shell script my script must upload file to webdav server
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
#!/bin/sh
###... (1 Reply)
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)
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)
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)
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
LEARN ABOUT REDHAT
pilot-addresses
pilot-addresses(1) General Commands Manual pilot-addresses(1)NAME
pilot-addresses - read and write address book databases to and from a Palm handheld device, such as those made from Palm, Handspring, Han-
dera, TRGPro, Sony or other Palm Compatible Handheld PDA device
SYNOPSIS
pilot-addresses -p <port> [-c category ] [-d category ] [-r file | -w file ]
(Note that some options are not shown above)
DESCRIPTION
pilot-addresses allows the user to read all entries in the Palm address book database, write new entries into the database, and delete a
category or delete all entries in the database.
TARGET DEVICE
The default serial device used to communicate with a Palm is /dev/pilot. If the environment variable $PILOTPORT is set, its value will
override the default. A serial device specified on the command-line will be used regardless of any $PILOTPORT setting.
OPTIONS
Several options exist, including...
-p --port <port>,
Use device file port to communicate with the Palm handheld device. If this is not specified, will look for the $PILOTPORT environ-
ment variable. If both are not found, will fall back to /dev/pilot.
-h --help
Display help synopsis for pilot-addresses
-v --version
Display version of pilot-addresses
-a Augments fields in address book records with additional information. The augmented information is placed before and separated from
the field with a semi-colon, (;).
Augmented information includes:
category_name - placed in front of each record or
["Work" | "Home" | "Fax" | "Other" | "E-mail" | "Main" | "Pager" | "Mobile" ] - placed in front of each phone number field.
Empty fields are not augmented.
-c category
Install records to category category by default. Normally pilot-addresses uses Unfiled as the default category. This option is over-
ridden by the category specified in the record with the -a option.
-d category
Delete all records in the specified category before installing new records.
-D Delete all address book records in all categories. Obviously, be very careful with this one.
-e Escape all special characters with a backslash. This enables you to read and write entries with newline characters in a field or
note.
-q Causes pilot-addresses to be quiet and not prompt you to press the HotSync button.
-r file
Reads records from file and install them to the Palm address book database. (Use the -w file to get a template file for input
records.)
-t delim
Include category in each record, use the delimiter specified to separate all fields of a record. Delimiters are specified as fol-
lows: 3=tab, 2=;, 1=,. This overrides the default delimiter of comma between fields and semi-colon between a field's augmented
information. (Please note that this may generate confusing results when used with the -a option.)
-T Write a header line with field titles as the first line of the data file.
-w file
Get all address book records from the Palm address book database and writes them into file
USAGE
The program will connect to a target device and port, prompt the user to HotSync, and perform the requested read or write operation speci-
fied by the user.
EXAMPLES
To write all address records in a Palm to the file addrbook.csv:
pilot-addresses -w addrbook.csv
or
pilot-addresses -p /dev/irnine -w addrbook.csv
To read the address book records in the file addrbook.csv and install them on a Palm:
pilot-addresses -r addrbook.csv
To read the address book records in the file addrbook.csv and place them into the Palm address book database category Special after first
deleting all current records in the Special category on the palm:
pilot-addresses -c Special -d Special -r addrbook.csv
SEE ALSO pilot-link(7)KNOWN BUGS
pilot-addresses has no known bugs.
REPORTING BUGS
Report bugs at http://bugs.pilot-link.org/
AUTHOR
pilot-addresses originally written by Kenneth Albanowski, manual page was written by Robert Wittig <bob.wittig@gt.org>.
Free Software Foundation Palm Computing Device Tools pilot-addresses(1)