form result email in html format Solutions

maneshr

Commented: 2000-03-07

is pretty easy to do in PERL. However you must remember that not ALL email clients support HTML tags in their Email. so not everybody can get the HTML like look-and-feel. An alternate would be a neatly formatted text output that would be supported by all the Email clients including Non-GUI ones!!

bogie

Author

Commented: 2000-03-07

Thank you for your reply. The receipient would only be a single user,and they would like the form fields heading and all... but in any case, do you have a Perl script that can handle this? I can handle html very well, but Perl is not my forte. Would I be able to add/change the fields myself by going into the script and simply adding/changing small snippets?

You can see the form here: http://www.marblelife.com/salesrpt.htm

Thanks, Herb

monas

Commented: 2000-03-08

1. make copy of salesrpt.htm file - salessend.htm
2. edit salessend.htm and in every <input > insert text value="%%fieldName%%"
3. create script

#!/usr/bin/perl

use CGI;
$q = new CGI;
open(F, 'salessend.htm");
$sales = join('', <F>);
close(F);

@fields = qw(RESMarbleRest RESGraniteRest all other field names with correct Cappitals );

foreach $f(@fields){
$pat = '%%'.$f.'%%';
$sales =~ s/$pat/$q->param($f)/g;
}

open(M, '|/bin/mail -s Subject person@to.send.to');
print M $sales;
close(M);

print $q->header();
print "Report sent\n";

exit 0;

Good Look!

monas

Commented: 2000-03-08

oops, line

$sales =~ s/$pat/$q->param($f)/g;

should read

$sales =~ s/$pat/$q->param($f)/ge;

monas

Commented: 2000-03-08

yet another typo
open(F, 'salessend.htm");
should be
open(F, 'salessend.htm');

maneshr

Commented: 2000-03-08

try this.

you dont need to modify anything in salesrpt.htm.
it is the starting point for the CGI i am have coded below.

Also you must copy this template file to any location and put the full path to the file in the CGI script.

Basically this is how it works. i have created a mirror hmtl file that acts as a template to salesrpt.htm.

it has all the HTML tags and so on. The only difference is that instead of the input tags i have put the actual variable names in CAPS with a ## before and after the variable. Eg ##RETURN_LINK_URL##, ##WEEK_OF## etc..

NOTE: the variable names MUST be the same as in salesrpt.htm and in all caps.

Now when the user submits the form, the CGI script goes thru the template and just replaces the variables with their actual value!!

this program is flexible so that tomorrow if you were to add/remove new variable(s) to salesrpt.htm, you need to ONLY add/remove the variable in the salesrpt_template.html file!! your CGI can continue to remain unchanged!!

However do remember the NOTE above.

Installation: copy the formmail.pl to your cgi-bin directory, give it proper permissions & remember to changed the full path of the template file
($template_file="/www/sbarney/docs/manesh/salesrpt_template.html";)
to your location.

==========================salesrpt_template.html
<html>
<BODY>

<center>##SUBJECT##</CENTER>

<table border=0 cellpadding=4>

<TD>For the Week of: </TD>
<TD>##WEEK_OF##</TD>
<TD></TD>
<TD></TD>
<TR>

<TD>Franchise Name: </TD>
<TD>##FRANCHISENAME##</TD>
<TD>Franchise Acct: </TD>
<TD>##FRANCHISEACCT##</TD>
<TR>

<TD>Email Address: </TD>
<TD>##EMAIL##</TD>
<TD></TD>
<TD></TD>
<TR>
<TD>Total Sales: </TD>
<TD>##TOTALSALES##</TD>
<TD></TD>
<TD></TD>
<TR>

<TD>Residential:</TD>
<TD>##RESIDENTIALSALES##</TD>
<TD></TD>
<TD></TD>
<TR>

<TD>Commercial:</TD>
<TD>##COMMERCIALSALES##</TD>
<TD></TD>
<TD></TD>
</TABLE>


Weekly Residential Sales Analysis

<div align="center">
<center>
<table BORDER="1" CELLSPACING="1" CELLPADDING="0" width="100%">
<tr>
<td bgcolor="#FFFFFF" align="center">
Marble Restoration</td>
<td bgcolor="#FFFFFF" align="center">
Granite Restoration</td>
<td bgcolor="#FFFFFF" align="center">
Terrazzo Restoration</td>
<td bgcolor="#FFFFFF" align="center">
Ceramic Tile</td>
<td bgcolor="#FFFFFF" align="center">
Vanities & Tables Restored</td>
<td bgcolor="#FFFFFF" align="center">
Clean & Polish</td>
</tr>
<tr>
<td align="center">
##RESMARBLEREST##
</td>
<td align="center">##RESGRANITEREST##</td>
<td align="center">
##RESTERRAZZOREST##
</td>
<td align="center">
##RESCERAMICTILEREST##
</td>
<td align="center">
##RESVANITIESTABLEREST##
</td>
<td align="center">
##RESCLEANPOLISH##
</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">
Stone Sealed Interlok</td>
<td align="center" bgcolor="#FFFFFF">
Stone Sealed Impregnator</td>
<td align="center" bgcolor="#FFFFFF">
Maintenance Acct.^Òs</td>
<td align="center" bgcolor="#FFFFFF">
InterCare Sales</td>
<td align="center" bgcolor="#FFFFFF">
Step 1 & Step 2 Sales</td>
<td align="center" bgcolor="#FFFFFF">
Misc.</td>
</tr>
<tr>
<td align="center">
##RESSTONESEALEDINTERLOK##
</td>
<td align="center">
##RESSTONESEALEDIMPREGNATOR##
</td>
<td align="center">
##RESMAINTACCTS##
</td>
<td align="center">
##RESINTERCARESALES##
</td>
<td align="center">
##RESSTEP1AND2SALES##
</td>
<td align="center">
##RESMISCSALES##
</td>
</tr>
</table>
</center>
</div>
Weekly Commercial Sales Analysis

<div align="center">
<center>
<table BORDER="1" CELLSPACING="1" CELLPADDING="0" width="100%">
<tr>
<td align="center" bgcolor="#FFFFFF">
Marble Restoration</td>
<td align="center" bgcolor="#FFFFFF">
Granite Restoration</td>
<td align="center" bgcolor="#FFFFFF">
Terrazzo Restoration</td>
<td align="center" bgcolor="#FFFFFF">
Ceramic Tile</td>
<td align="center" bgcolor="#FFFFFF">
Vanities & Tables Restored</td>
<td align="center" bgcolor="#FFFFFF">
Clean & Polish</td>
</tr>
<tr>
<td align="center">
##COMMARBLEREST##
</td>
<td align="center">
##COMGRANITEREST##
</td>
<td align="center">
##COMTERRAZZOREST##
</td>
<td align="center">
##COMCERAMICTILEREST##
</td>
<td align="center">
##COMVANITIESTABLEREST##
</td>
<td align="center">
##COMCLEANPOLISH##
</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">
Stone Sealed Interlok</td>
<td align="center" bgcolor="#FFFFFF">
Stone Sealed Impregnator</td>
<td align="center" bgcolor="#FFFFFF">
Maintenance Acct.^Òs</td>
<td align="center" bgcolor="#FFFFFF">
InterCare Sales</td>
<td align="center" bgcolor="#FFFFFF">
Step 1 & Step 2 Sales</td>
<td align="center" bgcolor="#FFFFFF">
Misc.</td>
</tr>
<tr>
<td align="center">
##COMSTONESEALEDINTERLOK##
</td>
<td align="center">
##COMSTONESEALEDIMPREGNATOR##
</td>
<td align="center">
##COMMAINTACCTS##
</td>
<td align="center">
##COMINTERCARESALES##
</td>
<td align="center">
##COMSTEP1AND2SALES##
</td>
<td align="center">
##COMMISCSALES##
</td>
</tr>
</table>
</center>
</div> 
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="center">Column 1</td>
<td align="center">+ Column 2</td>
<td align="center">+ Column 3</td>
<td align="center">+ Column 4</td>
<td align="center">= Column 5</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table BORDER="1" CELLSPACING="1" CELLPADDING="0" width="100%">
<tr>
<td align="center" bgcolor="#FFFFFF">
Previous Acct^Òs Receivable</td>
<td align="center" bgcolor="#FFFFFF">
Weekly Sales</td>
<td align="center" bgcolor="#FFFFFF">
Weekly Sales Collected</td>
<td align="center" bgcolor="#FFFFFF">
Acct^Òs Receivable Collected</td>
<td align="center" bgcolor="#FFFFFF">
Current Acct.^Òs Receivable</td>
</tr>
<tr>
<td align="center">
##PREVAR##
</td>
<td align="center">
##WEEKLYSALES##
</td>
<td align="center">
##WEELKYSALESCOLLECTED##
</td>
<td align="center">
##ARCOLLECTED##
</td>
<td align="center">
##CURRENTAR##
</td>
</tr>
</table>
</center>
</div>


<TABLE border=0 cellpadding=2>
<TD>6% Royalty Fee of Moneys Collected:</TD>
<TD>##SIXPERCENT_AMT##</TD>
<TD>CK#</TD>
<TD>##ROYALTYFEE##</TD>
<TR>

<TD>2% Ad Fund of Moneys Collected:</TD>
<TD>##TWOPERCENT_AMT##</TD>
<TD>CK#</TD>
<TD>##ADFUND##</TD>
<TR>

<TD>Total Due MARBLELIFE, Inc: </TD>
<TD>##TOTALDUE##</TD>
<TD></TD>
<TD></TD>
<TR>

<TD>Total of Weekly Sales Collected and Accounts Receivable
Collected (Column 3 + Column 4): </TD>
<TD>##TOTALWEEKLYSALESANDARCOLLECTED##</TD>
<TD></TD>
<TD></TD>
</TABLE>

Franchise Signature:_________________________

<A HREF="##RETURN_LINK_URL##">##RETURN_LINK_TITLE##</A>

<CENTER>Mail Checks and Copies of all Sequentially Numbered Invo
ices to: MARBLELIFE, INC. 805 W. N. Carrier Pkwy, Suite #220, Grand Prairie,
Texas 75050</center>

</body>
</html>
========================formmail.pl
#!/usr/local/bin/perl

use CGI;

$query=new CGI; ## Create a CGI object to read the values entered in the HTML
form.

## Full path to the template file.
$template_file="/www/sbarney/docs/manesh/salesrpt_template.html";

print "Content-type: text/html\n\n";
if ($query->param){ ## This script has been called via a Submit button

## Read every parameter entered in the form...
## ...& store it in an associative array after...
## ...converting the variable to UPPER CASE.
## E.g. if your form variable is called TotalSales, the key will be TOTALSAL
ES and the value against the key will be whatever was entered in the HTML form!
!
foreach($query->param){
$key=uc $_;
$data{$key}=$query->param($_);
}

## NOTE: DOS files have ^Z as the end-of-file indicator
$/="^Z"; ## Make the end-of-line seperator as ^Z
open(TEMPL,$template_file) || die $!;
$entire_file=<TEMPL>; ## Read the ENTIRE file into a PERL variable
close(TEMPL);
$/="\n"; ## Restore the end-of-line seperator to carriage return

## Now, search in the read file for every key in the hash.
foreach $sp_var (sort keys %data){
## If a match is found, replace the key with its correspoding value.
$entire_file=~ s/##$sp_var##/$data{$sp_var}/g if $entire_file=~ /##$sp_var#
#/;
}

## Print the final file. If required, the same can be ...
## ...sent out via an E-mail!!
print $entire_file,"\n";
}else{ ## We dont allow the user to directly call this CGI script
print "You are not allowed here!! \n";
}

maneshr

Commented: 2000-03-11

have you been able to test the code that i gave you??

if so, did it work properly??

bogie

Author

Commented: 2000-03-11

Been out of town all week. Just returned, so I should be able to give it a good going over in the next day or so...but it looks very complete, thanks!
Herb

maneshr

Commented: 2000-03-21

any success so far??

Rgds

bogie

Author

Commented: 2000-03-22

I am sorry I have been delinquent in working on your answer...we had a family emergency and I have not been able to work on it. Please rest assured that if your answer works, I will let you know and also give a bonus for your patience!
Thanks, Herb

maneshr

Commented: 2000-03-22

i'm sorry. i hope everything is Ok with your family.

please take you time to review the code.

Regards

mfragoso

Commented: 2000-05-23

This one is on us!

(Get your first solution completely free - no credit card required)

UNLOCK SOLUTION

form result email in html format

Premium Content

Premium Content

View Solution Only

Join our community and discover your potential