.FILE CSV IMPORT

This subroutine is called to import data in CSV format into an APPX file. Release 5.4.0 & up.

Usage:

*     PASS         <error_msg>                FIELD            SHARE? Y
*     PASS         <file_name>                FIELD            SHARE? N
*     PASS         <disposition>              FIELD            SHARE? N
*     PASS         <application>              FIELD            SHARE? N
*     PASS         <database>                 FIELD            SHARE? N
*     PASS         <count success>            FIELD            SHARE? Y
*     PASS         <count total>              FIELD            SHARE? Y
*     PASS         <count fail>               FIELD            SHARE? Y
*     PASS         <path & file name>         FIELD            SHARE? N
*     GOSUB    --- .FILE CSV IMPORT
      *        Check for errors
*     IF       --- .FILE CSV IMPORT           NE

Description:

This subroutine will import data in CSV format into the specified APPX file.

<error_message> contains additional error information if the command fails (Required). Must be PASSed with Share "Y".

<file_name> is the name of the APPX file to import (Required).

<disposition> determines how any existing data in the APPX file is handled (Required). 1 means the CSV data will be merged with any existing data, 2 means the APPX file will be initialized before the data is imported.

<application> is the name of the application containing the file to import. This is optional and if not specified it will default to the current application.

<database> is the name of the database containing the file to import. This is optional and if not specified it will default to the current database.

<count_success> is the count of records successfully imported. This is optional and must be PASSed with Share "Y" to return a value.

<count_total> is the total count of records processed, whether they were successfully imported or not. This is optional and must be PASSed with Share "Y" to return a value.

<count_error> is the count of records that were not imported. This is optional and must be PASSed with Share "Y" to return a value.

<path & file name> is an optional location for the data to import (5.4.5 and higher only).

The CSV file is expected to be in the $APPXPATH/<database>/<application>/Portdata/ folder and named <file_name>.csv. This is the same location the .FILE CSV EXPORT API places exported data. If <path & file name> are specified, then that file will be copied to the $APPXPATH/<database>/<application>/Portdata/<file_name>.csv file for you (overwriting any file that may already exist).

NOTE: The user must have Data Management rights for the Database / Application you want to import, or be an APPX System Administrator.

Comments:

Read what other users have said about this page or add your own comments.

-- PeteBrower - 2011-08-12