Supported Formats for Importing XML Files
Zoho Analytics supports importing data from XML files. This section lists examples for the different supported XML formats, which can be imported into Zoho Analytics.
Supported XML Format
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 is 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 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 sample illustrates the tree structured format with the details of strength and reporting persons for each department and vendors.
<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>