Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| mattel:xml_structure [2012/08/23 14:19] – 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. 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]] | 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]] |
| 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. | 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]] |
