Importing Hierarchical XML Data

about hierarchical xml format docid\ okuttb 6toejjqxzevvgnhierarchical xml notes docid\ okuttb 6toejjqxzevvgnexample import file incident containing task assignment containing journal notes docid\ okuttb 6toejjqxzevvgnhierarchical xml file import notes docid\ qm5jp6jct53fjt35niza hierarchical xml file examples docid 0phqdo5fshnjmjhxvn 6u about hierarchical xml format can import xml files containing more than one business object to do so, the file must follow a strict format (outlined below) the hierarchical import process supports preprocessing via xslt to transcribe your current data format to meet this requirement large files (over 50 mb) take longer to preview, because the entire file is downloaded before the first batch can be shown in other types, the copy/download occurs when moving from the connection to the object mapping page in hierarchical xml, we bypass all mapping pages; hence, the copy/download only occurs when a user wants to preview the file the 1 0 schema the xml must follow is \<xs\ schema xmlns\ xs=" http //www w3 org/2001/xmlschema " version="1 0"> \<! decimal or empty string > \<xs\ simpletype name="decimal or empty"> \<xs\ union membertypes="xs\ decimal empty string" /> \</xs\ simpletype> \<xs\ simpletype name="empty string"> \<xs\ restriction base="xs\ string"> \<xs\ enumeration value="" /> \</xs\ restriction> \</xs\ simpletype> \<! parent/primary businessobject (bo) > \<xs\ element name="businessobject"> \<xs\ complextype> \<xs\ all> \<! parent/primary bo transaction action > \<xs\ element name="transaction" minoccurs="1" maxoccurs="1"> \<xs\ simpletype> \<xs\ restriction base="xs\ string"> \<! insert only if it does not exist will not update and error if it exists > \<xs\ enumeration value="insert"/> \<! update only if it exists will not insert and error if it does not exist > \<xs\ enumeration value="update"/> \<! insert if it does not exist or update if it exists > \<xs\ enumeration value="updateadd"/> \<! delete if it exists or ignore if it does not exist > \<xs\ enumeration value="delete"/> \<! do nothing > \<xs\ enumeration value="none"/> \</xs\ restriction> \</xs\ simpletype> \</xs\ element> \<xs\ element name="linktransaction" minoccurs="0" maxoccurs="1"> \<xs\ simpletype> \<xs\ restriction base="xs\ string"> \<! link to parent/primary bo > \<xs\ enumeration value="link"/> \<! unlink from parent/primary bo > \<xs\ enumeration value="unlink"/> \<! do nothing > \<xs\ enumeration value="none"/> \</xs\ restriction> \</xs\ simpletype> \</xs\ element> \<! list of composite keys that uniquely locate the onject in the target system > \<xs\ element name="uniquekeylist" minoccurs="1" maxoccurs="1"> \<xs\ complextype> \<xs\ sequence> \<! in schema version 1 0 only one unique key is supported > \<xs\ element name="uniquekey" minoccurs="1" maxoccurs="1"> \<xs\ complextype> \<xs\ sequence> \<xs\ element name="field" minoccurs="1" maxoccurs="unbounded"> \<xs\ complextype> \<xs\ attribute name="name" type="xs\ string" use="required"/> \</xs\ complextype> \</xs\ element> \</xs\ sequence> \</xs\ complextype> \</xs\ element> \</xs\ sequence> \</xs\ complextype> \</xs\ element> \<xs\ element name="fieldlist" minoccurs="1" maxoccurs="1"> \<xs\ complextype> \<xs\ sequence> \<xs\ element name="field" minoccurs="0" maxoccurs="unbounded"> \<xs\ complextype mixed="true"> \<xs\ all> \<xs\ element name="languagevalues" minoccurs="0" maxoccurs="1"> \<xs\ complextype mixed="true"> \<xs\ all> \<xs\ element name="de" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="fr" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="es" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="pt br" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="nl" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="jp" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="ru" type="xs\ string" minoccurs="0" maxoccurs="1"/> \<xs\ element name="default" type="xs\ string" minoccurs="0" maxoccurs="1"/> \</xs\ all> \</xs\ complextype> \</xs\ element> \<xs\ element name="currencyvalue" type="decimal or empty" minoccurs="0" maxoccurs="1"/> \<xs\ element name="currencycode" type="xs\ string" minoccurs="0" maxoccurs="1"/> \</xs\ all> \<xs\ attribute name="name" type="xs\ string" use="required"/> \<xs\ attribute name="type" use="optional"> \<xs\ simpletype> \<xs\ restriction base="xs\ string"> \<xs\ enumeration value="" /> \<xs\ enumeration value="system string" /> \<xs\ enumeration value="system int32" /> \<xs\ enumeration value="system int64" /> \<xs\ enumeration value="system single" /> \<xs\ enumeration value="system double" /> \<xs\ enumeration value="system decimal" /> \<xs\ enumeration value="system datetime" /> \<xs\ enumeration value="system boolean" /> \<xs\ enumeration value="currency" /> \</xs\ restriction> \</xs\ simpletype> \</xs\ attribute> \</xs\ complextype> \</xs\ element> \</xs\ sequence> \</xs\ complextype> \</xs\ element> \<! list of related bos > \<xs\ element name="relatedbusinessobjectlist" minoccurs="0" maxoccurs="1"> \<xs\ complextype> \<xs\ sequence> \<! support a maximum of 100 related objects for each parent/primary bo > \<xs\ element name="relatedbusinessobject" maxoccurs="100"> \<xs\ complextype> \<xs\ sequence> \<xs\ element ref="businessobject" minoccurs="0" maxoccurs="1"/> \</xs\ sequence> \<xs\ attribute name="relationship" type="xs\ string" use="required"/> \</xs\ complextype> \</xs\ element> \</xs\ sequence> \</xs\ complextype> \</xs\ element> \</xs\ all> \<xs\ attribute name="name" type="xs\ string" use="required"/> \</xs\ complextype> \</xs\ element> \<! hierarchical business objects > \<xs\ element name="businessobjectlist"> \<xs\ complextype> \<xs\ sequence> \<xs\ element ref="businessobject" maxoccurs="unbounded"/> \</xs\ sequence> \<xs\ attribute name="schemaversion" use="required"> \<xs\ simpletype> \<xs\ restriction base="xs\ string"> \<! schema versions > \<xs\ enumeration value="1 0"/> \</xs\ restriction> \</xs\ simpletype> \</xs\ attribute> \</xs\ complextype> \</xs\ element> \</xs\ schema> hierarchical xml notes the schemaversion attribute must be 1 0 the maximum levels of child business object is two for example, incident task assignment journal notes the transaction must be one of the following insert, update, updateadd, delete, or none updateadd inserts a new record if not found, or updates it if it is found none is used when only child business object is linked or unlinked otherwise, there is no action linktransaction must be one of the following link, unlink, or none linktransaction is only used in the child business object context if it is specified in the root level parent info, it is ignored the maximum number of relationbusinessobjects supported is 100 the type attribute can be one of the following system int32 system int64 system single system double system decimal system datetime system boolean currency example import file incident containing task assignment containing journal notes \<?xml version="1 0" encoding="utf 8"?> \<businessobjectlist schemaversion="1 0" xmlns\ xsi=" http //www w3 org/2001/xmlschema instance " xsi\ nonamespaceschemalocation="hierarchicalobjects 1 0 xsd"> \<businessobject name="incident"> \<transaction>updateadd\</transaction> \<uniquekeylist> \<uniquekey> \<field name="incidentnumber" /> \</uniquekey> \</uniquekeylist> \<fieldlist> \<field name="incidentnumber">50011\</field> \<field name="subject">daily backup failure\</field> \<field name="symptom">backup failed on server\</field> \<field name="service">data service\</field> \<field name="category">backup\</field> \<field name="owner">jclerk\</field> \<field name="ownerteam">service desk\</field> \<field name="impact">low\</field> \<field name="urgency">high\</field> \<field name="source">phone\</field> \<field name="profilelink">john m doe\</field> \</fieldlist> \<relatedbusinessobjectlist> \<relatedbusinessobject relationship="incidentassoctaskassignment"> \<businessobject name="task assignment"> \<transaction>updateadd\</transaction> \<linktransaction>link\</linktransaction> \<uniquekeylist> \<uniquekey> \<field name="assignmentid" /> \</uniquekey> \</uniquekeylist> \<fieldlist> \<field name="assignmentid">400011\</field> \<field name="subject">please restore the backup on the server\</field> \<field name="ownerteam">service desk\</field> \</fieldlist> \<relatedbusinessobjectlist> \<relatedbusinessobject relationship="incidentcontainsjournal"> \<businessobject name="journal notes"> \<transaction>updateadd\</transaction> \<linktransaction>link\</linktransaction> \<uniquekeylist> \<uniquekey> \<field name="recid" /> \</uniquekey> \</uniquekeylist> \<fieldlist> \<field name="recid">2b4fdd4bf1fd49ffad4bf0249a4038ee\</field> \<field name="category">memo\</field> \<field name="source">voice mail\</field> \<field name="subject">additional info request\</field> \<field name="timespent">10\</field> \<field name="notesbody">how soon do you need the backup \</field> \</fieldlist> \</businessobject> \</relatedbusinessobject> \</relatedbusinessobjectlist> \</businessobject> \</relatedbusinessobject> \</relatedbusinessobjectlist> \</businessobject> \</businessobjectlist>