Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
.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. |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
.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
| ||||||||
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. |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
.FILE CSV IMPORTThis 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.-- PeteBrower - 2011-08-12 |