Supported Formats for Importing XML Files
Analytics Plus allows you to import data from XML files. The following are the various XML formats that can be imported into Analytics Plus.
Elements only
The following example illustrates a book store catalog with simple elements.
<books>
<book>
<author>Agatha Kite</author>
<title>Good Night Stories</title>
<genre>children fiction</genre>
<price>$ 8.95</price>
<publish_date>2014-8-01</publish_date>
<publisher>Steve Publishing House</publisher>
</book>
<book>
<author>David Ben</author>
<title>Sword of Ivan</title>
<genre>Historical Fiction</genre>
<price>$ 5.95</price>
<publish_date>2013-12-16</publish_date>
<publisher>Sterling Books</publisher>
</book>
<book>
<author> Ria Johnson</author>
<title> Color Magics</title>
<genre>Fashion</genre>
<price>$ 10.35</price>
<publish_date>2014-4-16</publish_date>
<publisher>Tulip Books</publisher>
</book>
</books>
<book>
<author>Agatha Kite</author>
<title>Good Night Stories</title>
<genre>children fiction</genre>
<price>$ 8.95</price>
<publish_date>2014-8-01</publish_date>
<publisher>Steve Publishing House</publisher>
</book>
<book>
<author>David Ben</author>
<title>Sword of Ivan</title>
<genre>Historical Fiction</genre>
<price>$ 5.95</price>
<publish_date>2013-12-16</publish_date>
<publisher>Sterling Books</publisher>
</book>
<book>
<author> Ria Johnson</author>
<title> Color Magics</title>
<genre>Fashion</genre>
<price>$ 10.35</price>
<publish_date>2014-4-16</publish_date>
<publisher>Tulip Books</publisher>
</book>
</books>
Elements and attributes
The following example illustrates customer contact information with elements, and the customer ID specified as an attribute.
<Customers>
<Customer id="1220">
<Name>Charles Stone</Name>
<Company>Zillium Corp</Company>
<E-mail>charles@zillum.com</E-mail>
<Mobile>415-173-5890</Mobile>
<City>Raleigh</City>
</Customer>
<Customer id="1545">
<Name>Emmy Wilson</Name>
<Company>Fine Pick LTD</Company>
<E-mail>emmmywilson@finepick.com</E-mail>
<Mobile>212-432-9244</Mobile>
<City>Cary</City>
</Customer>
<Customer id="1458">
<Name>Jasmine Frank</Name>
<Company>Fine Pick LTD</Company>
<E-mail>jasminef@acf.com</E-mail>
<Mobile>276-513-8351</Mobile>
<City>Virginia</City>
</Customer>
</Customers>
<Customer id="1220">
<Name>Charles Stone</Name>
<Company>Zillium Corp</Company>
<E-mail>charles@zillum.com</E-mail>
<Mobile>415-173-5890</Mobile>
<City>Raleigh</City>
</Customer>
<Customer id="1545">
<Name>Emmy Wilson</Name>
<Company>Fine Pick LTD</Company>
<E-mail>emmmywilson@finepick.com</E-mail>
<Mobile>212-432-9244</Mobile>
<City>Cary</City>
</Customer>
<Customer id="1458">
<Name>Jasmine Frank</Name>
<Company>Fine Pick LTD</Company>
<E-mail>jasminef@acf.com</E-mail>
<Mobile>276-513-8351</Mobile>
<City>Virginia</City>
</Customer>
</Customers>
Attributes only
The following is an illustration of elements and attributes with the details of the task list assigned to a member.
<Employee name="John Smith" Designation="Designer" E-mail="johns@zillum.com">
<Tasks>
<Task Status ="In Review" Name="Revamping Product Layout" StartDate="10 July, 2014" DueDate="17 Sept, 2014"> </Task>
<Task Status ="In Progress" Name="New Theme Support" StartDate="10 Aug, 2014" DueDate="20 Nov, 2014"> </Task>
<Task Status ="To be Started" Name="Icons redesigning" StartDate="21 Aug, 2013" DueDate="27 Nov, 2014"></Task>
</Tasks>
</Employee>
<Tasks>
<Task Status ="In Review" Name="Revamping Product Layout" StartDate="10 July, 2014" DueDate="17 Sept, 2014"> </Task>
<Task Status ="In Progress" Name="New Theme Support" StartDate="10 Aug, 2014" DueDate="20 Nov, 2014"> </Task>
<Task Status ="To be Started" Name="Icons redesigning" StartDate="21 Aug, 2013" DueDate="27 Nov, 2014"></Task>
</Tasks>
</Employee>
Tree structure
The following example illustrates the tree structured format, with the details of reporting people for each department and vendor.
<Company name="Zillum">
<Departments>
<Department>
<Name>Finance</Name>
<Manager>Tricia Boyle</Manager>
<strength>60</strength>
</Department>
<Department>
<Name>Sales</Name>
<Manager>Dieter Klein</Manager>
<strength>183</strength>
</Department>
</Departments>
<Vendors>
<Vendor>
<Name>Zillium</Name>
<strength>9</strength>
<Reporting>Anna Christy</Reporting>
</Vendor>
<Vendor>
<Name>Fine Pick</Name>
<strength>4</strength>
<Reporting>Emmy Wilson</Reporting>
</Vendor>
</Vendors>
</Company>
<Departments>
<Department>
<Name>Finance</Name>
<Manager>Tricia Boyle</Manager>
<strength>60</strength>
</Department>
<Department>
<Name>Sales</Name>
<Manager>Dieter Klein</Manager>
<strength>183</strength>
</Department>
</Departments>
<Vendors>
<Vendor>
<Name>Zillium</Name>
<strength>9</strength>
<Reporting>Anna Christy</Reporting>
</Vendor>
<Vendor>
<Name>Fine Pick</Name>
<strength>4</strength>
<Reporting>Emmy Wilson</Reporting>
</Vendor>
</Vendors>
</Company>