| Next revision | Previous revision |
| mattel:xml_structure [2012/07/09 21:11] – created dave | mattel:xml_structure [2025/05/22 21:53] (current) – external edit 127.0.0.1 |
|---|
| ======XML Import for Mattel Speed-Quote====== | ======XML Import for Mattel Speed-Quote====== |
| |
| A Speed-Quote XML Import file has an <SQDatabase> tag as it's root tag, followed by a <PRODUCT_INFO> tag for each product to update/create. | A Speed-Quote XML Import file (Mattel Version) has an <MAIN> tag as it's root tag, followed by a <PRODUCT_INFO> tag for each product to update/create. |
| |
| The <PRODUCT_INFO> node has multiple child tags with only the <TOY_NUM> tag being required. The <TOY_NUM> tag (along with the optional <DASH_CODE> tag) is the database key columns that define a product in Speed-Quote. Please see the Mattel | The <PRODUCT_INFO> node has multiple child tags with only the <TOY_NUM> tag being required. The <TOY_NUM> tag (along with the optional <DASH_CODE> tag) is the database key columns that define a product in Speed-Quote. Most fields are simply child tags under the <PRODUCT_INFO> tag, but there are some exceptions. Please see the {{:mattel:mattelspeedquotefields.xls|}} excel file for complete information of all fields. You can also see an interactive version of the Master Entry Sheet that shows the Table/Field/XMLImport names at: [[http://www.apptastic.com/support/sqmasterinfo/sqmaster01.html]] |
| | |
| | ==== Special Tags ==== |
| | |
| | === Boolean Values === |
| | |
| | Some fields such as <WARRANTY_INCL> are boolean fields. The values for these tags can be the following: |
| | |
| | * true, t, yes, y, 1 - mean true |
| | * false, f, no, n, 0 - mean false |
| | |
| | === Assortment Information === |
| | |
| | Assortment information is added to the xml file by adding an <ASSORTMENT_INFO> tag and <ASSRTCHILD_XXX> child tags for an assortment products. For example: |
| | |
| | <code> |
| | <ASSORTMENT_INFO> |
| | <ASSRTCHILD_STYLENUM>12345</ASSRTCHILD_STYLENUM> |
| | <ASSRTCHILD_DESC>Assortment 1</ASSRTCHILD_DESC> |
| | <ASSRTCHILD_UPC>12345678901234</ASSRTCHILD_UPC> |
| | </ASSORTMENT_INFO> |
| | <ASSORTMENT_INFO> |
| | <ASSRTCHILD_STYLENUM>55445</ASSRTCHILD_STYLENUM> |
| | <ASSRTCHILD_DESC>Assortment 2</ASSRTCHILD_DESC> |
| | <ASSRTCHILD_UPC>12345678955567</ASSRTCHILD_UPC> |
| | </ASSORTMENT_INFO> |
| | </code> |
| | |
| | === Address Links === |
| | |
| | The preferred method of including addresses is to include a .addr file alongside the .xml file for import. More information can be found on the [[mattel:address_file|XML Import for Mattel Speed-Quote]] page. |
| | |
| | === How to Import === |
| | |
| | Place the xml file and the addr file into the SQEnterprise/Admin/XMLImport/ folder on the server computer. Speed-Quote will create a new database or update an existing database using the basename of the xml file (e.g. MAPSdb.xml will create a database called MAPSdb). |
| | |
| | The XML Import task schedule is set using the Speed-Quote Administration Tool as per our online manual: [[http://www.apptastic.com/manual/events.htm]] |
