TextConverter 3.1 - Extract Data Instantly From Any Document

  FREE CONVERSION SETUP with FREE TRIAL

TextConverter 3 dramatically simplifies the process of data extraction/conversion from computer generated documents by identifying the internal document’s structure automatically without programming.

Now with Version 3 you have visual control over automatically generated templates as well as manual templates!  The goal is achieved by employing an artificial intelligence (AI) engine that is capable of recognizing reoccurring patterns of data layout, formatting, and content thus identifying records and fields to be extracted.

In addition to auto mode, high level objects provide full support for conventional script-based data parsing and data transformation so you can focus on your particular data transformation without worrying about looping through records or accessing files or databases.

Try Before You Buy  See TextConverter 3 work with your input data and specifications using our data extraction service, where you can submit your task to us and to receive the completed project files within 24 hours (in most cases).

TextConverter 3 is also a programmable automation component equipped with application programming interfaces (API). It can be integrated into your applications using virtually any programming environment (including scripting engines).

TextConverter 3.1 Standard | $600 Input formats: PDF, DOC, RTF, XLS, HTML, CSV, and Txt files Automatically detects patterns that represent record and field structure Accesses multiple data sources VB Script support with proprietary objects and methods for data transformation Preview the output as you work Output: any OLE DB or ODBC compliant database - ORACLE, SQL Server, MySQL, DB2, Access, or generate files for Excel, FoxPro, and more

TextConverter 3.1 Professional | $1200 Everything in the Standard Edition plus... Access TextConverter's COM and .NET automation objects through the API Automate and schedule tasks through windows scheduler Detailed examples are provided for Java, C#, C++, VBScript, and VB.NET

TextConverter 3.1 Developer | $1500 Everything in the Professional Edition plus... The right to use the TextConverter authoring tool on (or from) a server. The right to install copies of the runtime component on servers within your enterprise*. The runtime component allows you to execute and control configured TextConverter projects on your servers. An easy installer to set up runtime components *Limited to internal use, special agreement, and non-competing platforms as determined by SiMX at its sole discretion.

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)

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, automatic pattern detection, and high-level scripting capabilities.

Extract PDF, XLS, DOC, RTF QIF, OFX, CSV, GPX, Legacy Extracts, etc.

Transform Auto Mode, Detect Tags and Delimiters, VB Script: Split, Combine, Transform, etc.

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

Conversion Process

Step 1. Extract - Automatic extraction uses AI pattern recognition. Manual extraction allows the use of any criteria the user wishes to define through options or script.

Step 2. Transform - a data map automatically connects each input field to each output field. The automatic mapping can be modified by visually connecting and disconnecting input and output fields or through scripting. Scripting can be used for extraction tasks, implementation of business rules, and other logic.

TextConverter leverages the VB Script engine to keep things simple. Powerful and precise conversion of text to useful data is accomplished through use of high-level objects such as the input dictionary, output dictionary, and proprietary utility objects for virtually any transformation task.

Step 3. Load - at run time the data flows from the source, through the transformation process and into the output data table, 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.

User Interface and Workflow Steps

1. Open the text file you would like to convert by clicking on the Open Data Source button. (or drag and drop the input file to the input pane.)
2. Change options like "First Page", "Exclude Lists", and "Trim Spaces" on the Options pane. The Input Dictionary and the Output Dictionary will be created automatically and linked field by field. If applicable...
   1. Make changes to the Output Dictionary by editing the dictionary items, loading the Dictionary Object, or importing from other table(s).
   2. Set up direct field mapping by selecting Input-Output field pairs and clicking Connect/Disconnect Input-Output Fields buttons.
   3. Set up script conversion by selecting Create Script Conversion for any field and writing VB Script.
3. Preview results in the Output Table Sample. Use the Options pane to adjust settings and see the results immediately on the sample grid.
4. Set up the Output Table Name by clicking on the appropriate button on the Output pane.
5. Run the conversion process by clicking on the Start Process button.
6. View the final result in the output table viewer by clicking on the Preview Output Table button.

Works with Microsoft Windows