TextConverter by SiMX‎ > ‎User Interface‎ > ‎Output‎ > ‎

Output Dictionary

The output dictionary editor defines the output database (or file) table structure.  If your table (or file) does not exist the output dictionary will be used to create it.  The output dictionary editor is available in both TextConverter and Target Reports (see the data source tab).  For TextConverter, a detailed exercise in using the output dictionary to connect input data to output fields is shown in Step 6. Edit field map of the samples and walkthroughs.  Also, changes made to the output dictionary in TextConverter are immediately reflected in the output preview. Clicking the blue pencil on the right side of the pane will show or hide the output dictionary toolbar. The following tasks can be completed in the output dictionary:

Clear database table connection - By clicking this button, the user disconnects all the outputs from their input fields.

Set output table name - This button brings up a screen that allows users to name the output database or file.  Follow this link for the dialog the appears when you click this icon.

Browse output database table - This button becomes active after running the conversion. Users the Data Browser to browse the resulting data.

Clear the field list - Clears all the output dictionary's fields.

Open a dictionary from file and Import dictionary from database table - Open an existing dictionary from a file (.dict) or from a database table (.xls, .txt, .csv, .dbf, .mdb, .accdb).

Save dictionary to a file - Saves the dictionary as a back up or for use with another TextConverter project file. The output dictionary automatically saves to the project file, so this only needs to be used when a separate or back up dictionary is required.

Create new field - By selecting the line below the last listed field and clicking the outlined space in the "Output field" column, the user is able to type the name for a new field.

Filter output type - Clicking the "Filters" drop-down menu, the user is able to select from which outputs are displayed in the dictionary.

Create/Go to/ Delete Script Conversion - By clicking "Create Script Conversion," a new field will appear in the output dictionary and the field will be inserted into the "Script" tab of the button left pane. "Go to" finds and highlights the conversion in in the "Script" tab. "Delete" removes the conversion from the both the output dictionary and the script.

Note:  When using VBScript, you can refer to an output field by its name or its position (number).  If using TextConverter to make a file, or if referencing fields by their number in the script, changing the field order requires a change in the script's field number. Otherwise, the function will affect whatever field is in the referenced position. If referencing fields by name, the fields can be re-ordered without affecting the script.

Reset the output dictionary - This option is also found in the fly-menu when right clicking in the Output pane. Click this to revert the dictionary to its default output fields.

Field Properties - Select a field and the field properties appear in the lower half of the output dictionary pane.  Each of the field properties are listed below.

ID Name - the true name of the field

Name - normally this is the same as ID Name but you can change this for reference purposes without effecting the project

Type - the data type, that is, string, numeric, date, etc.

Width - the field size.  Options shown are related to the type.

Comment - type a comment here for reference, it will not effect the data processing project

Format - the viewing format for the preview, this will be inherited by the data browser when you view data in the data browser

Field Attributes - advanced field attributes related to the data source connected, for example, Can be Null, Unique, Auto Unique, Primary Key, Current Date

Using TextConverter to add records to an existing database - If you are Using TextConverter to append an existing database table, the output dictionary must match the output data source in number of fields and the length and type for each field but it is not necessary to connect all of the output fields to input fields.  If there are fewer fields in the input dictionary, simply connect the fields that are available to the corresponding output fields and leave the other output fields without connection.

An easy way to reset your output dictionary to match your output data source (the database table), is to:

1. clear the field list for the Output Dictionary

2. click the set output table name icon

3. Browse to the data source and click the set button.
Since you are appending a table that already contains data, check the box in the options pane of the main UI Append to Existing Table.

Parsing with script - The output dictionary (and input dictionary) can be used for parsing with script.  The following functions are available:

DictIn.GetFieldCount( )

DictIn.GetFieldValue( index|name )

DictOut.GetFieldCount( )

DictOut.GetFieldValue( index|name )

DictOut.SetFieldValue index|name, value

Related Sections

TextConverter's Concept

TextConverter's User Interface

Working with Templates

Parsing with Script

Setting up a conversion: Step-by-Step

Samples and walkthroughs