XML Import for Mattel Speed-Quote

An optional address file can be included in the same XMLImport folder as the main xml file to import. This file is named with the XML import file name and .addr appended. (e.g. MapsDB.xml would have a MapsDB.addr file).

Here is an example .addr file with only a single entry:

<?xml version="1.0" encoding="UTF-8"?>
<Addresses>
   <Address CompanyID="LC_APPTASTIC" CompanyName="Apptastic Software Inc." CompanyType="VendorLC">
      
      <CompanyAddr01>1010 Polytek Street</CompanyAddr01>
      <CompanyAddr02>Unit 21</CompanyAddr02>
      <CompanyCity>Ottawa</CompanyCity>
      <CompanyState>Ontario</CompanyState>
      <CompanyCountry>Canada</CompanyCountry>
      <CompanyZip>K1J 9J1</CompanyZip>
      <CompanyWebPage>www.apptastic.com</CompanyWebPage>

      <Contact ContactID="LC_APPTASTIC_DAVE" ContactName="Dave Stephenson">
          <ContactPhone>(613) 748-7066</ContactPhone>
          <ContactFax>(613) 749-6910</ContactFax>
          <ContactEmail>[email protected]</ContactEmail>
      </Contact>

   </Address>
</Addresses>

The .addr file is an xml file with a <Addresses> root tag and multiple child <Address> tags. An <Address> tag would have the following attributes:

• CompanyID (required) - the id attribute is the connection between this address and an address for a product in the main xml file.
• CompanyType (required) - what type of address is this?
• CompanyName (required) - the name of the company as it should appear in Speed-Quote.

The following values are valid for CompanyType attribute:

• VendorDomestic
• VendorLC
• USRep
• OverseasAgent
• Manufacturer
• Factory
• CustomsBroker
• Bank

Please see the Addresses worksheet in the mattelspeedquotefields.xls excel file for a list of <CompanyXXXX> tag fields and associated information.

An <Address> node can have multiple <Contact> tags which define the contacts within that company. A <Contact> tag has the following attributes:

• ContactID (required) - the ContactID attribute is the connection between this contact and a contact for a product in the main xml file.
• ContactName (required) - the name of the contact as it should appear in Speed-Quote.

In the main xml file an address linking tag is used to link to a specific address or contact. The tag name for a company link is <AddrCOMPANYTYPECompany> and the tag name for a contact link is <AddrCOMPANYTYPEContact>. Where COMPANYTYPE is one of the above CompanyType attribute values.

The connection tags in the main xml file to link to the above example address would show as:

<AddrVendorLCCompany>LC_APPTASTIC</AddrVendorLCCompany>
<AddrVendorLCContact>LC_APPTASTIC_DAVE</AddrVendorLCContact>