empximpt
EMPXIMPT(1) EMPXIMPT(1)
NAME
empximpt - Import data from a data file created with other software
package.
SYNOPSIS
empximpt -d [options] dBASE_file empress_db
empximpt -l [-v] DIF_file empress_db table_name
DESCRIPTION
empximpt imports data from a data file created with other software
package into a EMPRESS database. Formats supported: dBASE III, dBASE
III Plus, Data Interchage format (DIF - the conversion format recog-
nized by Lotus 1-2-3, Quattro Pro, and other spreadsheet programs).
-d Imports data from a dBASE III, dBASE III Plus and dBASE IV file
(.dbf).
Options:
-a Convert memo data from DOS end-of-line (EOL) conventions
to UNIX EOL conventions (CR LF -> LF). This option has
no effect on the MS-DOS platform.
-c value Choose the type of EMPRESS character field to be cre-
ated. Valid value are 1,2,3; the default is 3.
-f Force creation of a table. If this option is not used,
and a table of the same name as that given in the empx-
impt command line already exists, an error message will
result. If this option is used, the existing table will
be overwritten by the new table.
-l Convert the attribute name from uppercase (default of
dBASE) to lowercase.
-r Import all records including records deleted under
dBASE. dBASE does not physically remove deleted records
from a file; if this flag is set, these records will be
added to the EMPRESS database along with all the others.
-s val val val val Set the size of the EMPRESS text field to be
created. (EMPRESS text fields correspond to
memo fields in the original dBASE file.) The
values are display length, primary storage
length, overflow storage and number of acces-
sible extents. The defaults are 80, 512, 512,
1.
-t table Name the EMPERSS table to be created. Used this option
to avoid overwriting an existing table with the same
name as the default; or when the default table name is a
reserved word under EMPRESS. When this option is not
used, empximpt takes the name of the dBASE file (exclud-
ing the .dbf extension) as the default.
-v[value] Run the program in verbose mode. This option can provide
different levels of debug messages. Valid values are
0-3; the default is 1. The option -v0 turns off verbose
mode.
-z value Choose the type of EMPRESS date field to be created.
Valid values are 0-8; the default is 0.
dBASE_file Specify the dBASE file to be imported. This file
will not be changed by the process. The file exten-
sion .dbf will be appended to the dBASE file name,
if dBASE_file does not have any file extension.
empress_db Specify the EMPRESS database.
-l Import data from a DIF file.
-v Run the program in verbose mode.
DIF_file Specify the Data Interchange Format (DIF) file.
empress_db Specify the EMPRESS database.
table_name Specify the EMPRESS table name.
NOTES
1. Empress and dBASE field types differ. The empximpt -d option han-
dles this in the following way:
dBASE character fields will be converted to EMPRESS NLS character
fields.
dBASE numeric fields, if they do not contain decimals and their
width is not greater than 4, will be converted to EMPRESS integer
fields.
dBASE numeric fields, if they do not contain decimals and their
width is greater than 4, will be converted to EMPRESS longinteger
fields.
dBASE numeric fields, if they contain decimals and their width is
not greater than 15, will be converted to EMPRESS decimal fields.
dBASE numeric fields, if they contain decimals and their width is
greater than 15, will be converted to EMPRESS longfloat fields.
dBASE IV float fields will be converted the same way as dBASE num-
beric fields.
dBASE date fields will be converted to EMPRESS date fields.
dBASE logical fields will be converted to 1-byte EMPRESS character
fields.
dBASE memo fields will be converted to EMPRESS NLS text fields.
dBASE IV uses a special, non-displaying field call _DBASELOCK in
the dbf file. empximpt will not import this field into the EMPRESS
database.
Currently empximpt can accept a maximum of 512 attributes in each
table.
HISTORY
Written by Empress Software Inc.. All material is copyrighted and
licensed. Use on non-licensed CPUs is prohibited.
Empress 8.62 Empress Software Inc. EMPXIMPT(1)