Analytics-Plus Help

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>

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>

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>

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>

Share this post : FacebookTwitter