Hierarchical XML File Examples

This topic provides an example of a source document that is in XML (Problem-Incident-raw.xml), but not in the hierarchical XML format.

You can upload that file using the hierarchical XML import by applying the Problem-Incident.xsl XSL file.

Internally, this transforms the file to be like the Problem-Incident.xml file, which does conform to the hierarchical XML format, and can then be imported.

<Problem>

<ProblemNumber>1000002ProblemNumber>

<Subject>Update antivirus on AV ServersSubject>

<ErrorMessage>Installation failed with error code: xxxxxxErrorMessage>

<Description>The AV on the network securityDescription>

<Status>ActiveStatus>

<Category>AccessibilityCategory>

<Source>Instant MessageSource>

<OwnerTeam>Problem ManagementOwnerTeam>

<Owner>ADaleOwner>

<Urgency>LowUrgency>

<Urgency>HighUrgency>

<Incidents>

<Incident>

<IncidentNumber>50001IncidentNumber>

<Subject>Daily Backup FailureSubject>

<Symptom>Backup failed on serverSymptom>

Incident>

Incidents>

Problem>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:template match="/">

<BusinessObjectList xsi:noNamespaceSchemaLocation="HierarchicalObjects-1.0.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" SchemaVersion="1.0">

<BusinessObject Name="Problem">

<Transaction>UpdateAddTransaction>

<UniqueKeyList>

<UniqueKey>

<Field Name="ProblemNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<Field Name="ProblemNumber">

<xsl:value-of select="Problem/ProblemNumber"/>

Field>

<Field Name="Subject">

<xsl:value-of select="Problem/Subject"/>

Field>

<Field Name="ErrorMessage">

<xsl:value-of select="Problem/ErrorMessage"/>

Field>

<Field Name="Description">

<xsl:value-of select="Problem/Description"/>

Field>

<Field Name="Status">

<xsl:value-of select="Problem/Status"/>

Field>

<Field Name="Category">

<xsl:value-of select="Problem/Category"/>

Field>

<Field Name="Source">

<xsl:value-of select="Problem/Source"/>

Field>

<Field Name="OwnerTeam">

<xsl:value-of select="Problem/OwnerTeam"/>

Field>

<Field Name="Owner">

<xsl:value-of select="Problem/Owner"/>

Field>

<Field Name="Impact">

<xsl:if test="Problem/Impact">

<xsl:value-of select="Problem/Impact"/>

xsl:if>

<xsl:if test="not(Problem/Impact)">

<xsl:text>Lowxsl:text>

xsl:if>

Field>

<Field Name="Urgency">

<xsl:value-of select="Problem/Urgency"/>

Field>

FieldList>

<RelatedBusinessObjectList>

<RelatedBusinessObject Relationship="ProblemAssociatesIncident">

<BusinessObject Name="Incident">

<Transaction>NoneTransaction>

<LinkTransaction>LinkLinkTransaction>

<UniqueKeyList>

<UniqueKey>

<Field Name="IncidentNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<xsl:for-each select="Problem/Incidents/Incident">

<Field Name="IncidentNumber">

<xsl:value-of select="IncidentNumber"/>

Field>

<Field Name="Subject">

<xsl:value-of select="Subject"/>

Field>

<Field Name="Symptom">

<xsl:value-of select="Symptom"/>

Field>

xsl:for-each>

FieldList>

BusinessObject>

RelatedBusinessObject>

RelatedBusinessObjectList>

BusinessObject>

BusinessObjectList>

xsl:template>

xsl:stylesheet>

<BusinessObjectList xsi:noNamespaceSchemaLocation="HierarchicalObjects-1.0.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" SchemaVersion="1.0">

<BusinessObject Name="Problem">

<Transaction>UpdateAddTransaction>

<UniqueKeyList>

<UniqueKey>

<Field Name="ProblemNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<Field Name="ProblemNumber">1000002Field>

<Field Name="Subject">Update antivirus on AV ServersField>

