0LASubrFileCsvImport < Main

Tags: 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._

<br /><span data-mce-mark="1">%TOC%</span>
---++ Usage:
<pre>*     PASS         &lt;error_msg&gt;                FIELD            SHARE? Y
*     PASS         &lt;file_name&gt;                FIELD            SHARE? N
*     PASS         &lt;disposition&gt;              FIELD            SHARE? N
*     PASS         &lt;application&gt;              FIELD            SHARE? N
*     PASS         &lt;database&gt;                 FIELD            SHARE? N
*     PASS         &lt;count success&gt;            FIELD            SHARE? Y
*     PASS         &lt;count total&gt;              FIELD            SHARE? Y
*     PASS         &lt;count fail&gt;               FIELD            SHARE? Y
*     PASS         &lt;path & file name&gt;         FIELD            SHARE? N
*     GOSUB    --- .FILE CSV IMPORT
      *        Check for errors
*     IF       --- .FILE CSV IMPORT           NE

</pre>
---++ Description:

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

&lt;error_message&gt; contains additional error information if the command fails (Required). Must be PASSed with Share "Y".

&lt;file_name&gt; is the name of the APPX file to import (Required).

&lt;disposition&gt; 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.

&lt;application&gt; 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.

&lt;database&gt; 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.

&lt;count_success&gt; is the count of records successfully imported. This is optional and must be PASSed with Share "Y" to return a value.

&lt;count_total&gt; 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.

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

&lt;path & file name&gt; 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/&lt;database&gt;/&lt;application&gt;/Portdata/ folder and named &lt;file_name&gt;.csv. This is the same location the [[0LASubrFileCsvExport][.FILE CSV EXPORT]] API places exported data. If &lt;path & file name&gt; are specified, then that file will be copied to the $APPXPATH/&lt;database&gt;/&lt;application&gt;/Portdata/&lt;file_name&gt;.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._

<br />%COMMENT%

-- Main.PeteBrower - 2011-08-12
Topic revision: r3 - 2019-09-26 - JeanNeron