# 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)