Running the Database Import Utility

What the utility will do – look below for what it will not do

·        Data can be imported into VDF native or compatible data files by one of three ways with this utility.  In addition, code may be generated that will perform the same functions. 

·        Both the utility and the code that’s generated use BPOs and a generic data dictionary to perform the import.

·        The data file may be zeroed prior to the import.

·        An entire record – all fields – may be read, or individual data fields may be selected, in any order.

·        Header records in delimited and fixed field formats can be included, but will be ignored.

·        Generated code is IDE compatible and can be added to Abdata by the wizard.

·        Recnum is never imported, all records should start with a field greater than 0

1.      Delimited

·         Data may be separated by comma, semicolon, tilde, asterisk or almost any other single character.  Tab delimiting is not supported.

·         Double quotes around strings are ignored

·         Selected data fields in the import file may be ignored by use of a “dummy” field.  Select “TempStr” in place of a live data field.  This will only work in the delimited format, not for the others.

2.      XML

The general XML format is as follows

- <FILENAME>

- <Row>

  <CATEGORY>Batch Claims</CATEGORY>

  <SUB_POSITION>3</SUB_POSITION>

  <ACTIVATION>Activate_servedi_rpt</ACTIVATION>

  </Row>

- <Row>

  <CATEGORY>Batch Claims</CATEGORY>

  <SUB_POSITION>3</SUB_POSITION>

  <ACTIVATION>Activate_ContractEDI_rpt</ACTIVATION>

  </Row>

etc.

 

Cdata sections may also be read without any changes, if used.

3.      Fixed Field Length

The file format is NOT the same as the one exported by dbExplor, so do not try and read a file generated by dbExplor. 

It is expected that each new data field will start at the end of the previous.  For example,

             Length    Start Position

Field1       6             1

Field2      8             7

Field3      2             15

Field4      1             17

etc.

What the utility will NOT do

            Line delimited formats are not read.

            Fixed Field Length formats generated by dbExport are not read

            XML will not currently read attributes

            Recnum is assumed to never be in the import file, all records should start with field greater than 0

            Only one file at a time can be imported, related files are not considered

            Fixed Field and XML will not work with the “TempStr” concept