<!-- Loaded Date: Tues May 28 18:27:16 PDT 2002 Run by: vlb cwd: /ad4/home/vlb/Work/Projects/PnL Command: Loader.pl -v -f validated.report -o loaded.report --> <parsed fname="sample0515.dat" date="Tues May 28 16:01:07 PDT 2002"> <config> <info> <source name="Sample"> <url></url> </source> <filename>sample0515.dat</filename> <headers> Last Name, First Name, Address Line 1, Address Line 2, City, State, Zip, Phone, Fax, Mobile, Email, Company </headers> <description> Sample file </description> <path>./data/sample0515.dat</path> </info> <parser> <format> <comment_char></comment_char> <field_sep>,</field_sep> <read type="until">EOF</read> <record_sep></record_sep> <skip type="lines">2</skip> </format> <field pos="1" header="Last Name" parse="1" tag="last" /> <field pos="2" header="First Name" parse="1" tag="first" /> <field pos="3" header="Address Line 1" parse="1" tag="address" /> <field pos="4" header="Address Line 2" parse="0" tag="" /> <field pos="5" header="City" parse="1" tag="city" /> <field pos="6" header="State" parse="1" tag="state" /> <field pos="7" header="Zip" parse="1" tag="zip" /> <field pos="8" header="Phone" parse="0" tag="" /> <field pos="9" header="Fax" parse="0" tag="" /> <field pos="10" header="Mobile" parse="0" tag="" /> <field pos="11" header="Email" parse="1" tag="email" /> <field pos="12" header="Company" parse="0" tag="" /> </parser> <loader> <table name="contacts"> <load type="numeric" record_tag="record_id">f_record_id</load> <load type="string" global_tag="family_id">f_family_id</load> <load type="string" field_tag="first">f_first_name</load> <load type="string" field_tag="last">f_last_name</load> <load type="string" field_tag="address">f_address_one</load> <load type="string" field_tag="state">f_state</load> <load type="numeric" field_tag="zip">f_zip_code</load> <load type="string" field_tag="email">f_email</load> </table> </loader> </config> <todays_date>20010105</todays_date> <loaded> Tues May 28 18:27:16 PDT 2002</loaded> <data> <record status="id-confirmed" seq="1" contact_id="29282000"> <last>Brown</last> <first>Vicki</first> <address>PO Box 1269</address> <city>San Bruno</city> <state>CA</state> <zip>94066</zip> <email>vlb@cfcl.com</email> </record> <record status="id-confirmed" seq="2" contact_id="31800000"> <last>Morin</last> <first>Rich</first> <address>PO Box 1269</address> <city>San Bruno</city> <state>CA</state> <zip>94066</zip> <email>rdm@cfcl.com</email> </record> <record status="id-confirmed" seq="3" contact_id="26389000"> <last>Jones</last> <first>Fred</first> <address>Box 18</address> <city>Hamburg</city> <state>PA</state> <zip>16800</zip> <email>fred@myco.com</email> </record> <record status="id-confirmed" seq="4" contact_id="30944000"> <last>Baker</last> <first>Betty</first> <address>1733 State Dr.</address> <city>Philmore</city> <state>CT</state> <zip>06516</zip> <email>betty@myco.com</email> </record> </data> <family_id>FTSE100</family_id> <validated>Tues May 28 16:45:12 PDT 2002</validated> <path_to_file>./data/sample0515.dat</path_to_file> <stats> records parsed = 4 empty fields = 0 IDs confirmed = 101 IDs unconfirmed = 0 IDs suspect = 0 </stats> </parsed>