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>
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Supported Formats for Importing JSON Files
Zoho Analytics supports importing data from JSON files. This section lists examples for the different supported JSON formats, which can be imported into Zoho Analytics. Supported JSON Formats JSON object Simple JSON object The following is a ...Import data from files
If you have data stored in local drives in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...Importing Data into an Existing Table
You can easily import data stored in local drives, web URLs, or cloud storages/drives in various file formats into existing tables in Zoho Analytics. This allows you to update and modify the records in existing tables in a workspace. You could also ...From files and feeds
Often you would already have data locally stored in tabular file formats like CSV, XLS (Excel), JSON, and HTML files. The data in such formats could also be available as a URL or Web feed or even some application generated. Zoho Analytics offers easy ...Import data from JDBC Driver Supported databases
If you have your data stored in JDBC Driver Supported databases, then you can easily import your data into Zoho Analytics for reporting & analysis. Data Import 1. How do I import data from the JDBC Driver Supported databases? 2. How can I edit the ...
New to Zoho LandingPage?
Zoho LandingPage Resources