Supported Formats for Importing XML Files
Supported XML Format
Elements only
The following example illustrates a book store catalog with simple elements.
<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.
<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..
<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.
<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:
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
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 ...