<Field Name="ErrorMessage">Installation failed with error code: xxxxxxField>

<Field Name="Description">The AV on the network securityField>

<Field Name="Status">ActiveField>

<Field Name="Category">AccessibilityField>

<Field Name="Source">Instant MessageField>

<Field Name="OwnerTeam">Problem ManagementField>

<Field Name="Owner">ADaleField>

<Field Name="Impact">LowField>

<Field Name="Urgency">HighField>

FieldList>

<RelatedBusinessObjectList>

<RelatedBusinessObject Relationship="ProblemAssociatesIncident">

<BusinessObject Name="Incident">

<Transaction>NoneTransaction>

<LinkTransaction>LinkLinkTransaction>

<UniqueKeyList>

<UniqueKey>

<Field Name="IncidentNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<Field Name=""IncidentNumber">50001Field>

<Field Name="Subject">Daily Backup FailureField>>

<Field Name="Symptom">Backup failed on serverField>

FieldList>

BusinessObject>

RelatedBusinessObject>

RelatedBusinessObjectList>

BusinessObject>

BusinessObjectList>

This example shows how to import multiple incidents. The transaction is updateAdd, meaning that if the incident number exists, the application updates the incident, but if the incident number does not exist, the application creates the incident. The first record does not include an incident number, so the application creates a new incident. The second record contains an incident number; if that incident already exists, the application updates it, but if it does not exist, the application creates it.

Below, find the following:

<Incidents>

<Incident>

<Customer>Administrator AdminCustomer>

<Summary>test1Summary>

<Category>ConnectivityCategory>

<Description>test1Description>

Incident>

<Incident>

<IncidentNumber>10928IncidentNumber>

<Customer>Administrator AdminCustomer>

<Summary>test21Summary>

<Category>ConnectivityCategory>

<Description>test2 description1Description>

Incident>

Incidents>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:template match="/">

<BusinessObjectList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" SchemaVersion="1.0" xsi:noNamespaceSchemaLocation="HierarchicalObjects-1.0.xsd">

<xsl:apply-templates/>

BusinessObjectList>

xsl:template>

<xsl:template match="/Incidents/Incident">

<BusinessObject Name="Incident">

<Transaction>UpdateAddTransaction>

<UniqueKeyList>

<UniqueKey>

<Field Name="IncidentNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<xsl:if test="IncidentNumber">

<Field Name="IncidentNumber">

<xsl:value-of select="./IncidentNumber"/>

Field>

xsl:if>

<Field Name="ProfileLink">

<xsl:value-of select="./Customer"/>

Field>

<Field Name="Subject">

<xsl:value-of select="./Summary"/>

Field>

<Field Name="Category">

<xsl:value-of select="./Category"/>

Field>

<Field Name="Symptom">

<xsl:value-of select="./Description"/>

Field>

FieldList>

BusinessObject>

xsl:template>

xsl:stylesheet>

<BusinessObjectList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="HierarchicalObjects-1.0.xsd" SchemaVersion="1.0">

<BusinessObject Name="Incident">

<Transaction>UpdateAddTransaction>

<UniqueKeyList>

<UniqueKey>

<Field Name="IncidentNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<Field Name="ProfileLink">Administrator AdminField>

<Field Name="Subject">test1Field>

<Field Name="Category">ConnectivityField>

<Field Name="Symptom">test1Field>

FieldList>

BusinessObject>

<BusinessObject Name="Incident">

<Transaction>UpdateAddTransaction>

<UniqueKeyList>

<FieldList>

<Field Name="IncidentNumber"/>

UniqueKey>

UniqueKeyList>

<FieldList>

<Field Name="IncidentNumber">10928Field>

<Field Name="ProfileLink">Administrator AdminField>

<Field Name="Subject">test2Field>

<Field Name="Category">ConnectivityField>

<Field Name="Symptom">test2Field>

FieldList>

BusinessObject>

BusinessObjectList>