---+ .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 <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 </pre> ---++ 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 [[0LASubrFileCsvExport][.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._ <br />%COMMENT% -- Main.PeteBrower - 2011-08-12
This topic: Main
>
WebHome
>
FullAPIList
>
0LASubrFileCsvImport
Topic revision: r3 - 2019-09-26 - JeanNeron
Copyright © 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