Get all the files from a FTP location with previous week's dates in the file names using Linux
I have a weird requirement where I have to get the files from a FTP(Lets say FTP1) location and place it on my current FTP(Lets say FTP2) location. The issue is, these are daily files (in a pattern Sales_YYYYMMDD_report.csv) and are placed every day on FTP1 and my process usually runs on Monday(eg. 09-Sept-2013) which has to use the file of the previous week starting from Sunday(eg. 01-Sept-2013) to Saturday(eg. 07-Sept-2013) place them on FTP2 location and then run the Informatica process. For an instance, if I run the process on Monday,09-Sept-2013, I have to pull all the files from FTP1 which have file names such as
How can I achieve this in a shell script? I know the part to get the files from another FTP, but I am not sure how to get the 7 files.
P.S: I cannot use the file creation/last modified timestamps to get the files. Irrespective of the created timestamp and the day I run my Informatica process, I have to get the files which have last week's dates in the file names and put in my FTP2 location and then continue with them.
Hi guys,
Is there a way I can ftp some files without changing the last-modified dates from them ?
I haven't seen any ftp option to do so.
Or, alternatively, how do I change the last-modified date for a file, if this is possible... ?
Thanks in advance,
Abrahao. (4 Replies)
Hi,
I have problem of filtering a log file from my perl script.
#cat /data/pinpe.csv_20070731 | nawk -v FS=, '{print $1','$18','$22','$26}' | grep -w 100 | grep -w 1 | nawk '{print $4}'
Below is the output:
2009-06-16
2009-01-29
2009-06-02
2008-03-05
2007-08-05
2007-09-24... (5 Replies)
Hi All,
Here is a brief scenario for my requirement ..
There is a directory in FTP Server, where would files be uploaded on weekly basic.
I need to get those files which are uploaded during this week and not the files which are uploaded the previous week and download them to locale... (1 Reply)
hi,
I have one file located in ftp.I want to place that file in different ftp location.
Up to now i am doing it manually using get command and copying that file in to my local system and then putting that file in different ftp using put command.
now i want to automate that using shell... (1 Reply)
I am having a requirement to check whether files were there in the ftp location and if the files were not there then need to send a mail to someone.Suppose there were files like A,B,C,D,etc.. if the file A was not there then mail to someone similarly for all the files.
Thanks for your help.
... (2 Replies)
HI there. I am studying System administration right now and am stuck on a question that I have failed to find the answer for in my book.
The question is: Do device files need to be in the /dev directory and to they need to follow a naming convention?
My answer (so far) is that since the... (7 Replies)
Hi All,
I have a scenario where I need to download the previous day modified files from other server to my server through FTP . Could any one please send me the shell script for the same.
I used the following but I dont know how to proceed after this.
ftp -n -i -v $IP <<ENDOFinPUT >>... (3 Replies)
Hi All,
I have a .txt file with the list of filenames as given below.
/dev_data/dev3/ctl/20120622_Employee.txt
/dev_data/dev3/ctl/20120623_Employee.txt
/dev_data/dev3/ctl/20120624_Employee.txt
I want to read this file & write the dates alone from the filenames into a .done file.
... (6 Replies)
I have to increase the date by one week in an input when script is executed in solaris. I was able to acheive this using ksh script that is working in Linux enivironment, when i execute the same script in Solaris i am getting below error:
/var/tmp\n\r-> ./script.ksh
date: illegal option -- d... (3 Replies)
Hi,
I'm using a shell script. I have extracted current date files to a directory1 and the date should be removed on both sides of a CSV file.
FYI... I'm looking to remove the date from the file name and not inside the CSV file.
Directory1
2017-07-12_gmr_tag_log_20170711.csv... (0 Replies)
Discussion started by: shivamayam
0 Replies
LEARN ABOUT DEBIAN
bb-csvinfo.cgi
BB-CSVINFO.CGI(1) General Commands Manual BB-CSVINFO.CGI(1)NAME
bb-csvinfo.cgi - CGI program to show host information from a CSV file
SYNOPSIS
bb-csvinfo.cgi
DESCRIPTION
bb-csvinfo.cgi is invoked as a CGI script via the bb-csvinfo.sh CGI wrapper. Based on the parameters it receives, it searches a comma-
separated file for the matching host, and presents the information found as a table.
bb-csvinfo.cgi is passed a QUERY_STRING environment variable with the following parameters:
key (string to search for, typically hostname)
column (columnnumber to search - default 0)
db (name of the CSV database file in $BBHOME/etc/, default hostinfo.csv)
delimiter (delimiter character for columns, default semi-colon)
CSV files are easily created from e.g. spreadsheets, by exporting them in CSV format. You should have one host per line, with the first
line containing the column headings. Despite their name, the default delimiter for CSV files is the semi-colon - if you need a different
delimiter, invoke bb-csvinfo.cgi with the "delimiter=<character>" in the query string.
Example usage
This example shows how you can use the bb-csvinfo CGI. It assumes you have a CSV-formatted file with information about the hosts stored as
$BBHOME/etc/hostinfo.csv, and the hostname is in the first column of the file.
Use with the bbgen --docurl
The --docurl option to bbgen(1) sets up all of the hostnames on your Xymon webpages to act as links to a CGI script. To invoke the
bb-csvinfo CGI script, run bbgen with the option
--docurl=/cgi-bin/bb-csvinfo.sh?db=hostinfo.csv&key=%s
SEE ALSO bb-hosts(5), hobbitserver.cfg(5), bbgen(1)Xymon Version 4.2.3: 4 Feb 2009 BB-CSVINFO.CGI(1)