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