Difference: 0LASubrFileCsvImport (1 vs. 3)

Revision 32019-09-26 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="FullAPIList"

.FILE CSV IMPORT

Line: 43 to 43
 <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).

Added:
>
>
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.

Revision 22016-09-27 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="FullAPIList"

.FILE CSV IMPORT

Line: 14 to 14
 * PASS <count success> FIELD SHARE? Y * PASS <count total> FIELD SHARE? Y * PASS <count fail> FIELD SHARE? Y
Added:
>
>
* PASS <path & file name> FIELD SHARE? N
 * GOSUB --- .FILE CSV IMPORT
    • Check for errors
* IF --- .FILE CSV IMPORT NE
Line: 39 to 40
  <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.
Changed:
<
<
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.
>
>
<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).

 

Comments:

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

Revision 12016-09-22 - JeanNeron

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="FullAPIList"

.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
*     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.

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.

Comments:

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


<--/commentPlugin-->

-- PeteBrower - 2011-08-12

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback