Sending email with multiple files..


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sending email with multiple files..
# 1  
Old 10-29-2010
Sending email with multiple files..

Hello,,
I am loading data into the 4 tables from 4 different input files.
The data gets loaded, and the e-mail is also sent to the user, but the log files for all the 4 files is not been sent..

I am trying to send e-mail to users with the log file as attachment.

The script is as follows:
Code:
logfile="/space/dbexport/PHR/log/condition-`date +%Y%m%d`.log"
logfile1="/space/dbexport/PHR/log/encounter-`date +%Y%m%d`.log"
logfile2="/space/dbexport/PHR/log/procedure-`date +%Y%m%d`.log"
logfile3="/space/dbexport/PHR/log/provider-`date +%Y%m%d`.log"
touch $logfile
touch $logfile1
touch $logfile2
touch $logfile3

 
(
echo "CONDITION, ENCOUNTER & PROCEDURE LOAD PROCESS FINISHED SUCCESSFULLY."
echo "Input file path and the total records it contains and loaded into the table's are shown below."
for filename in /space/dbexport/PHR/data/conditionExport_test.csv /space/dbexport/PHR/data/encounterExport.csv /space/dbexport/PHR/data/procedureExport.csv /
space/dbexport/PHR/data/providerExport.csv
do
# get description from filename, convert to uppercase
#
desc=$(echo $filename|sed 's/Export.*csv//'|tr '[a-z]' '[A-Z]')
# get total record count from file
#
n=$(wc -l < $filename)
echo "$desc: $n"
echo "log file path is:"
echo "$logfile", "$logfile1", "$logfile2", "$logfile3"
echo ""
done
) /space/dbexport/PHR/log/uuencode $logfile, $logfile1, $logfile2, $logfile3 | mailx -s "$subject" "$to" id11355@gmail.com

Can any one please help me as to how to send log files for all the 4 tables loaded as attachment?

Regards

Moderator's Comments:
Mod Comment Use code tags, please...

Last edited by Scott; 10-29-2010 at 05:03 PM.. Reason: Code tags
# 2  
Old 10-29-2010
Before we start.
Please make sure that any other threads you may have open on this subject contain a clear pointer to this thread.
# 3  
Old 10-29-2010
All other threads closed.
# 4  
Old 10-29-2010
First, logfiles are just text, so you could just append them into the body of the email. If they must be attachments, you need a more sophisticated mail client.
Code:
(
 echo "CONDITION, ENCOUNTER & PROCEDURE LOAD PROCESS FINISHED SUCCESSFULLY."
echo "Input file path and the total records it contains and loaded into the table's are shown below."
for filename in /space/dbexport/PHR/data/conditionExport_test.csv /space/dbexport/PHR/data/encounterExport.csv /space/dbexport/PHR/data/procedureExport.csv /
space/dbexport/PHR/data/providerExport.csv
do
# get description from filename, convert to uppercase
#
desc=$(echo $filename|sed 's/Export.*csv//'|tr '[a-z]' '[A-Z]')
# get total record count from file
#
n=$(wc -l < $filename)
echo "$desc: $n"
echo "log file path is:"
echo "$logfile", "$logfile1", "$logfile2", "$logfile3"
echo ""
done

 for log in logdir/*.YYYYMMDD.*
 do
  echo ============== ${log~~*/} ====================
  cat $log
  echo
  echo =========================================
  echo
done | mailx -s "$subject" "$to" id11355@gmail.com

# 5  
Old 10-29-2010
Lots of questions:
Some of the critical variables are not written to by the script as posted.

What should be in $subject ?
What should be in $to ?
What should be in $logfile, $logfile1 $logfile2 $logfile3 .


Imagine I was to receive the email.
What should be in the email subject?
What should be in the email body?
What should be in the email attachments?

Assuming M$ email client, what software should I use to open the attachments? Hint: filename.txt is opened by notepad. filename.log causes a question.

---------- Post updated at 21:47 ---------- Previous update was at 21:44 ----------

@DGPickett
Your solution is syntactically incorrect and naive guesswork.
# 6  
Old 10-29-2010
It is cheaper to send URLs and make the logs visible on a web server. People who get the email and do no have so much interest will skip them.

But methyl is right, notepad will open any URL ending in '.txt', so your logs might need carriage returns and different names.

