About TemplateMailer :: Try / Purchase :: Support :: Company Information :: Feedback

Example Log File Formats

The TemplateMailer system provides powerful logging capabilities to store all activity from web forms into formats which can be easily imports into other applications. Many of these formats include comma-delimited, tab-delimited and XML file formats. Plus with the TemplateMailer LogTemplate system you only have to log the fields you need in the format you want.

The following examples assume you are collecting the following fields; firstname, lastname, company, address, city, state, zip, phone and email.

Example quotes/comma delimited format - Easily opens in Excel

"##COMPANY##", "##FIRSTNAME##", "##LASTNAME##", "##ADDRESS##", "##CITY##", "##STATE##", "##ZIP##", "##PHONE##", "##EMAIL##"

Example XML format

<Contacts> 
    <firstname>##FIRSTNAME##</firstname>
    <lastname>##LASTNAME##</lastname>
    <company>##COMPANY##</company>
    <address>##ADDRESS##</address>
    <city>##CITY##</city>
    <state>##STATE##</state>
    <zip>##ZIP##</zip>
    <phone>##PHONE##</phone>
    <email>##EMAIL##</email>
</Contacts>   

Many other file formats can be used including well formatted SQL statements which can be bulk imported into a database. For example:

INSERT INTO Contacts (company, firstname, lastname, address, city, state, zip, phone, email) VALUES ('##COMPANY##', '##FIRSTNAME##', '##LASTNAME##', '##ADDRESS##', '##CITY##', '##STATE##', '##ZIP##', '##PHONE##', '##EMAIL##')



Copyright 2001 - 2017
Tectonic Concepts, LLC, All Rights Reserved