"The programmer, like the poet, works only slightly removed from pure thought-stuff. He builds his castles in the air, from air, creating by exertion of the imagination." - Fred Brooks
Bookmark and Share      
XML Converter Standard Edition

Most of companies around the world have a big endowment in their existing software applications. In the main, these software products work well. Although, if they can transform their data to an XML output and can admit XML for data input, then their data can be expanded and made much more flexible and useful. MS Office formats are the most widely used data files for common business documents today, and XML is the most suitable information storage format for the future. How can them be adapted? XML Converter is useful in a number of situations. It is the most user-friendly XML converting engine and requires less programming expertise. Also, any programming skills are not required to configure XML tags and an XSLT script to convert the raw source data into the final desired XML result.

Download demo-trial now!

In a nutshell about XML
Everyone heard about XML. XML (Extensible Markup Language) is also called meta-language, which means that it can describe other languages. XML is neutral, flexible and easier to handle for data exchange. XML is the new standard for databases and World Web, revolutionizes Internet already today. XML is NOT another HTML. The main idea of XML/XSLT is to separate a presentation and content. XML is a best way to store and represent any data in a highly flexible and structured way.

The address of this page has been changed to:
http://rustemsoft.com/xmlconverter1.htm

The XML Converter is a data converting software lets the user to interactively create a data transformation. It allows you to use XML documents by exporting source data into XML file. XML Converter is a visual mapping and conversion tool, which manages all dialects of XML such as DTD(document type definition), XSD(XML Schema Definition), and XML formats. It is used for quickly building application integration solutions. It will allow you to map and integrate some types of data to XML document in a user-friendly graphical mode.

Do you need to convert XML to Excel, CSV, HTML, txt, Access mdb?
Please learn more about XMLFox Advance XML/XSD Editor
Download XMLFox Advance XML/XSD Editor
Order XMLFox Advance XML/XSD Editor

Sonswish - Oracle database browser
More about Sonswish
Download Sonswish Trial
Order Sonswish

If you would like to use software with no user interface, allowing you to convert Data Source to XML in batch mode we can offer to you our XML Converter with command-line interface.
Learn more about XML Converter with command-line interface


XML Converter quickly and easily converts source data types include the following:

ODBC data sources
Oracle tables or views
MS SQL Server tables or views Microsoft Excel books
MySQL tables or views Microsoft Access databases Microsoft Word documents Text files(csv, tab-delimited)

XML Converter takes care of frequent XML creation with single, easy method support for exporting data to XML. The output file is a well-formed XML from a standard template, and may come (if you need) with a standard eXtensible Style Language (XSL) sheet to render the output to HTML-view using the well-known MS Internet Explorer and a latest version of Netscape Navigator. The XSL give you ability to extract, transform and render the content of an XML file. And now this specification is supported by popular of Internet browsers and you do not need a physical transformation your XML document into HTML files.

New Features

ODBC connection
Rustemsoft XML Converter can connect to any database that provides an ODBC connection interface. Please refer to your database providers' specifications to determine the availability of an ODBC connection and the connection string necessary.

XML Editor features
XML Converter includes XML View, XML Tree, XML Grid, and XML Script modes for final XML output editing. These editing features are presented in well-known XMLFox free XML Editor. All XML Converter Editions packages include that freeware convenient XML/XSD Editor.

SQL View for MySQL database
Actually current version of MySQL database has no any view objects. By using XML Converter you can create a view for your MySQL database, update and store it. Since MySQL does not have views these SQL query objects will not be stored into your MySQL database. These objects can be reusable and will be stored separately of your MySQL database. They are properties of Rustemsoft XML Converter.

Supporting Oracle database
XML Converter supports any Oracle database. XML Converter is an easy to use tool with full export, edit, query and sorting capabilities. New conversion, editing and intelligent navigation features make data browsing easier and faster for you:
Read data directly from Oracle databases.
Update data directly to Oracle databases. Change data field's values, delete and add records to Oracle tables.
Transform Oracle tables to XML format
Create and update Oracle views. By using XML Converter you can create a view in your Oracle database, update and store it.
Transform Oracle views to XML format. You can browse view result in data grid and convert to XML document.
Quickly sort records in a data grid by just clicking on the column header.

XML tags Setup interface
On the "XML tags Setup" menu bar you can adjust tags for your generated XML output by entering some expression in particular boxes. A key aspect of dealing with XML documents is to be able to easily access their content. XML Converter provides an easy "XML tags Setup" interface for specifying and selecting parts of an XML document. Extensible Markup Language allows a person to invent an array of tags to describe their data. Tags are as important in XML as in HTML. They allow you to describe your data elements and give them life. A person could invent a set of tags to describe a data structure. XML Converter has 4 tag levels of generated XML output. By using the "XML tags Setup" interface you may adjust a representation of each of them.

Example
This demonstration highlights XML Converter technique. We need to transform the simplest MS Excel spreadsheet:

After converting to XML document we can browse a final file by using MS Internet Explorer (version 5 and later). Internet Explorer knows how to show XML in structured format.

The MS Internet Explorer can be used on the client with XML but this view is not friendly for human eyes. To adjust this view and obtain a readable XML presentation we need let the browser to transform XML file to HTML format using the rules of an XSL stylesheet. The Extensible Style Language (XSL) is a very powerful language that allows us to specify rules that transform an XML document tree into a formatted tree we can display in the browser. Besides creating an XML document the XML Converter will allow you to generate special XSL document for this final XML file. For this case you should go to the menu bar "Options" and check the question "Would you like to accompany your XML document with a template XSL style-sheet?". Both of these files can be used for your further needs such as: web-applications, reports, presentations, and so on.

