Script that gathers specific values from files and puts it into HTML to send e-mail
Hi All,
Sorry for long topic here.
So the drill goes like that, I need a script which gathers different values from different files/locations.
( this is how im planning to do for taking information i need, there will be 39 files like this, and the columns i print may vary, so im guessing im gonna have to make it this all the way down )
Then lets say i have body.html file where lays only the body of the table, where i have put collumn names and formated the table how i want. I dont have the code, but it's simple. So what i need is to take those values $A_CT, $B_CT , $C_CT and substitute everyhting i need in html body. As this substitution goes, it doesnt have to impact the original body.html file but put a copy of lets say email_out_2015.08.31.html for sending email.
Plus i will have some recipients to send this mail, what's your suggestion do i put recipients straight into script, like: recipients=one@one.com two@two.com ... etc..
or should i have seperate file name recipients.txt ?
--------------------------------------------------------
The problems I've met already.
If i put the needed values into values.dat file, and try putting them with this line :
I dont get what i need, i dont get collumn names depending of the filename value has been taken off or, simple html configuration.
So guys any suggestions to do it in simple yet better way, than I'm doing this, cause I know this is an easy one, but since im the starter with UNIX I need your help guys. Any suggestions?
Thanks in advance ;}
Last edited by Don Cragun; 08-31-2015 at 04:38 AM..
Reason: Add CODE and ICODE tags.
I only get half of what you describe, but from that I feel and see that your approach is way too complex. From what I understand, almost everything you request can be done in one (or a few) awk scripts and mayhap some control files.
Please post at least a handful of input files and a detailed description of what goes where on which condition, code and data in code tags.
Last edited by RudiC; 08-31-2015 at 07:21 AM..
Reason: typo
Sorry about not using code tags, and thanks for editing it for me.
Ok, hopefully it will help you to understand me better.
I have 39 files in different locations, and I need to take only a certain column from each of the file. File would look like:
Let's say I will take column 5 and put it into report.txt file. Keep in mind that i have ±39 files .dat files that I need to gather information from. So Im doing it like this:
All of the values I need will go to
.
And then I need all the values to go to HTML table which will be sent by e-mail from UNIX.
I'm stuck at putting values into HTML with the column names I need. For example, I need 3 columns which will contain 3 data types : delta, audit, extract. And one row with the file name's I've gathered information from.
And this as HTML, will be sent by email. I hope I made it more clearly this time
Still not clear. I can't see where "filename?" is coming from, where "1111" is coming from, and how those values should be distributed into the target table. The structure and usage of "report.txt" I can't infer.
Let's step back and tackle each subtask by itself.
1) you want to extract certain fieds from certain files. Post directory structure, files and field numbers.
2) Do you want to limit the number of lines from each file that go to report.txt?
3) you want to combine those fields into some sort of table. Post what goes where, and where it comes from.
4) Where is values.dat (in post#1) used?
Ok,
Filename.dat comes from where I take my values,lets say its /data/user/database/ .
Value 1111 is random value which I will get from filename.dat with this command:
(delta.dat is the same as filename.dat, and column 5 would represent 1111 value)
1) Yes. But it will be a lot to post, lets say I have all files in /data/user/database/ and I will take field 5.
2) I can't understand the question correctly.
3) Ok, so we have filename.dat I will will take one column and put it into first row, then im taking second file which goes into same row, but different column and so on. Next row start's when I'm extracting values from another files.
(It still maybe little unclear, thing is that one file will have lets say 3 columns i need, the 4th column will be populated from different file.)
HI,
I have two scripts which is sending the mail in html format.
Script 1:
1.IFILE=/home/home01/Report.csv
if #Checks if file exists and readable
then
if awk -F, '{ T += $13 } END { exit(!T) }' ${IFILE}
then
awk -F, 'BEGIN{
c=split("3,4,8,9,13", col)
print "To:... (0 Replies)
Need assistance. Trying to send a test.csv file using html tag <PRE> </PRE>. Used to work without any issue . But now gets me and stdin issue. Please give me any suggestions
#!/usr/bin/ksh
export MAILTO=" <userid>@a.com"
export SUBJECT="Test mail "
(
echo "Subject: $SUBJECT"
echo... (6 Replies)
Hello,
I need to write a script to check the files in one folder , if that folder doesn't have files generated from last 1 hr then we need to send mail to particular persons.
So Can you please help me to write script to check the files and send email.
Thank you.. (1 Reply)
The below code is not working. I am able to send only inline html or only attachment. When trying to do both, only inline html is sent without attachment. Please help!
#!/bin/ksh
(echo "Subject: Test Mail - HTML Format"
echo "MIME-Version: 1.0"
echo "Content-Type: text/html"
echo... (1 Reply)
Hi
The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment .
cat Employee.sql
SET VERIFY OFF
SET PAGESIZE 200
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD... (0 Replies)
Hi,
Is it possible to send mail from my HP-Ux system with images, rich text? I would like to program in such a way that I have my company's logo(.jpg) image attached in the mail geeting triggered. I would like to send a rich text/HTML email instead of plain text mail to the recipients. Is it... (2 Replies)
Hello,
I need a shell script which need to send a mail with 4 *.csv files as attachments.Anybody can help me?
At present i have a script which is sending only one file as attachments.But i need a script which send 4 files in a shot.
#!/bin/ksh
/bin/mail xxxx@xx.xom << EOF
Subject:... (4 Replies)
I apoligize for the cross-post but I'm not getting much in the way of help in the dummies forum:
I'm trying to script sending an e-mail message on an AIX 5.x server with the following requirements:
1. command line switch to specify file name containing message body in HTML format
2. command... (3 Replies)
Hi all,
I am working on UNIX (Solaris28). I would like to send an email in which the body will be in html format and, in the same mail, a xls file has to be attached.
I have tried this: the file is correctly attached but the body comes as html source and not formatted. If I do not attach the... (4 Replies)
Hi,
I'm a programmer not a sys admin, so please excuse this if it seems a little out of place, but I think it applies to this forum. When I send my HTML newsletter from the server it comes in as plain text on some email programs and not others. Eudora is fine; Outlook Express, Hotmail, and... (2 Replies)