Hierarchical XML File Examples

7 min

example 1 importing a problem and incident docid 0phqdo5fshnjmjhxvn 6uexample 2 importing multiple incidents docid 0phqdo5fshnjmjhxvn 6u example 1 importing a problem and incident 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 example 1 source docid 0phqdo5fshnjmjhxvn 6uexample 1 xsl file docid 0phqdo5fshnjmjhxvn 6uexample 1 output docid 0phqdo5fshnjmjhxvn 6u example 1 source \\ \\<\\problem\\\>\ \\<\\problemnumber\\\>\ 1000002 \\\problemnumber\\\>\ \\<\\subject\\\>\ update antivirus on av servers \\\subject\\\>\ \\<\\errormessage\\\>\ installation failed with error code xxxxxx \\\errormessage\\\>\ \\<\\description\\\>\ the av on the network security \\\description\\\>\ \\<\\status\\\>\ active \\\status\\\>\ \\<\\category\\\>\ accessibility \\\category\\\>\ \\<\\source\\\>\ instant message \\\source\\\>\ \\<\\ownerteam\\\>\ problem management \\\ownerteam\\\>\ \\<\\owner\\\>\ adale \\\owner\\\>\ \\<\\urgency\\\>\ low \\\urgency\\\>\ \\<\\urgency\\\>\ high \\\urgency\\\>\ \\<\\incidents\\\>\ \\<\\incident\\\>\ \\<\\incidentnumber\\\>\ 50001 \\\incidentnumber\\\>\ \\<\\subject\\\>\ daily backup failure \\\subject\\\>\ \\<\\symptom\\\>\ backup failed on server \\\symptom\\\>\ \\\incident\\\>\ \\\incidents\\\>\ \\\problem\\\>\ example 1 xsl file \\ \\<\\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\\\>\ updateadd \\\transaction\\\>\ \\<\\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\\\>\ low \\\xsl\ text\\\>\ \\\xsl\ if\\\>\ \\\field\\\>\ \\<\\field name\\="\ urgency \"\>\ \\<\\xsl\ value of select\\="\ problem/urgency \"/\>\ \\\field\\\>\ \\\fieldlist\\\>\ \\<\\relatedbusinessobjectlist\\\>\ \\<\\relatedbusinessobject relationship\\="\ problemassociatesincident \"\>\ \\<\\businessobject name\\="\ incident \"\>\ \\<\\transaction\\\>\ none \\\transaction\\\>\ \\<\\linktransaction\\\>\ link \\\linktransaction\\\>\ \\<\\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\\\>\ example 1 output \\ \\<\\businessobjectlist xsi\ nonamespaceschemalocation\\="\ hierarchicalobjects 1 0 xsd \"\ \xmlns\ xsi\\="\ http //www w3 org/2001/xmlschema instance \" \\schemaversion\\="\ 1 0 \"\>\ \\<\\businessobject name\\="\ problem \"\>\ \\<\\transaction\\\>\ updateadd \\\transaction\\\>\ \\<\\uniquekeylist\\\>\ \\<\\uniquekey\\\>\ \\<\\field name\\="\ problemnumber \"/\>\ \\\uniquekey\\\>\ \\\uniquekeylist\\\>\ \\<\\fieldlist\\\>\ \\<\\field name\\="\ problemnumber \"\>\ 1000002 \\\field\\\>\ \\<\\field name\\="\ subject \"\>\ update antivirus on av servers \\\field\\\>\ \\<\\field name\\="\ errormessage \"\>\ installation failed with error code xxxxxx \\\field\\\>\ \\<\\field name\\="\ description \"\>\ the av on the network security \\\field\\\>\ \\<\\field name\\="\ status \"\>\ active \\\field\\\>\ \\<\\field name\\="\ category \"\>\ accessibility \\\field\\\>\ \\<\\field name\\="\ source \"\>\ instant message \\\field\\\>\ \\<\\field name\\="\ ownerteam \"\>\ problem management \\\field\\\>\ \\<\\field name\\="\ owner \"\>\ adale \\\field\\\>\ \\<\\field name\\="\ impact \"\>\ low \\\field\\\>\ \\<\\field name\\="\ urgency \"\>\ high \\\field\\\>\ \\\fieldlist\\\>\ \\<\\relatedbusinessobjectlist\\\>\ \\<\\relatedbusinessobject relationship\\="\ problemassociatesincident \"\>\ \\<\\businessobject name\\="\ incident \"\>\ \\<\\transaction\\\>\ none \\\transaction\\\>\ \\<\\linktransaction\\\>\ link \\\linktransaction\\\>\ \\<\\uniquekeylist\\\>\ \\<\\uniquekey\\\>\ \\<\\field name\\="\ incidentnumber \"/\>\ \\\uniquekey\\\>\ \\\uniquekeylist\\\>\ \\<\\fieldlist\\\>\ \\<\\field name\\="\ " incidentnumber \"\>\ 50001 \\\field\\\>\ \\<\\field name\\="\ subject \"\>\ daily backup failure \\\field\\\>\ > \\<\\field name\\="\ symptom \"\>\ backup failed on server \\\field\\\>\ \\\fieldlist\\\>\ \\\businessobject\\\>\ \\\relatedbusinessobject\\\>\ \\\relatedbusinessobjectlist\\\>\ \\\businessobject\\\>\ \\\businessobjectlist\\\>\ example 2 importing multiple incidents 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 example 2 source docid 0phqdo5fshnjmjhxvn 6uexample 2 xslt file docid 0phqdo5fshnjmjhxvn 6uexample 2 output docid 0phqdo5fshnjmjhxvn 6u example 2 source \\ \\<\\incidents\\\>\ \\<\\incident\\\>\ \\<\\customer\\\>\ administrator admin \\\customer\\\>\ \\<\\summary\\\>\ test1 \\\summary\\\>\ \\<\\category\\\>\ connectivity \\\category\\\>\ \\<\\description\\\>\ test1 \\\description\\\>\ \\\incident\\\>\ \\<\\incident\\\>\ \\<\\incidentnumber\\\>\ 10928 \\\incidentnumber\\\>\ \\<\\customer\\\>\ administrator admin \\\customer\\\>\ \\<\\summary\\\>\ test21 \\\summary\\\>\ \\<\\category\\\>\ connectivity \\\category\\\>\ \\<\\description\\\>\ test2 description1 \\\description\\\>\ \\\incident\\\>\ \\\incidents\\\>\ example 2 xslt file \\<\\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\\\>\ updateadd \\\transaction\\\>\ \\<\\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\\\>\ example 2 output \\ \\<\\businessobjectlist \\xmlns\ xsi\\="\ http //www w3 org/2001/xmlschema instance \"\ \xsi\ nonamespaceschemalocation\\="\ hierarchicalobjects 1 0 xsd \"\ \schemaversion\\="\ 1 0 \"\>\ \\<\\businessobject name\\="\ incident \"\>\ \\<\\transaction\\\>\ updateadd \\\transaction\\\>\ \\<\\uniquekeylist\\\>\ \\<\\uniquekey\\\>\ \\<\\field name\\="\ incidentnumber \"/\>\ \\\uniquekey\\\>\ \\\uniquekeylist\\\>\ \\<\\fieldlist\\\>\ \\<\\field name\\="\ profilelink \"\>\ administrator admin \\\field\\\>\ \\<\\field name\\="\ subject \"\>\ test1 \\\field\\\>\ \\<\\field name\\="\ category \"\>\ connectivity \\\field\\\>\ \\<\\field name\\="\ symptom \"\>\ test1 \\\field\\\>\ \\\fieldlist\\\>\ \\\businessobject\\\>\ \\<\\businessobject name\\="\ incident \"\>\ \\<\\transaction\\\>\ updateadd \\\transaction\\\>\ \\<\\uniquekeylist\\\>\ \\<\\fieldlist\\\>\ \\<\\field name\\="\ incidentnumber \"/\>\ \\\uniquekey\\\>\ \\\uniquekeylist\\\>\ \\<\\fieldlist\\\>\ \\<\\field name\\="\ incidentnumber \"\>\ 10928 \\\field\\\>\ \\<\\field name\\="\ profilelink \"\>\ administrator admin \\\field\\\>\ \\<\\field name\\="\ subject \"\>\ test2 \\\field\\\>\ \\<\\field name\\="\ category \"\>\ connectivity \\\field\\\>\ \\<\\field name\\="\ symptom \"\>\ test2 \\\field\\\>\ \\\fieldlist\\\>\ \\\businessobject\\\>\ \\\businessobjectlist\\\>\