DataManager RT

  1. Home
  2. Docs
  3. DataManager RT
  4. XML Integration Guide
  5. Sample insert/update XML

Sample insert/update XML

<?xml version=”1.0″?>

<ImportData xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>

<Customer Name=”ABC Company” Code=”ABC”>

<Hierarchy>

<DivisionKeys>

<Key>Code</Key>

<Key>Year</Key>

</DivisionKeys>

<ModelKeys>

<Key>Name</Key>

<Key>Code</Key>

<Key>Year</Key>

<Key>Type</Key>

</ModelKeys>

<IplKeys>

<Key>Composite Key</Key>

</IplKeys>

<ChapterKeys>

<Key>Name</Key>

</ChapterKeys>

<Divisions>

<Division Name=”Refrigerators” Key=”RF2018″ VisibilityGroups=”US”>

<Attributes>

<!– alternate (Value is necessary when using translations):

<Attribute Name=”Code”><Value>RF</Value></Attribute>

<Attribute Name=”Year”><Value>2018</Value></Attribute>

–>

<Attribute Name=”Code”>RF</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Color”>

<Value>Red</Value>

<Translations>

<Translation IsoCode=”ES”>Rojo</Translation>

<Translation IsoCode=”IT”>Rosso</Translation>

</Translations>

</Attribute>

</Attributes>

<!– Division display name translation –>

<Translations>

<Translation IsoCode=”IT”>Frigoriferi</Translation>

</Translations>

<!–This is a full model that should match any references –>

<Model Name=”Fridge Master” Key=”FM2018A”>

<Attributes>

<Attribute Name=”Code”>FM</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Type”>A</Attribute>

</Attributes>

</Model>

</Division>

</Divisions>

<Models>

<Model Name=”Fridge Master” Key=”FM2018A”>

<Attributes>

<Attribute Name=”Code”>FM</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Type”>A</Attribute>

<Attribute Name=”Model Alias”>

<Value>Model One</Value>

<Value>Model Two</Value>

<Value>Model Three</Value>

</Attribute>

</Attributes>

<Translations>

<Translation IsoCode=”IT”>Frigoriferi Capo</Translation>

</Translations>

<SerialVins>

<Serial Type=”Single” Prefix=”ARI001″ Start=”00100″></Serial>

<Serial Type=”Single” Prefix=”ARI001″ Start=”00200″></Serial>

<Serial Type=”Closed” Prefix=”ARI001″ Start=”00300″ End=”00399″></Serial>

<Serial Type=”Open” Prefix=”ARI007″ Start=”5100″></Serial>

</SerialVins>

<Literatures>

<Literature Name=”Red Door” FilePath=”FolderOne” FileName=”Door.pdf” VisiblityGroups=”US,CAN” Category=”Documents”></Literature>

</Literatures>

<Attachments Name=”Motors” Key=”FM2018AMotors”>

<Attributes>

<Attribute Name=”Code”>FM</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Type”>A</Attribute>

<Attribute Name=”Motor label”>Motors</Attribute>

</Attributes>

<ModelRef Name=”Motor A” Key=”FM2018AMotorA”>

<Attributes>

<Attribute Name=”Code”>FM</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Type”>AMotorA</Attribute>

</Attributes>

</ModelRef>

</Attachments>

<Chapters>

<Chapter Name=”Chassis” Key=”FM2018A Chassis”>

<Attributes>

<Attribute Name=”Code”>FM</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Type”>A</Attribute>

<Attribute Name=”Chassis label”> Chassis</Attribute>

</Attributes>

<IPLs>

</IPLs>

</Chapter>

</Chapters>

<IPLs>

<IPL Name=”Door” Key=”FMA2018A Door”>

<Attributes>

<Attribute Name=”Composite Key”>FMA2018A Door </Attribute>

</Attributes>

<Image FilePath=”Images\FMA2018″ FileName=”Fig101.jpg”>

<Hotspots>

<HotSpot X1=”449″ Y1=”407″ X2=”466″ Y2=”436″ RefNum=”1″ />

<HotSpot X1=”357″ Y1=”73″ X2=”393″ Y2=”97″ RefNum=”10″ />

<HotSpot X1=”269″ Y1=”127″ X2=”304″ Y2=”152″ RefNum=”11″ />

<HotSpot X1=”626″ Y1=”240″ X2=”664″ Y2=”265″ RefNum=”12″ />

<HotSpot X1=”588″ Y1=”175″ X2=”625″ Y2=”200″ RefNum=”13″ />