The process of exporting XML from Excel (ODBC data sources, Oracle DB, MS Access .mdb database, MS Word .doc document or text .txt, csv file) involves these basic steps:

Run XML Converter
Open Source file by using 'Open' dialog box
Choose a spreadsheet (or table), which you want to convert from opened Excel book (ODBC data source, Oracle database, Access database, Word document or text file)
To start data transformation just click one of destination file type buttons: DTD, XSD or XML
After reviewing or editing your destination XML output file in special window you can save the file by using 'Save' dialog box

In the toolbar on main form, click 'Open' button. Choose an object from the Select Data Source dialog box and press Open. The XML Converter allows you choose the raw data storage format from either the ODBC DSN, MS Access database, MS Word document, text file, Excel Book, or Oracle table structure.

In the toolbar on main form, click 'Save' button. Choose where you would like to save your destination file.

The XML Converter allows you to browse source data and make analysis of data source structure. This software has database navigation features that provide the ability to view your entire source file. The XML Converter allows users to see source files that they are opening for converting. Also after converting you can review and edit destination XML document. XML Converter includes XML View, XML Tree, XML Grid, and XML Script modes for XML output editing.

Options menu bar


On the "Options" menu bar you can adjust your XML transformation by selecting some particular types of the "XML writing methods" and "XML mapping methods".

XML writing method

XML writing method specifies how the XML output file is to be written.

Writing method

Description

XML without Schema

Store the Source data as XML data, without an XSD schema. This is the default.

XML with Schema

Store the Source data as XML data with the relational structure as inline XSD schema.

XML in DiffGram format

Store the whole Source data as a DiffGram, including original and current values. The DiffGram is a format intended for network data exchange and .NET remoting.

XML with DTD

Store the Source data as XML data with the DTD specification.

XML with TransX Schema

Store the Source data as an XML data with the TransX Schema. The Oracle TransX Utility could use your final XML file to populate an Oracle database.


XML mapping method

The Mapping method determines how each Source data column is mapped when a XML document is saved.

Mapping method

Description

Map out as Element

By using this mapping method the Source data columns are written as XML elements where the ColName is the name of the element and the contents of the column are written as the text of the element. For example, if Mapping method is set to "Map out as Element", the column value will produce the following XML:
<ColName>Column Contents</ColName>
This is the default.

Map out as Attribute

Due to this mapping method the Source data columns are written as XML attributes of the XML document elements for the current row where the ColName is the name of the attribute and the contents of the Source data column are written as the value of the attribute. For example, using the "Map out as Attribute" method the following XML is produced:
<RowElement ColName="Column Contents" />

Map out as Row Content

This method allows us to write contents of the Source data columns as text in the XML elements for the current row. Example:
<RowElement>Column Contents</RowElement>
You should know that "Map out as Row Content" method cannot be set for Source data columns of a table that has Element columns (more than one column) or nested relations.

Hidden

The Source data columns will not be written in the XML document.


XML Converter two editions

Two editions of XML Converter are available: a Standard Edition and a Professional Edition. The Standard Edition is an economical solution for users who need to view the Data Source and Target XML document in order to better understand how to built a best XML representation. With the Standard Edition, users can browse the Data Source and Target XML file to generate XML output easily using a graphical user interface, without adding costly instrumentation.

XML Converter Professional Edition is a complete solution for the developer who wants the browse facilities provided in the Standard Edition PLUS special modules, which provide command-line interface. Using the Professional Edition you will be able to call XML Converter strictly from your own application, with no user interface, allowing you to convert Data Source to XML in batch mode.






Copyright © 2001-2024 Rustemsoft LLC All Rights Reserved.

User opinions

I have been using XML Converter for over two years now, and have found it entirely satisfactory in performing the functions I wished to achieve. I was in the position of needing a utility which would write an XSD file from an SQL Server View, so that I could prepare a Crystal Report for publication within our CRM system.
I looked at several options, and quickly concluded that Rustem's XML Converter was an economic and capable programme which suited my needs. I have not been disappointed. The software is very reliable, and with very little additional 'tweaking', the XSD produced was available for publication. I have no hesitation in recommending this excellent utility to others.

David White
Senior Training and Development Officer
Capita .ict
Northampton, UK




Very many thanks. It works fine. The feature of XML Converter which I use is to create multi-table xml files to feed websites. Access 2010 will create individual table xml exports but not what I need without a lot of post-export processing. The original investment in XML Converter has served me well.

Jerry Stockbridge
Lowe Projects, SW London, UK




Thank you for the nice software and the awesome service!
I wish I had the same kind of support from other SW development companies!

Eszter Hidasi
Senior consultant
IPR-Insights Consulting & Research
Hungary




The people from Rustemsoft have been wonderful to work with.
They guide you thru each step in the process. If you have any question as to how to use the program, how to install it or what to do with the output, Rustemsoft support staff will answer it.
They are very patient, even with someone who knows little about computers.
This program can be used by experts down to novices and in surprising easy fashion. I would highly recommend the Rustemsoft XML Converter program for anyone in need of this type of program.

Thank you for all of your help!

Mike Hartoin
Bills Battery, Cincinnati, OH




It is useful software that you provide to the consumer.
It is fast, easy to use and reasonable price for purchase.
I definitely love it and will use it daily. The XML Converter has saved me a lot of time.
Thank you very much for a wonderful product.

Khoa Nguyen
IT Business Analyst