FREE conversion setup with product trial Let us solve your data extraction/conversion problem:  1. Submit a sample of your input text file and ... 2. Receive a configured TextConverter project in a few hours (reasonable complexity sample projects with comprehensive specification)

Videos

 

Extract CSV, TXT, LOG, DOT QIF, OFX, XML, GPX, Legacy Extracts, etc.

Transform Auto Data Type Detection Formatting, Script-based manipulations. etc.

Load MS SQL Server, ORACLE MySQL, Access, DB2, dBase, CSV, Excel, etc.

Overview

The main features include:

• Visual data mapping

• Visual support for accessing multiple data sources

• Automatic data type detection

• Automatic delimiter suggestions

• Arbitrary fixed and programmable record and field delimiters

• VB Script support for data transformation

• Data extraction supporting objects

• Dynamic output sample

Developer Edition

• Programming automation: redistributable runtime component controllable through its API

• Royalty-free redistribution of the runtime TextConverter component as part of your applications.

The market offers a variety of text import/conversion tools, which can be generally divided into two groups: dialog-based and programming tools. The dialog-based tools do not require programming skills, but have complicated user interfaces with limited functional flexibility. The programming tools, on the other hand, have virtually unlimited flexibility, but require expensive programming expertise and are time-consuming.

TextConverter offers the best of both worlds: a dialog-based interface with high-level scripting capabilities.

Conversion Process

Step 1. Extraction - data is extracted from the Source Text into an input table with use of field delimiters, record delimiters, and text qualifiers.

Step 2. Transformation: Direct Mapping and Script - a default mapping is automatically created for transformation of the Input Table. A mapping is a set of connections between the fields of the dictionaries associated with the input and output tables. The default mapping can be easily modified by visually connecting and disconnecting input and output fields and through scripting, which can also be used for additional extraction tasks, implementation of business rules, and other logic.

TextConverter leverages the power of VB Script engine, while keeping things simple through use of high-level objects such as the input dictionary, output dictionary, and utility objects.

Step 3. Load - the data is automatically loaded from the output table into the output data source, which can be any database system (SQL Server, ORACLE, MySQL, DB2, MS Access, etc.) as well as in a variety of flat formats including CSV, Excel, FoxPro, DBase, and more.

GUI Workflow Milestones

1. Open the text file you would like to convert by clicking on the Open Data Source button on the Input pane.
2. Set up the delimiters and other extraction properties on the Options pane. The Input Dictionary will be created automatically.
3. Set up the Output Dictionary by editing the dictionary items, loading the Dictionary Object, or importing from other table.
4. Set up direct field mapping (if applicable) by selecting Input-Output fields pairs and clicking Connect/Disconnect Input-Output Fields buttons.
5. Set up script conversion (if applicable) by clicking on the Create/Goto/Delete Script Connection buttons and writing VB Script.
6. Preview results in the Output Table Sample. Use the Options pane to adjust settings and see the results immediately on the sample grid.
7. Set up the Output Table Name by clicking on the appropriate button on the Output pane.
8. Run the conversion process by clicking on the Start Process button.
9. View the final result in the output table viewer by clicking on the Preview Output Table button.

Windows XP/2000/NT/98/Me