<HotSpot X1=”192″ Y1=”486″ X2=”231″ Y2=”513″ RefNum=”14″ />

</Hotspots>

</Image>

<IPLParts>

<IplPart PartNumber=”01″>

<Description>Screw</Description>

<ReferenceNumber>1</ReferenceNumber>

<!– context note translation –>

<ContextNote>

<Value>From 01-september-2015</Value>

<Translations>

<Translation IsoCode=”ES”>Desde 1 septiembre 2015</Translation>

</Translations>

</ContextNote>

<SortOrder>0</SortOrder>

<Quantity>1</Quantity>

</IplPart>

<IplPart PartNumber=”02″>

<Description>Handle</Description>

<ReferenceNumber>2</ReferenceNumber>

<ContextNote>Chrome</ContextNote>

<SortOrder>0</SortOrder>

<Quantity>1</Quantity>

</IplPart>

<IplPart PartNumber=”03″>

<Description>Cover</Description>

<ReferenceNumber>3</ReferenceNumber>

<ContextNote>Chrome</ContextNote>

<SortOrder>0</SortOrder>

<Quantity>1</Quantity>

</IplPart>

<IplPart PartNumber=”04″>

<Description>Cap</Description>

<ReferenceNumber>4</ReferenceNumber>

<ContextNote>Chrome</ContextNote>

<SortOrder>0</SortOrder>

<Quantity>1</Quantity>

</IplPart>

</IPLParts>

</IPL>

</IPLs>

</Model>

<Model Name=”Motor A” Key=”FM2018AMotorA” >

<Attributes>

<Attribute Name=”Code”>FM</Attribute>

<Attribute Name=”Year”>2018</Attribute>

<Attribute Name=”Type”>AMotorA</Attribute>

</Attributes>

<IPLs>

<IPL Name=”Door” Key=”FMA2018A Door”>

<RelationAttributes>

<Attribute Name=”Name”>

<Value>* Override Chassis</Value>

</Attribute>

</RelationAttributes>

<IPLParts>

<IplPart PartNumber=”01″>

<Description>Screw</Description>

<ReferenceNumber>1</ReferenceNumber>

<ContextNote>Metal</ContextNote>

<SortOrder>0</SortOrder>

<Quantity>1</Quantity>

</IplPart>

<IplPart PartNumber=”02″>

<Description>Handle</Description>

<ReferenceNumber>2</ReferenceNumber>

<ContextNote>Chrome</ContextNote>

<SortOrder>0</SortOrder>

<Quantity>1</Quantity>

</IplPart>

</IPLParts>

</IPL>

</IPLs>

</Model>

</Models>

<MasterPartsList>

<Parts>

<Part PartNumber=”SupersedingPartA” Description=”AAA”></Part>

<Part PartNumber=”SupersedingPartB” Description=”BBB”></Part>

<Part PartNumber=”SupersedingPartC” Description=”CCC”></Part>

<Part PartNumber=”SupersedingPartD” Description=”DDD”></Part>

<Part PartNumber=”1234abc” Description=”A Part Description” >

<Translations>

<Translation IsoCode=”IT”>Uno due tre quattro abc</Translation>

</Translations>

<Supersessions GroupType=”AND” Action=”purgeandreplace”>

<Supersession PartNumber=”SupersedingPartA” Uom=”NotSpecified” Quantity=”1″ IsMandatory=”true” />

<Supersession PartNumber=”SupersedingPartB” Uom=”Each” Quantity=”2″ IsMandatory=”true” />

<Supersession PartNumber=”SupersedingPartC” Uom=”” Quantity=”3″ IsMandatory=”true”/>

<Supersession PartNumber=”SupersedingPartD” Uom=”assignDefault” Quantity=”4″ IsMandatory=”true” />

</Supersessions>

<Attributes>

<Attribute Name=”Notes”>Notes</Attribute>

<Attribute Name=”MinimumQuantityOrder”>1</Attribute>

<Attribute Name=”WeightUOM”>lb</Attribute>

<Attribute Name=”Weight”>100</Attribute>

</Attributes>

<Pricing>

<Audience>Default</Audience>

<MSRP>999.99</MSRP>

<Cost>-12</Cost>

<AsOf>05/07/2019</AsOf>

</Pricing>

<Dimensions>

<UOM>mm</UOM>

<Length>5.5</Length>

<Width>0.01</Width>

<Height>399</Height>

</Dimensions>

</Part>

</Parts>

</MasterPartsList>

</Hierarchy>

</Customer>

</ImportData>

 

 

Print this article
Was this article helpful to you? Yes No

How can we help?