XML Converter manual


  • Welcome to XML Converter manual
  • Authoring requirements
  • Licensing details
  • What is the registration?
  • How can I register?
  • Getting started
  • Main XML Converter window
  • Main dialog toolbar
  • Explore the Data Source
  • Connecting to a Database
  • ODBC connection
  • Oracle Table Data editing
  • XML Transformation Scenario
  • Store Oracle/MS SQL Server/MySQL query results as an XML output
  • XML tags Setup
  • Options menu bar
  • Convert source data to Oracle database
  • Micros special conversion modules
  • XML Converter Professional Edition
  • Executable module signature
  • Configuration file default.cfg and Startup Options interface
  • Welcome to XML Converter manual

    XML Converter is the Windows based graphical transformation engine for creating XML documents from your database. It allows organizations to quickly and easily share information, captured within corporate data, with anyone in the world by utilizing established XML document definitions. Using this software, enterprises can share data with customers, suppliers or partners as well as distribute data across business units. XML Converter is great for producing fast, static, simple, data-driven XML documents.


    Just choose your data source, select transformation methods, and generate the XML. This tool quickly and easily converts source data from Microsoft Access .mdb databases, Microsoft Excel .xls books, MS Word .doc document or text .txt file. XML Converter supports major databases such as Oracle, MySQL and MS SQL Server. In the future it will handle also any ODBC database. Once you've selected a table, you can control the output by choosing between several XML writing and mapping transformation methods. 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. It 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 takes all the guesswork out of designing and authoring database publishing projects from start to finish. You don’t need to know any Extensible Markup Language (XML) or Extensible Style Language (XSL). Besides creating an XML document the XML Converter will allow you to generate special XSL document, which will accompany your final 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 elegant tabbed design assists you through the transformation process.



    Authoring requirements

    XML Converter is designed for both 32-bit and 64-bit operating systems and works under the Microsoft® .NET Framework.

    The XML Converter runs on:
    - Microsoft Windows NT® 4.0 (SP 6a required)
    - Microsoft Windows 2000 (SP2 Recommended)
    - Microsoft Windows XP Professional
    - Microsoft Windows XP Home Edition
    - Microsoft Windows Vista Family
    - Microsoft Windows 7 Family
    (Windows 95/98/ME and Windows 3.1 systems are not supported)

    Software Requirements:
    Microsoft Internet Explorer 5.01 or later (install Internet Explorer 6.0)

    To author with XML Converter, your system should be equipped with the following:

    Pentium 90 MHz (minimum) or faster (recommended)

    32 MB RAM (minimum) or more (96 MB or more recommended)

    50 MB free disk space (minimum) or more

    Important: Do not open a Microsoft Excel file (or MS Word file) that is being used as a source during the XML Converter execution, because a "file in use" error will occur.



    Licensing details
    The following License Agreement is for a registered copy of XML Converter only.

    License Agreement


    Before installing RS XML Converter please read carefully terms and conditions of this agreement. You will express your consent to be bound by the terms of this Agreement by obtaining or opening Software media package. If you do not agree to all terms of this agreement do not use Software and destroy all copies of Software from your computer.

    Grant of license:

    Rustemsoft (the Developer) grants you (the Customer) a worldwide, non-exclusive, non-transferable, personal license to install and use the accompanying XML Converter (the Software) in the manner provided herein.

    1. Software is licensed, not sold. Software is protected by copyright law, international copyright treaty provisions and other intellectual property laws and treaties. Customer must not allow copies of Software or any part of it to be made or distributed to anyone else. Customer may make backup copies of Software for archival purposes only.

    2. Software is licensed for use on a single computer. Customer may delete Software from one computer and reinstall it on another, but Customer may not install Software on more than one computer at any given time without Developer's prior written permission.

    3. Software may not be rented, leased, nor in any other manner commercially exploited without Developer's prior written permission.

    4. Developer makes no representations or warranties about the suitability of this Software for any purpose. Software is provided 'as is' without express or implied warranties, including warranties of merchantability and fitness for a particular purpose or non-infringement. Developer may not issue updates to this Software.

    5. All data sources accessed through Software is the property of the applicable content owner and may be protected by applicable copyright law.This license gives Customer no rights to such content, and Developer disclaims any liability for misuse of data sources.

    6. Title, ownership rights, and intellectual property rights in and to Software shall remain with Developer. Customer agrees not to modify Software or attempt to decipher, disassemble, decompile or reverse engineer Software. Reproduction and/or redistribution of any portion of Software is prohibited without Developer's prior written permission.

    7. Developer may terminate this license at any time by delivering notice to Customer and Customer may terminate this license at any time by destroying or erasing Customer's copy of Software. Upon termination of this license, Customer agrees to destroy all copies of Software. In case of termination sections 4 through 10 of this agreement shall indefinitely survive its termination. This license is the complete statement of the agreement between Developer and Customer and merges and supersedes all other or prior understandings, purchase orders, agreements and arrangements.

    8. Developer or its suppliers shall not be liable for direct, incidental, consequential, special or indirect damages of any sort whatsoever. This includes loss of business profits, revenues, information, or business interruption resulting from Customer's use of Software or inability to use Software, even if Developer has been informed of the possibility of such damages.

    9. This Software is not fault-tolerant. It is not designed, manufactured or intended for use in hazardous environments requiring fail-safe performance. Developer and its suppliers specifically disclaim any express or implied warranty of fitness for high-risk activities.

    10. Developer reserves the right to discontinue distribution and/or support of its products at any time without notice. Developer reserves the right to change the prices of its products and services at any time without notice. Developer reserves the right to put Customer's company name on User representative list at Rustemsoft web site.

    Complete agreement:

    This Agreement is the entire agreement between you and Developer relating to its subject matter. This Agreement may not be modified other than in writing executed by Rustemsoft.

    Copyright © 2001-2024Rustemsoft. All rights reserved.



    What is the registration?

    XML Converter is "Shareware". This means that we have made the software available to you for the trial. The evaluation is not slideshow presentation. You can create, format, map, view, edit an XML output. It is fully functional but you can use it for limited time only. And then, if you decide to buy the software, you must register your copy with us.

    Evaluation version (non-registered) of XML Converter is a "full-featured" release. This means that the same capabilities available in the registered software are present in the non-registered software. This allows you to try out all the features in XML Converter to confirm that they work to your satisfaction.

    Registration entitles you free technical support for 30 days and free minor upgrades to the software. Registration may also entitle you to discounts on new software releases from Rustemsoft. Developer will also send you information bulletins by email to let you know about what’s happening with Rustemsoft products.

    Finally, by registering the software, you provide us with the resources and incentive to support the software with updates and to develop additional quality products in the future.



    How can I register?

    Point your browser to one of the following Order Forms to register online:

    XML Converter Standard Edition

    XML Converter with command-line interface

    XML Converter Professional Edition



    Getting started

    1. Run XML Converter

    2. Open Source file by using 'Open' dialog box

    3. Choose a spreadsheet (or table), which you want to convert from opened Microsoft Access .mdb databases, Microsoft Excel .xls books, MS Word .doc document, Oracle table / view, or text .txt file.

    4. To start data transformation just click one of destination file type buttons: DTD, XSD or XML

    5. After reviewing or editing your destination file in special window you can save the file by using 'Save' dialog box



    Main XML Converter window

    The XML Converter main window is split into two sections (Source and Target). Each section is split into two vertically-aligned panes.

    The left pane of Source section displays a hierarchical view of Data Source objects or containers in a tree-like structure. A container is a Data Source object that can hold other Data Source objects, including other containers.

    For example, the "CarsExmpl.xls" displayed above is a container that holds the Table folders and the properties folder. Data Source is at the root of the tree.

    The right pane of Source section displays the contents of the container that is selected in the left pane. The right Target section displays the content of Target – DTD, XSD or XML output. It presents XML output in three interface pages: XML Tree, XML Grid and XML Script. The right pane of Target section gives you ability to browse and edit final XML content in any of these three windows. The left pane of Target section shows you a Schema of your final XML output. You can change the appearance of panes in the Options dialog.

    In the right Target section after converting you can review and edit destination XML document. XML Converter Script editor has the same editing features like most of contemporary text editors have. On the Edit menu bar you can choose any options to edit final XML content. Converter allows you to instantly validate your edited XML content.

    Also, you can extract your final XML output data or convert it according to specified rules by using Crystal Software Australia TextPipe tool. Go: Add-Ins – TextPipe. TextPipe is a multi-file text transformation workbench. You have to have the TextPipe installed on your computer. Go the link to open TextPipe web page for more information.

    The software enables you to resize each of four panes by using special splitters on edge of every pane. When you pass the mouse pointer over the internal vertical edge of pane, the cursor changes to indicate that the chosen pane can be resized.



    Main dialog toolbar

    The main dialog toolbar is intended for manipulation and it provides you with graphic buttons for common commands.

    Open – open existing Data Source file (MS Office: mdb, xsl, doc, or txt)

    Open DB – open Source Database (Oracle or SQL Server)

    Save – save Target file (XML, XSD, or DTD)

    DTD – create DTD(document type definition)

    XSD – create XSD(XML Schema Definition)

    XML – create XML document

    * IE – button for express view your generated XML document using MS Internet Explorer.



    Explore the Data Source

    The Data Source is a collection of all the objects in a database. XML Converter displays a Data Source as a hierarchy of containers and their contents. This section describes how to view the schema of a Data Source.

    Expanding a Data Source container

    Just as in the Windows Explorer, there are a variety of methods for viewing the objects in your Data Source, including the following:

    Click a container in the left pane to select that container. The middle pane then displays the contents of the selected container.

    Click once on the plus or minus icon next to a container in the left pane. This action expands or collapses the container. If no plus or minus icons appear next to a container, it means that the container holds no objects extending beyond the level of that container.

    Double-click a container. This action expands the tree in the left pane and displays the contents of the container in the right pane.

    The left pane displays container objects only. The middle pane displays the contents of the Table object selected in the left pane. For example, when you select some table’s folder in the left pane, all data within that table is displayed in the middle pane.

    Viewing the tables in a Data Source

    The following illustrates the steps taken to examine the contents of a table folder in a database container.

    To examine the tables in the sample database:

    Open Data Source by using "Open" button on tool bar. Root element will be expanded.

    Each table in tree is itself a container. Select a table in the left pane to reveal the contents of that table in the middle pane. Each table object contains folders for columns and properties.

    Expand the table object in the left pane to reveal its contents in the hierarchical tree. Select each object in the table container. You will be able to see the contents of that object.

    View the data in the database

    In addition to viewing the Data Source tree, you can view the data in the database tables from XML Converter.

    To view the contents of database tables:

    In the left pane, click the contact table. In the middle pane the data in the table is displayed.

    Converting features

    On the left of each table you see checkbox. If you select/deselect these checkboxes you may turn on/off some particular table for including it to transformation process. You may include more than one table to a group of tables, which will be converted. By clicking first database checkbox you can select all tables. In this case when you have selected all of them you can convert data from all tables to one common XML output.



    Connecting to a Database

    You can connect directly to a Database to obtain some XML outputs. The "Connect to Database" dialog box is used to connect to ODBC data source, an Oracle database server, MS SQL Server, or to MySQL. You can display the Connect to Database dialog box by selecting the "Connect to Database" item from the "File" menu or just push "Ctrl+F2" keys. You can also access the dialog box by selecting the "Connect to Database" button in the Main dialog toolbar and left-mouse clicking to call the dialog.
    User Name: Specifies user's name for connecting to the database.
    Password: Specifies user's password for connecting to the database.
    Database: Network service name, such as MY_DATABASE, for the database to which you are connecting. The connect strings for the service names must be set up correctly. Otherwise, the connection provider used by the XML Converter is not able to locate the database.

    Check the "Save connection Info" option to store the connection settings as the preferred settings to be used when connecting to this database next time when you will use XML Converter again. You can set up "Save connection Info" to connect to a database without entering login information.


    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.

    ODBC is a programming interface (API) to access local and remote database management systems. ODBC is a de facto industry standard and works on many different operating systems and programming languages. It shields programmers from the complexity of different databases and the communications software used to access the data. ODBC defines an object called a "data source" that is referenced by name and maps its name to the exact location of data (network software, server name, database name, and user information if needed).

    You want to convert a data located in some data source to XML format. If you suppose to make an ODBC connection in XML Converter you must first setup an ODBC data source (DSN). Use the name of the data source (DSN) as the database name in the XML Converter "Connect to Database" dialog. The other useful fields for ODBC are user name and password. The host and port field is not used for ODBC.

    By clicking on "ODBC Administrator" button you may access ODBC Data Source Administrator. This control comprises the main interface of the ODBC Driver Manager. The ODBC Driver Manager lists the ODBC drivers installed for different DBMSes. You can add new drivers, remove or configure existing ones within this control. The XML Converter "Connect to Database" dialog automatically adds a configured DSN in the DSNs list.

    XML Converter allows you insert some specific table name for conversion. Also instead inserting name of a table you can insert SQL select statement which will be used to output data to a query.

    If you chose to later to use another database for XML conversion, you will only have to select a different data source (DSN) and XML Converter will run the same through the ODBC interface.


    Oracle Table Data editing

    You can open and browse some Oracle database objects. The types of database objects that XML Converter supports for an Oracle database are:

    Properties
    Tables
    Synonyms
    Views
    Stored Procedures
    Functions
    Packages
    Triggers


    XML Converter for Oracle now has Table Data Editing features, which allows you to view, update, and delete the contents of a table. To view table data, simply left-mouse click a table in the tree view and just start to edit table data content.
    In the Table Data Editing mode, you can perform the following tasks:
    View a table you have selected as rows and columns in a datagrid.
    Update fields, and insert and delete rows in the table.
    Make multiple changes, which will be applied to Oracle database at once.
    User can edit and format memo field values (LONG data type) in a special text editing window.



    XML Transformation Scenario

    Multidimensional XML representation

    In order to present your data (Excel file, Access database etc.) to the user in an attractive way in browser, mobile phone or PDF format, the original data must first be converted to the necessary XML formats. XML documents and data can be available in almost any structure whatsoever. Everyone can define his or her own XML document structure and describe it. However, a standard database table (Excel spreadsheet, Oracle table/view) is a plane, two-dimensional representation of data content. When you convert your data source table to XML format you get a plane column-row shaped XML output.

    What to do if you need to get an especially structured XML file from your Excel source (or from other data storage)? How to create an XML with your particular multi-level tagged tree structure from your specially formatted data source?

    We would first like to present a simple example showing the XML format, which XML Converter generates from an Excel source. The example is based on the document shown in Figure 2. It is an XML document consisting of the elements Cars and, in it, Car, Details and Detail. Top level of XML source tree is 'Sheet1'. It presents every 'Corporation'. The 'CARS' tag is a direct parent of elements such as 'Car', 'Details' and 'Detail'. You can see an Excel data source spreadsheet on figure 1, which is converted to the shown XML output. Also you can see this readable XML presentation, which is accompanied with an XSL stylesheet.

    Figure 1. A specially structured Excel data source spreadsheet


    XML Conversion Scenario

    XML Transformation Scenario is designed for transforming any data source content into a multidimensional XML documents by using XML Converter. It is a part of interface of the conversion software. This XML Converter feature provides capabilities to design and edit XML Transformation Scenario for your final structured XML document, which you get by transforming some data source. The XML Converter creates a generic template-scenario of a document. This interface provides capabilities to create an XML document template-scenario based on a specific data source content. Contents can be saved as an XML document with embedded XSD.

    The XML Converter lets you create and define a template scenario for an XML document as a structured tree. This conversion scenario forms the basis for creating and editing an XML output according to the criteria defined for each data source column in the template scenario. The scenario consists of structured tags tree that is invariant and, columns and complex data representation that define the content of a final XML document.

    The tags tree is made up in convenient data grid form. In a scenario background you will need to identify Tag Level of each data column, Tag Names, Sub Tag Names, Group Rows Names as a complex data representation to define structure of an XML document. See figure 3.

    The XML Converter lets you create complex representation by grouping columns as a node-structured tree. The XML Converter uses a predefined template scenario to create structured XML content according to the template definition. The content can then be stored as XML. The XML Converter can also be used to create an XML DTD or XSD Schema for the document.

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    <table name="Sheet1">
    <Sheet1>
    <Number1>1</Number1>
    <Corporation2>CHRYSLER</Corporation2>
    <CARS>
    <Car>
    <Car_Name3>ARIES </Car_Name3>
    <Year4>88 </Year4>
    <Color5>Blue </Color5>
    <DETAILS>
    <Detail>
    <Model6>Basic </Model6>
    <Price7>1000000 </Price7>
    </Detail>
    <Detail>
    <Model6>AA </Model6>
    <Price7>2000000 </Price7>
    </Detail>
    <Detail>
    <Model6>BB </Model6>
    <Price7>30000 </Price7>
    </Detail>
    </DETAILS>
    </Car>
    <Car>
    <Car_Name3>DIPLOMAT </Car_Name3>
    <Year4>89 </Year4>
    <Color5>Red </Color5>
    <DETAILS>
    <Detail>
    <Model6>Basic </Model6>
    <Price7>1000000 </Price7>
    </Detail>
    <Detail>
    <Model6>BB </Model6>
    <Price7>1500000 </Price7>
    </Detail>
    </DETAILS>
    </Car>
    <Car>
    <Car_Name3>CARDOBA </Car_Name3>
    <Year4>92 </Year4>
    <Color5>Mist </Color5>
    <DETAILS>
    <Detail>
    <Model6>Basic </Model6>
    <Price7>100000 </Price7>
    </Detail>
    <Detail>
    <Model6>AA </Model6>
    <Price7>200000 </Price7>
    </Detail>
    </DETAILS>
    </Car>
    </CARS>
    </Sheet1>
    </table>


    Figure 2. Final XML output


    Prefixes and Suffixes

    Sometimes users want to include XML output's columns values in specified char combinations. For example, some of fields in user's spreadsheet need to be set in a CDATA tag. XML Converter allows you to specify one attribute as being of type CDATA and have it apply to all instances of that element in the XML. For this case Scenario interface has two fields: "Prefix" and "Suffix".

    Example
    There is the structure of a sample Excel sheet with four columns here:

    LastName
    FirstName
    City
    Detail

    What we probably need to happen is that for every record in the XML, the "Detail" attribute will be enclosed with a CDATA tag because its likely to contain HTML and other markups in it and it will be used by the Flash, which wants to see that kind of data in a CDATA tag. This is what we may get first by using XML Converter:

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    <Playerlist>
    <Player>
    <LastName DataType="String">Daniels</LastName>
    <FirstName DataType="String">Chris</FirstName>
    <City DataType="String">Chicago</City>
    <Detail DataType="String">He is the bomb. I love it</Detail>
    </Player>
    <Player>
    <LastName DataType="String">Willard</LastName>
    <FirstName DataType="String">Fred</FirstName>
    <City DataType="String">St. Louis</City>
    <Detail DataType="String">Funny guy</Detail>
    </Player>
    <Player>
    <LastName DataType="String">Nutx</LastName>
    <FirstName DataType="String">Deez</FirstName>
    <City DataType="String">Akron</City>
    <Detail DataType="String">This is where its at</Detail>
    </Player>
    </Playerlist>



    In Scenario interface for "Prefix" field we insert "<![CDATA[" and for "Suffix" - "]]>" strings. After reconverting we can get the following XML output:

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    <Playerlist>
    <Player>
    <LastName DataType="String">Daniels</LastName>
    <FirstName DataType="String">Chris</FirstName>
    <City DataType="String">Chicago</City>
    <Detail DataType="String"><![CDATA[He is the bomb. I love it]]></Detail>
    </Player>
    <Player>
    <LastName DataType="String">Willard</LastName>
    <FirstName DataType="String">Fred</FirstName>
    <City DataType="String">St. Louis</City>
    <Detail DataType="String"><![CDATA[Funny guy]]></Detail>
    </Player>
    <Player>
    <LastName DataType="String">Nutx</LastName>
    <FirstName DataType="String">Deez</FirstName>
    <City DataType="String">Akron</City>
    <Detail DataType="String"><![CDATA[This is where its at]]></Detail>
    </Player>
    </Playerlist>



    Scenario Interface

    XML Converter gives you ability to adjust and save a transformation template scenario for each converted table(spreadsheet). Once you set this template scenario for your particular data source next time you will be able to reuse your previous stored setting. How to generate a Scenario for a specially structured Excel data source by using the Converter? Our example is based on shown above Excel spreadsheet and its final XML output. Please follow the several steps:

    Figure 3. XML Transformation Scenario Interface


    1. On the "Options" form select "Use predefined XML Transformation Scenario" checkbox.

    2. Try to create some XML output from your data source. During the creation a special "XML Transformation Scenario" shown above interface window will appear. By using this interface you will adjust and save a transformation template-scenario for each converted table.

    3. First you will get a template for a plain table. In column 'Level' all table fields will have the same first level '>'. Values for columns 'Column Name' and 'Tag Name' will be equal. You may give new values for 'Tag Name' for every table column of your data source. During the subsequent transformation all XML tag names will be replaced with these new values.

    4. By clicking on 'Level' column buttons for each table column you will be able generate a tree structure for your XML output. When you increase a tag level you will need to insert a name for this new tag to 'Sub Tag Name' field. Every change you make in data grid will be reflected in 'XML Structure view' window, where you can see an XML final structure representation.

    5. 'RowFlag' column helps you to identify what table columns must be included to 'rows'. What do I mean when say 'rows'? Take a look at figure 1. For one Car we have several Models, which are presented as separated rows in data source. All these rows are 'Detail' tags in our final XML. All of these rows belong to 'DETAILS' tag, which is a direct parent of these elements.

    6. To combine all rows under the same structure level you will need to give a name for this group of rows in 'Rows Tag Name' column.

    7. If you need you can insert particular char strings into "Prefix" and "Suffix" fields.


    Only one rule. To get an XML output with a structure, which you need, your data source has to look like the sample Excel spreadsheet shown above on figure 1. By using XML Transformation Scenario interface you let know to XML Converter what a structure you would like to provide for a generated XML.




    Store Oracle/MS SQL Server/MySQL query results as an XML output

    XML Converter provides a completely graphical user-friendly environment which will help you visually transform Oracle (MS SQL Server, MySQL) tables or/and views to XML format. You will be able browse view result in data grid and convert to XML document. Using XML Converter you can query an Oracle/MS SQL Server/MySQL tables and return results as XML outputs. In XML Converter user interface you can create and replace a view, this view will contain the results of the query.

    By clicking right mouse button on the database tree (left pane) XML Converter allows you to create new view. Then you will need to insert a SQL script for your query. In middle pane "Script" tab you may write something like the following:

    SELECT * FROM MY_TABLE

    and then save your new view.

    Then you could select "Data" tab button and browse data grid to move through the query result. You can now query created view as if it were a single database table.

    Also you may overwrite the previous view. Go back to "Script" section of middle pane and rewrite your query, change something in query script. For example, you may change your query SQL script:

    SELECT * FROM MY_TABLE ORDER BY YEAR

    Click "Save" button and go back to "Data". Your view will be replaced and corresponding query result will be recreated.

    To start data transformation just click "XML" button on main XML Converter toolbar.
    After reviewing or editing your destination XML output in a special window (right pane) you can save the XML file by using "Save" dialog box.

    Main Features of XML Converter related to Oracle database are:
    1. Supports Generation of XML documents from Oracle tables and/or views.
    2. Supports in XML Converter GUI inserts, updates, and deletes of database records. Update data directly to Oracle database. These updates are corresponding to a given XML document.
    3. Supports general Oracle data types.
    4. Create and update Oracle views. By using XML Converter you can create a view in your Oracle database, browse query result, update the view and store it.
    5. Supports dynamic generation of Document Type Definition (DTD) or XML Schema Definition (XSD) while retrieving an XML document from the database.
    6. Supports simple transformation of the retrieved XML document using XML Stylesheets (XSL).


    XML Converter for MySQL database
    MySQL has no native facilities for dealing with XML. This does not mean we are left out of the XML evolution. Rustemsoft XML Converter has ‘MySQL to XML’ support. This software provides a natural bridge for spanning the gap between XML and the relational 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.


    The following XML Converter possibilities are open to you for employing XML processing techniques to make more productive use of your MySQL server:
    1. Supports Generation of XML documents from MySQL tables and/or views. Writing a query result as an XML document results in a platform-neutral ASCII file that can be used by other applications, even those that are not necessarily database-oriented.
    2. Supports general MySQL data types.
    3. Create and update MySQL views. By using XML Converter you can create a view for your MySQL database, browse query result, update the view and store it.
    4. Supports dynamic generation of Document Type Definition (DTD) or XML Schema Definition (XSD) while retrieving an XML document from the database.
    5. Supports simple transformation of the retrieved XML document using XML Stylesheets (XSL).



    XML tags Setup

    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.

    "Rid a single table of database tags" check box
    Your data source contents a single table only and you do not need "database" tag as a root element. For this case the checkbox "Rid a single table of database tags" should be checked. If you check the checkbox your final XML output will be free from "database" tags. There will be 3 tag levels in your XML document instead 4. "Table" tag will become a root element.



    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 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. For 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.

    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?"

    Also you can select option "Fast converting mode for Excel workbooks". Excel sheets will be transformed much faster. But this way is good if you have homogeneous data for each excel sheet column. If you have deferent data types in one column (numbers, date or text) please do not check this box.
    To designate the maximum width (in characters) of the text field you should enter an appropriate value in the "Width of Word document or text file in characters" box.
    Converter also supports any delimited data source file (tab-delimited text file, *.csv etc). By checking "Delimited source" option on the "Options" form you let know Converter that data source is a delimited file. Symbol-delimiter is adjustable in a special textbox. You can specify not only one symbol for your source delimitation. Delimiter can be a combination of some chars. For a tab-delimited text file just insert "Tab" in the textbox.

    The Rustemsoft XML Converter can support non-Latin characters in XML by accepting the UTF-8 and UTF-16 encodings. People around the world can easily use it. By playing on "Unicode UTF-8 encoding" section you can adjust non-Latin characters view in your final XML.

    "Encode special Low ASCII chars with HTML encoding" - by checking this box you can be able to convert some chars in your final XML. Some XML parsers need low ASCII symbols be encoded in HTML presentation. For example, ' char (apostrophe) in an XML content should have the view: &apos;

    By clicking "XSL Setup" button you may call a special interface for adjusting an appearance view of your XML file along with an XSL style sheet. You can change the XSL style to what you wanted.


    Table (borders) section
    Our final XML output is exactly a table. As far as it is a table on screen it may contain borders, which are drawn around all table cells. If absent, there are no borders, but by default space is left for borders, so the same table with and without the border attribute will have the same width.

    There is description of "Table (borders)" section's parameters here:
    Back Table color - Specifies a background color for the entire table.
    Border Width - Specifies the width (in pixels) of the border around the table and its cells. Set it to 0 to turn the borders off completely.
    Border color - Specifies the color of the main center portion of a table border.
    Border color light - Specifies the color of the light shade used to render 3-D-looking table borders.
    Border color dark - Specifies the color of the dark shade used to render 3-D-looking table borders.
    Cell Padding - Sets the amount of space, in number of pixels, between the cell border and its contents. The default value is 1.
    Cell Spacing - Sets the amount of space (in number of pixels) between table cells. The default: 2.


    Convert source data to Oracle database
    Do you need to convert relational data loaded into your data source (MS Excel workbook, MS Access database, MS Word document) into a custom Oracle database? XML Converter can be used as a middleware to resolve these conversion needs. This is accomplished by using a TransX Oracle utility that serves the purpose of filling the Oracle database with data from a specially prepared XML document. An XML view of the data source (created by converting the data source using Rustemsoft XML Converter) is then transformed using the Oracle utility into an Oracle database.

    Also XML Converter gives you ability to adjust and save a transformation table-schema for each converted table. Once you set this schema for a particular data source next time you will be able to reuse your previous stored setting. How to generate specially for the TransX utility prepared XML file by using the Converter?
    Please follow the several steps:


    1. On the "Options" form select "XML with TransX schema".
    2. Check "Use TransX table settings".
    3. Go to XML tags setup interface and choose from drop-down "Choose an XML Tags Setup Schema:" combobox "TransX tags schema" set.
    4. Try to create some XML output from your data source. During the creation a special "Table Settings for TransX Schema" interface window will appear. By using this interface you will adjust and save a transformation table-schema for each converted table.


    Micros special conversion modules

    If you have a task to create an extraordinary XML from you data source, using the Micros feature can save countless hours of work. If you have need of a specially structured XML output and you want to perform a conversion task repeatedly in RS XML Converter, you can automate the task with a micro. A micro is any executable (.exe) program which contents a series of commands and functions that are stored on your hard drive and can be run whenever you need to perform the task.
    For example, if you need to convert your sales order excel file in XML format, you can create a micro to automate the transformation to get your unparalleled, singularly tagged XML file.

    Making a micro easy to run
    You can run a micro by choosing it from a list in the Micros dialog box. To make a micro run whenever you click the "XML" button to perform your XML data conversion, you can assign the micro by clicking its checkbox in Micros interface. When the source data is imported in the XML by using Micro, you can review the final XML data and change, save target file and copy, delete and add to the output information in XML Converter interface.

    Ordering a micro
    Micro is a special conversion executable module. You should write a program, compile it and then integrate to the XML Converter Micros dialog box interface. If you do not have enough programming expertise to create your own Micro we are glad to help you. Please contact us with your software requirements. We will customize your task.


    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.

    Professional Edition includes modules such as:

    - XML Converter Standard Edition, which includes software with GUI (graphical user interface);
    - An executable module that runs within the console window or DOS-batch command file


    XML Converter Professional Edition executable module has the following command-line interface:

    XMLConverterCmd -s[SourceFileName]
                              -n[SourceTableName/or Number]
                              -g[TargetTypeName]
                              -t[TargetFileName]
                              -m[MappingMethod]
                              -w[WritingMethod]
                              -l[NeedXSLtemplate]
                              -h[NeedXLSheader]
                              -r[ShowRegForm]
                              -help
                              -![+|-]


    Command-line arguments

    XMLConverterCmd can accept quite a few command-line arguments. Many of these arguments can be omitted and XMLConverterCmd can use default values instead of them. XMLConverterCmd expects command line arguments to be preceded by the "-" (dash) as normally used by DOS programs. Also you can use a special configuration file default.cfg for defining and sending your parameters to XMLConverterCmd.exe.

    SourceFileName
    A Name of Data Source file with full path like:
    C:/MyDirectory/MyBook.xls

    SourceTableName/or Number
    A Name or a number of spreadsheet or table, which belongs to your Data Source file.
    Default is empty string

    If you decide to define the [SourceTableName/or Number] argument as a number of table/spreadsheet you have to put this parameter after [SourceFileName] arguments. Otherwise, if [SourceTableName/or Number] argument is name of table/spreadsheet and contents spaces inside you must enclose it in "[ ]" brackets:

    XMLConverterCmd.exe -rXLS -sC:\\MyDir\\MyBook.xls -n[First sheet 10] ...

    Also you can leave this argument empty. It means XML Converter will generate one common xml output file where data from all of your Data Source's spreadsheets/tables will be stored. In this case you can create your own XML database. This software gives you ability to generate an output as a set of XML tables.

    TargetTypeName
    A Name of Data Target Type
    Values:
    dtd
    xsd
    xmlDefault is xml

    TargetFileName
    A Name of Data Target file with full path like:
    C:/MyDirectory/MyBook.xml
    Default is SourceFileName with the extension, which you define at TargetTypeName argument (".dtd", ".xsd" or ".xml")

    MappingMethod
    The Mapping method determines how each Source data column is mapped when a XML document is saved. This argument should be omitted when TargetTypeName is not xml.
    Values:
    e - Map out as Element
    a - Map out as Attribute
    r - Map out as Row ContentDefault is e

    WritingMethod
    XML writing method specifies how the XML output file is to be written. This argument should be omitted when TargetTypeName is not xml.
    Values:
    ns - XML without Schema
    ws - XML with Schema
    dg - XML in DiffGram format
    tx - XML with TransX Schema (for Oracle TransX Utility)Default is ns

    NeedXSLtemplate
    Argument is replying to question: "Would you like to accompany your XML document with a template XSL style-sheet?" This argument should be omitted when TargetTypeName is not xml.
    Values:
    yes
    noDefault is no

    NeedXLSheader
    If the first range of your Excel workbook does not contain headers, you can specify this argument as "no".
    Values:
    yes
    noDefault is yes

    ShowRegForm
    If you are not a registered user of the XML Converter with command-line interface yet you can order the software online. After that we will send to you your secure installation code and you will run your software with the parameter:
    XMLConverterCmd.exe -r
    A special registration form will appear where you will be able to legalize your Converter.

    help
    Display the help message (Short form: -?)

    ![+|-]
    Enable/Disable warningsDefault: -

    The XMLConverterCmd.exe returns error codes:
    0 - Ok
    1 - Syntax error in command line
    2 - Source file does not exist
    3 - Source table does not exist
    4 - Can't open source file
    5 - Can't create XML file
    6 - Error of XSL-template creating
    7 - Can't create XSD file
    8 - Error of DTD creating
    9 - Can't connect to data
    10 - Can't read data format
    11 - Error of TrasX-Schema creating
    12 - Error in "micro" - module
    13 - Target file is not created

    Example
    If you want to get one XML file generated from all of "MyBook.xls" spreadsheets you can use the signature:
    XMLConverterCmd.exe -sC:\\MyDir\\MyBook.xls –n
    For this case final "MyBook.xml" file will be saved in directory "C:\MyDir\" and will content data from all spreadsheets. Also, this file will have special tags, such as "workbook", "worksheet", "row", "field column=""", which allow you to directly access and read the XML file by using DOM or SAX software.

    Also XMLConverterCmd supports ErrorLevel DOS variable. When using a dos batch file to execute XMLConverterCmd.exe, how do you go about error handling? There is the ErrorLevel variable being passed back to the batch file that can be interrogated to determine successful/unsuccessful completion of XML Converter Cmd. To try the functionality you should have a .bat file like the following:

    @Echo Off
    XMLConverterCmd.exe
    goto %errorlevel%
    :0
    echo Ok
    goto end
    :1
    echo Syntax error in command line
    goto end
    :2
    echo Source file does not exist
    goto end
    :end

    XMLConverterCMD.err file
    When XMLConverterCmd.exe interrupts its execution the special file XMLConverterCmd.err will be created where error reports are stored. This error message file contains both error numbers and their associated text messages. The error report is accompanied by the date and time when it occurred. Since the error message file created with XMLConverterCmd is a binary text file it can be accessed by any text editor.


    Configuration file default.cfg

    You can put all of command-line arguments to the special configuration file "default.cfg". This file has a following definition rule: ARGUMENT = VALUE

    List of all arguments:

    SourceFileName (-s option in command string) - A Name of Data Source file with full path
    (Example: SourceFileName=D:\Books\CarsExmpl.xls )

    SourceTblName_Num (-n option in command string) - Name or a number of spreadsheet or table, which belongs to your Data Source file
    (Example1: SourceTblName_Num=Sheet number one )
    (Example2: SourceTblName_Num=2 )

    TargetTypeName (-g option in command string) - A Name of Data Target Type. Values: dtd, xsd, Xml
    (Example: TargetTypeName=xml )

    TargetFileName (-t option in command string) - A Name of Data Target file with full path
    (Example: TargetFileName=C:/MyDirectory/MyBook.xml)

    MappingMethod (-m option in command string) - Values: e - Map out as Element, a - Map out as Attribute, r - Map out as Row Content
    (Example: MappingMethod=E)

    WritingMethod (-w option in command string) - WritingMethod. Values: ns - XML without Schema , ws - XML with Schema, dg - XML in DiffGram format, tx - XML with TransX Schema (for Oracle TransX Utility)
    (Example: WritingMethod=NS)

    NeedXSLtemplate (-l option in command string) - Values: yes, no
    (Example: NeedXSLtemplate=yes)

    NeedXLSheader (-h option in command string) - Values: yes, no
    (Example: NeedXLSheader=no)

    The following arguments can be definited at default.cfg file only:
    FastXls - Fast converting mode for Excel workbooks. Values: yes, no.
    If you have chosen Yes MS Excel sheets will be transformed much faster. But this way is good if you have homogeneous data for each excel sheet column. If you have deferent data types in one column (numbers, date or text) please use No value.
    (Example: FastXls=YES)

    WordWdth - Width of Word document or text file in characters
    (Example: WordWdth=80)

    NeedLogo - If you run XML Converter with empty command string and NeedLogo=YES you will see the short information about this program. Values: yes, no.
    (Example: NeedLogo=NO)

    NeedProgresBar - If you do not want to see a progres bar please define the argument as NO. Values: yes, no.
    (Example: NeedProgresBar=NO)

    EncodeLow - Some XML parsers need low ASCII symbols be encoded in HTML presentation. For example, ' char (apostrophe) in an XML content should have the view: &apos; Values: yes, no.
    (Example: EncodeLow=NO)

    Within the default.cfg file you may begin your comments with ' or " as a first symbol of string. Example:
    " Width of Word document or text file in characters
    WordWdth=120

    If you define arguments in command-line then their values will have a high priority than the values have been defined in default.cfg.
    In other words, if you have in default.cfg a string:
    SourceFileName=D:\Books\Book1.xls
    And then you insert to command-line:
    -sD:\Books\Book2.xls
    For this case XMLConverterCmd.exe will convert Book2.xls file, which you have put to command-line.


    Startup Options configuration interface

    Besides using the configuration file default.cfg you can use a special interface for defining and sending your parameters to XMLConverterCmd.exe. It has the same options and arguments like the Standard Edition interfaces. To provide you this interface Rustemsoft developed a special Options.exe. You can run the executable file Options.exe before working with XMLConverterCmd.exe.


    Copyright © 2001-2003 Rustemsoft. All rights reserved.