Overview

AtlasConvert is a tool for the safe conversion of one database type to another standardised format.

Features

  • Checks file errors (e.g. removes unwanted punctuation in fields).

  • Undertakes checks for record, field and delimiter errors when converting.

  • Allows multiple database processing enabling the consolidation of multiple databases into one centralised and consistent database.

  • Produces reports detailing problems encountered, evaluation of the process run and actions taken.

  • Produces detailed reports on changes made. Handles most standard industry database formats (ODBC).

Benefits

Improves efficiency and effectiveness of business functions by ensuring all database records have the same format.
Reduces the costs of ageing and out-of-date software by safely converting data to newer database formats.
Enables companies to migrate data for new systems.

1. What do the different AtlasConvert Error Types mean?

Data too long - implies that a field within the record highlighted has been truncated in the conversion process as it has too many characters in the field to fit into the output field length defined (fixed length field records only).

Too few fields - this implies that the record concerned has an inconsistent field count in that it has less fields than the norm.

Too many fields - this implies that the record concerned has an inconsistent field count in that it has more fields than the norm.

String delimiter in field - this implies that the record and field highlighted has a single character meant to denote a string value (eg, a ") without a corresponding partner character (eg, another ").

Field delimiter in field - this implies that the delimited text file defined has a field with the delimiter character in it which may cause problems in the definition of fields in later processing.

Record delimiter in field - this implies that there is a record terminator (eg, a carriage return or line feed) embedded in one or more data fields. This, again, could cause issues in later processing if not addressed here.

Remove bad characters - this is a facility which allows the user to define a range of hexadecimal characters they want to see removed from the data being processed. These are typically characters not expected/wanted.

2. What do the different AtlasConvert 'behaviours' mean?

Remove - will remove the character(s) included in the range from the data completely.

Warn - will warn the user of a particular fault being detected and offer a suggested resolution via an interactive correction window when running through the file processing run.

Correct - will automatically correct any anomalies found according to settings defined by the user without requesting interaction from that user.

Ignore - will ignore the error completely (e.g., not report a Data too long error where the user is not concerned about data fields being truncated).

Drop - will drop the record completely where the error associated is encountered in a processing run.

3. Where can I obtain a breakdown of what errors occurred and in which records processed?

Conversion statistics are available through the menu View|Conversion Statistics item. There is also a facility allowing the export of this report into a simple text file (through View|Export Statistics).

4. Further Details

For further details on AtlasConvert and how to best utilise it, please refer to the PDF documentation within the application installation directory. If you have any questions not covered by this document, please contact Hopewiser technical support department on 03 8610 3300.