| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | name(+) | 0;1 | FREE TEXT | B | This field identifies the format used by the non-VA FileMan application. | |
| 1 | field delimiter | 0;2 | FREE TEXT | Contents of the field delimiter is output between each field. Depending on the contents of the SEND LAST FIELD DELIMITER? field, the delimiter may be output after the last field, too. Identify the delimiter either by 1-15 characters not beginning with a number or by the ASCII value of the delimiter. When specifying the ASCII value, use 3 numbers (e.g., '009' for ASCII 9). Up to four ASCII-character values can be specified, separated by commas. If 'Ask' is entered, the user will be prompted for the field delimiter when creating the EXPORT template. | ||
| 2 | record delimiter | 0;3 | FREE TEXT | Contents of the record delimiter is output after each record. Identify the delimiter either by 1-15 characters not beginning with a number or by the ASCII value of the delimiter. When specifying the ASCII value, use 3 numbers (e.g., '009' for ASCII 9). Up to four ASCII-character values can be specified, separated by commas. If 'Ask' is entered, the user is prompted for the record delimiter when creating the EXPORT template. | ||
| 3 | line continuation character | 0;4 | FREE TEXT | Not used yet. | ||
| 4 | line continuation location | 0;5 | SET OF CODES | e:END OF LINE b:BEGINNING OF LINE | Not used yet. | |
| 5 | record length fixed? | 0;6 | BOOLEAN | 1:YES 0:NO | Enter YES if the fields will be fixed length causing a fixed length record to be created. When the EXPORT template is created, the user is prompted for the length of each field in the TARGET file. | |
| 6 | need foreign field names? | 0;7 | BOOLEAN | 1:YES 0:NO | Answer YES if it is necessary to save the field names from the foreign file in the export file. The user will be prompted for the names when the EXPORT template is created. | |
| 7 | maximum output length | 0;8 | NUMERIC | The maximum length of a "line" of output; maximum number of characters before a LINE FEED is issued. For most exports, this will be the maximum record length. If 0 is entered, the user will be prompted for maximum length when creating the EXPORT template. If nothing is entered, the default will be 80. | ||
| 8 | quote non-numeric fields? | 0;10 | BOOLEAN | 1:YES 0:NO | If you want the values of fields that have a data type other than numeric to be surrounded by quotation marks ("), set this field to YES. NOTE: Only numeric fields in the home file (including multiples) are automatically considered to have a numeric data type. If you want the user to indicate which fields should be numeric, answer YES to the PROMPT FOR DATA TYPE? field. | |
| 9 | prompt for data type? | 0;11 | BOOLEAN | 1:YES 0:NO | Answer YES if you want the user to be prompted for the data type of the various fields at the time that an export template is being created. Otherwise, the data types will be automatically derived. | |
| 10 | send last field delimiter? | 0;12 | BOOLEAN | 0:NO 1:YES | Enter NO if you do not want a field delimiter to be output after the last field in a record. Enter YES if you do want a final field delimiter output. | |
| 11 | substitute for null | 0;13 | FREE TEXT | This field only affects numeric values exported in a delimited format. If nothing is entered in this field, data values of null will cause nothing to be exported for that field in the particular record. If you want something to be exported when the data value is null, enter the character or characters in this field. | ||
| 20 | file header | 1;E1,245 | FREE TEXT | Use this field to produce output preceding the exported records. This will become part of your exported data. Enter either a literal string enclosed in quotation marks ("like this") or MUMPS code that will WRITE the desired output when XECUTED. For example: W "EXPORT CREATED BY USER NUMBER: "_$G(DUZ) | ||
| 25 | file trailer | 2;E1,245 | FREE TEXT | Use this field to produce output following the the exported records. This will become part of your exported data. Enter either a literal string enclosed in quotation marks ("like this") or MUMPS code that will WRITE the desired output when XECUTED. For example: W "EXPORT CREATED BY USER NUMBER: "_$G(DUZ) | ||
| 27 | date format | 6;E1,245 | FREE TEXT | If you want dates output in VA FileMan's standard external date/time format, make NO entry in this field. If you want another format, enter MUMPS code here. The variable X will contain the date/time in VA FileMan's internal format. The MUMPS code should SET Y to the date/time in the format you desire. | ||
| 30 | description | 3;0 | WORD-PROCESSING | A description of the foreign format. | ||
| 31 | usage notes | 4;0 | WORD-PROCESSING | Information about the use of the format; for example, which commands on the foreign system should be used to load the file. | ||
| 40 | format used? | 0;9 | BOOLEAN | 0:NO 1:YES | When set to YES, this field means that this Foriegn Format entry has been used to create an Export Template. | |
| 50 | other name for format | 5;0 | MULTIPLE | .441 |