Cacidi LiveMerge CC Manual

Using the XML Format as Data Source

The XML format is often the choice for many database outputs, when it comes to automated production with Cacidi LiveMerge.

The structure of the XML data file must contain information for each record. The syntax for a record should be written with the start tag <ROW> and the end tag </ROW> described like this:

<?xml version=...>

<root>

<ROW>

<ID>1</ID>

<Name>Couch, red</Name>

<Price>$1.200</Price>

<color>red<color>

<Specifications></Specifications>

</ROW>

<ROW>

<ID>2</ID>

<Name>Drill</Name>

<Price>$99</Price>

<Specifications>It's a drill</Specifications>

</ROW>

</root>

All data tags (<ID>, <Name> etc. in the above example) must be written within the <ROW></ROW> tags.

The first record in the xml data file must contain all data tags used for any record in the data file, even though they are empty. This information is used for compiling the list of available data fields in Cacidi LiveMerge. Thus, if the first record only contains data in one data field and the second record contains data in 10 data fields, all the data fields must be present for the first record.

In the example above, the first record must contain the <Specifications> data tag because this tag is used in the second record even though it's empty for the first record. Also in the above example, the second record doesn't need to have a <color> tag although it is used in the first record.

Cacidi LiveMerge is very strict with the xml format defined above and cannot interpret xml-tags like

<myTag name=Couch, red/>

They must be written in the structure detailed above.

Comments in the xml-file are allowed using the syntax <!comment

Using the stylistic Text Styling codes within a XML file, the < and > tags in the Text Styling codes should be entered using standard HTML entities