|
XMLFox Professional XML Editor
|
|
|
XMLFox Professional Edition is the complete solution for the developer who wants the browse facilities provided in the XMLFox Advance PLUS special module, which provide command-line interface. Using the Professional Edition you will be able to call XML conversion process strictly from your own application, with no user interface, allowing you to convert an XML file into another data format in batch mode.
|
What the special modules are included in Professional Edition?
|
|
XMLFox Professional Edition executable module has the following command-line interface:
|
-SOURCE=[Path+FileName] | Source XML file Name with full path |
-OUTPUT=[Path+FileName] | Target file Name with full path |
-TYPE=[Number] | Conversion type. |
| 0 - convert into Text file |
| 1 - convert into Excel file |
| 2 - convert into CSV file |
| 3 - convert into HTML file |
| 4 - convert into MS Access mdb file |
| 5 - convert into SQL Server database |
-MSACCESSTYPE=[Number] | MS Access DB type to be created. |
| 95 - MS Access 95 |
| 97 - MS Access 97 |
| 00 - MS Access 2000 |
| 03 - MS Access 2003 |
-USERID | User ID for MS SQL Server database connection |
-PASSWORD | Password for MS SQL Server database connection |
-DATASOURCE | Data Source for MS SQL Server database connection |
-INITIALCATALOG | Initial Catalog for MS SQL Server DB connection |
-EXTPROPERTIES | Extended Properties for MS SQL Server connection |
-HIDE | Hide the console window when process runs |
-WRITELOG | Write Log file with info about conversion process |
-? | Display this usage message |
Option key is '-', options are recognized by a first character |
Examples |
Convert XML into Excel file: |
XMLFoxCmd -s=C:/MyDir/My.xml -o=C:/Dir_New/MyExcelFile.xls -t=1 -h -w |
Upload XML into MS SQL Server Database: |
XMLFoxCmd -s=C:/MyDir/My.xml -u=MyID -p=Psw -d=SQLHost -i=MyDBase -t=5 -h -w |
XMLFox Advance XML/XSD editor tool is a sequel of the well-known world-leading XMLFox freeware XML/XSD Editor. Like its precursor, the XMLFox Advance has the same user-friendly interface. XMLFox Advance is an advanced XMLFox XML/XSD Editor with the following new attractive features:
|
|
The Table Design Interface allows you to modify an existing table structure in your XML or create a new one. You can invoke the Table Design Interface by clicking on the drop-down Grid toolbar button when a table is selected.
If you would like to save your updates that you made for tables structures you need to assign the XSD schema inside your XML first. The table structures will be stored in the XSD schema within your XML for further using. For this case the Table Design interface has the special "Assign XSD to XML now" button that allows you to do that.
|
|
|
|
The XMLFox Advance Filter interface helps you to display only those records in an XML table that match one or more criteria. For example, you want to see the products whose price is equal $50. Instead of opening the whole table in Grid view and scanning the entire list, you can apply a filter.
You can specify multiple criteria in a single filter. You can also apply a filter that is based on multiple columns.
|
|
The XMLFox Advance allows you to browse the Relationships between tables in XML.
XMLFox Advance considers any XML file as a relational database. Since the XML is a database it has tables that are related to each other somehow. One of the strengths of a relational database is the ability to relate or associate information about various items in the database.
The XMLFox Advance provides the possibility to add/update/delete XML tables by using the Relationships interface.
|
|
In XMLFox Advance you can output data to several other data format files. The Editor allows you export XML tables or whole XML to the following data files: TXT; convert into CSV (Comma Separated Value) file, convert into HTML page, create MS Access database, convert into MS SQL Server database, convert XML in to PDF, and create Excel file.
When you export XML you have the following two options:
1. "Convert the current XML table only" that allows you export selected XML table.
2. "Export whole XML according to its structure"
|
It allows map XML to another formats transformation
The exclusion of fields and the reordering of fields make your XML file transformation much flexible. Also other "XML to" transformations such as filtering can be performed through "Better Grid View" interface that allows for intricate mapping and transformation without the need for user written code. Please learn more about XML conversion mapping.
|
XSL designer interface.
Besides editing and validating an XML document the XMLFox Advance allows 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.
|
|
|