Tags:
create new tag
view all tags

.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

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r3 - 2019-09-26 - JeanNeron
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback