dbImportby Bob Worsley
DbImport is a new VDF wizard that will import data of multiple formats into DataFlex data files, or SQL if that's what you use. In addition, it will generate code for these formats that you can use for custom importing.
The supported formats are
The Delimited format will read data with strings enclosed in quotes or not, but separated by the desired delimiter. The delimiter may be selected from a combolist or entered by the user. This format is compatible with output from dbExport.
The expected XML format is:
- <FILENAME> - <Row> < FIELD1>Batch</ FIELD1> < FIELD2>3</FIELD2> < FIELD3>SMITH</ FIELD3> </Row> < FIELD1>Online</ FIELD1> < FIELD2>5</FIELD2> < FIELD3>GRANT</ FIELD3> etc.
Cdata sections may be read or not. This format is also compatible with output from dbExport.
Fixed field length
The Fixed Field Length format expects the data fields to be concatenated with each data element directly following the previous without any extra spaces. For example,
Length Start Position Field1 6 1 Field2 8 7 Field3 2 15 Field4 1 17 Etc.
In the case of fixed field length files, dbExport exports data in a format that is NOT compatible with dbImport, as dbExport adds a single blank column between data elements if the field width is longer than the length of the field name. If the data field width is less than the length of the field name, then the field name length is used instead, plus the blank column is included.
Other features are
All of the above apply to both the direct internal import and the generated code.
dbImport VDF17.1 release ~ 489kB January 30, 2016
dbImport VDF16/VDF17 release ~ 489kB October 4, 2012
dbImport VDF14 release ~690kB February 19, 2009
dbImport VDF12 release ~545kB November 4, 2007
dbImport release 1.1 ~ 82kB august 7, 2004
dbImport release 1.0 ~ 82kB
List of Changes
August, 2004 - Fixed a bug where if input file had fewer number of columns than the data file, the last input data field would be written to all remaining data file fields.
November 2007, this dbImport version was originally released for VDF12.0, but it will work fine in VDF12.1 too.
The package depends on the vWin32fh package to be included in a current workspace path or library.
February 2009, some bug fixes for screen shortcomings
Changed some of the lists to grids
Fixed studio modeling errors
Added ability to reject selected incoming text columns
Copyright © 1999 - 2019 VDF-GUIdance on all material published, for details see our Disclaimer.