04-02-2008
typical mail script
hi i have a requirement to write a mail script which needs to be automated.There are 7 CSV files generated for 7 clients in a single day.Each file will contain one header and the name of the file follows a nomenclature like ABC_20080402_ClientID.csv.ClientID is lets say AJAT,THUJH,RTYUJ,TJJIGF,HTUKG,HUJGD,THYIUJ for 7 files and 20080402 is the rundate.If the file contains more than one record then it should appear in the mail along with its record count.
The path of the files are /data.
The mail should appear in the following format
The subject line should be : files generated for 02-Apr-2008
_____________________________________________
Hi All
The files are generated for the date 02-Apr-2008 successfully.
Following are the details:
File Name : ABC_20080402_AJAT.csv
Rec Count:200
File Name : ABC_20080402_THUJH.csv
Rec Count:1000
<Record counts should be picked from the file system>
There are zero records for the clients TYUJ,TJJIGF,HTUKG,HUJGD and THYIUJ.<This line should not appear if the no. of records in all the files are more than 1>
Regards,
Team
______________________________________________
Please help me in writing the script.It would be better if the file names appear in the bold font.Can we use HTML in writing the shell script so that mail will look good??
Waiting for reply
8 More Discussions You Might Find Interesting
1. Solaris
I want to disable some services starting automatically while system booting, for instance if i want to disable vold what i have to do ? i think some services related to a script init level shell directory,and i think as well that since solaris 10 they added a command to enable and disable services... (2 Replies)
Discussion started by: XP_2600
2 Replies
2. Shell Programming and Scripting
Hi All,
Is there any way Unix shell script can directly read a mail on a mail server
(for eg. abc@xyz.com) and save it as a text file in a unix directory ?
Thanks
PRKS
---------- Post updated at 08:37 AM ---------- Previous update was at 08:36 AM ----------
I am using ksh (1 Reply)
Discussion started by: PRKS
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
What is the use of the signal -3 in kill command in unix?
I read the meaning and typical use of this signal in one of the Oreilly books as below.
Quit -- stop running (and dump core). Sent when you type CTRL-\.
what does the CTRL-\ command do? Is it the combination of CTRL and... (6 Replies)
Discussion started by: venkatesht
6 Replies
4. Shell Programming and Scripting
Hi All,
I need to store the output of "find ." to an array one by one. Output of find . in my case will look like :-
.
./one
./one/a
./one/b
./one/c
./two
So my first array element should be "/one" and second one "/one/a" (need to remove "." from the output as well).
Then I need to... (11 Replies)
Discussion started by: Renjesh
11 Replies
5. Shell Programming and Scripting
Hi ,
I have a txt file with contents like:
1234
2345
3456
7891
I need to write a script which takes input file as txt file..run a sql query for that number and place the output of query in another file..
select * from bus_event where acct_nbr='1234'( from input txt file)
the query... (20 Replies)
Discussion started by: Rajesh Putnala
20 Replies
6. Emergency UNIX and Linux Support
Hi Experts,
In a particular dir, I have many files *AJAY*.
How can I get total size of all such files.
I tried du -hs *AJAY* but it gave me individual size of all files.
All I require is summation of all.
Thanks,
Ajay (4 Replies)
Discussion started by: ajaypatil_am
4 Replies
7. Shell Programming and Scripting
Input file
I have a file with four fields.
f1,f2,f3,f4
A,1,10,00,S
B,2,20,00,00,D
C,3,100,00,00,G
I want Output like
f1|f2|f3|f4
A|1|10,00|S
B|2|20,00,00|D
C|3|100,00,00|G
please help on this (4 Replies)
Discussion started by: bharat1211
4 Replies
8. UNIX for Dummies Questions & Answers
I am quite new to compiling source codes in linux and have been running into a lot of problems in trying to do so since the platform configuration is different from most.
For starters, I know that you need to enter the following commands in order to install any software manually in linux:... (2 Replies)
Discussion started by: Ice_Drake1
2 Replies
SHAR(1) BSD General Commands Manual SHAR(1)
NAME
shar -- create a shell archive of files
SYNOPSIS
shar file ...
DESCRIPTION
shar writes an sh(1) shell script to the standard output which will recreate the file hierarchy specified by the command line operands.
Directories will be recreated and must be specified before the files they contain (the find(1) utility does this correctly).
shar is normally used for distributing files by ftp(1) or mail(1).
SEE ALSO
compress(1), mail(1), tar(1), uuencode(1)
BUGS
shar makes no provisions for special types of files or files containing magic characters.
EXAMPLES
To create a shell archive of the program ls(1) and mail it to Rick:
cd ls
shar `find . -print` | mail -s "ls source" rick
To recreate the program directory:
mkdir ls
cd ls
...
<delete header lines and examine mailed archive>
...
sh archive
HISTORY
The shar command appears in 4.4BSD.
SECURITY CONSIDERATIONS
It is easy to insert trojan horses into shar files. It is strongly recommended that all shell archive files be examined before running them
through sh(1). Archives produced using this implementation of shar may be easily examined with the command:
egrep -v '^[X#]' shar.file
4.4BSD June 6, 1993 4.4BSD