File Format Convert

File Format Convert is not available from the LoggerNet toolbar. It can be opened from the Window’s Start menu.

File Format Convert is used to convert data files from one format to another. It can also perform the following functions:

• Break large files into smaller files (also known as baling).

• Check for missing records by checking the record number and or timestamp.

• Bale based on time

• Bale based on File Marks and Remove Marks (TOB2,TOB3 files)

• Bale files when missing records are discovered.

• Fill in missing records with ‘Null’ or empty records.

More than one of the above functions can be performed in one pass.

In general files can be converted from:

• TOA5

• TOACI1

• TOB2

• TOB3

• TOB1

• CSIXML

To:

• TOA5

• TOACI1

• TOB1

• CSIXML

• CSV

NOTE: File Format Convert cannot produce TOB2 or TOB3 files, and it cannot read CSV files.

NOTE: Some file headers have less information than other formats. If you convert from a file with more information in the header to one with less, information will be lost. If you convert from a format with less information, some fields will be left blank.

NOTE: Some formats (e.g. TOB1) store string in fixed length fields and have headers that specify how big that field is. Other formats use variable length strings. If you convert from a format that uses variable lengths to a fixed length, the length is assigned to 64. If the string is longer than this, it is truncated.

Converting a File

Press the Open button to browse to a file to be converted. After a file is selected, press the Options button and set up the options for the conversion. Then press the Convert/Check button to convert the file.

If a conversion is in progress and you wish to stop it, press the Abort button.

Log File

If the Write Log File check box is checked, a “Log.Txt” file will be created in the same directory as the source data file. The log.txt file will be overwritten if it exists.