If you create a simple web service, you can process and deliver them as <PRE> text (you have to take care of any <>'"& in the text, & first as they become '&gt;', . . . '&amp;' so the & processing would mangle the '&gt;' ! Saw it overdone online just this week somewhere, &nbsp; on the web page! Smilie
# 7  
Old 10-29-2010
The script has a fundamental design problem because it does not match the ".log" filenames to the ".csv" filenames.

In fact on careful examination I cannot determine what the ".log" files are for. At the start of the script the are blank files (I think) and nothing in the script writes to them. Perhaps they are the intended as the names for email attachments? Who knows?

It is fairly straightforward to convert each ".csv" filename to the corresponding ".log" filename. The only variable text is in the filename pairs is "condition/encounter/procedure/provider".

Let's see how the O/P maps the input to the expected output, not forgetting filling in the contents of $subject and $to .
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sending multiple files using uuencode command

Hi All, I want to send multiple CSV file using below code. In Result folder, we have multiple CSV files. However, I want to catch only Summary CSV files. I was trying using *, % with different combination. However, not able to do so. From below code, I could send only one file... (1 Reply)
Discussion started by: Swapnil Mawle
1 Replies

2. Shell Programming and Scripting

Sending files to multiple emails

Hi All, I want to send each file to each email id as below. Instead of writing saparate 10 mail commands can we do it in a simple step. file1.csv to raghu.s@hps.com file2.csv to kiran.m@hps.com file3.csv to kenni.d@hps.com file4.csv to rani.d@hps.com file5.csv to sandya.s@hps.com... (2 Replies)
Discussion started by: ROCK_PLSQL
2 Replies

3. Solaris

Sending Mails to the Multiple Email Address

Hi All, I am pretty new to the mail service in Sun Solaris 5.10. If anybody help me in writing a script for the multiple recipient with subject and the body would be a helpful. Kindly help... Thanks in advance. :) Warm Regards, Pramod (5 Replies)
Discussion started by: Pramod_009
5 Replies

4. Shell Programming and Scripting

sending multiple files along with mail message using uuencode

Hi, I have a requirement to send a mail with multiple files attached to it and along with the text message in the mail. I am trying sumthing like below but it only sends me the text message and no files attached to the mail. ---------------------------------------- ( uuencode file1... (1 Reply)
Discussion started by: sachinkl
1 Replies

5. UNIX for Dummies Questions & Answers

Zipping files and sending email

Hi, I need to zip 4 files and send an email attaching the zipped files... Pls help.. Win ---------- Post updated at 10:49 AM ---------- Previous update was at 10:36 AM ---------- Hi, I need to convert 4 text files into xls,zip these 4 files and send an email attaching the... (2 Replies)
Discussion started by: win4luv
2 Replies

6. HP-UX

Sending email to multiple IDs

Hi, I am trying to send an email to multiple IDs from Unix script. I have given the EmailIds in a file and trying to use the file as input in the script. > cat Email EmailID = "abc@xyz.com cbz@xyz.com" In my script I have . /Email mailx -s "subj" $EmailID This fails with the... (3 Replies)
Discussion started by: sangharsh
3 Replies

7. HP-UX

Sending Unix files as attachments in an email

Hi, I am executing the following command in order to send a file as an attachment: mailx -s "Subject" emailID@xyz.com < Testfile.txt Instead of attaching the file Testfile.txt, it is writing the contents of the file in the email message body. Please advise on how I can send the file as an... (7 Replies)
Discussion started by: sangharsh
7 Replies

8. Shell Programming and Scripting

Sending an email with more than one files

Hi, I would like to send an email with more than one attachement. I am using uuencode. I want to achive by suing uuencode. Also please let me know other ways. -Thambi (7 Replies)
Discussion started by: thambi
7 Replies

9. Shell Programming and Scripting

Sending mutiple files thru email to lotus notes

Hi All, I am currently using the following script to send the single file to one/more email addresses. I need to send mutilple files at same time, are there anyway I could modify the script or write new one to accomplish the same. Script *************** #!/bin/ksh # Author: Manish... (4 Replies)
Discussion started by: lapisguy
4 Replies

10. Shell Programming and Scripting

Sending Multiple Files through email

Hi Everyone, I'm using the uuencode command with the mail command to send out emails through a UNIX script. The problems is that i have a number of gif files that i need to attach to a single email but the number and name of the gif files is not static. Example today the folder home/Desktop may... (4 Replies)
Discussion started by: nbvcxzdz
4 Replies
Login or Register to Ask a Question