FILE TRAILER You can use this field like the FILE HEADER field. The literal or M code is output the exported after data. Variables Available for Developer Use Some of the fields in the FOREIGN FORMAT file (#.44) allow you to enter M code, if you have programmer access. You can use data stored in the EXPORT template entry at the time the export is performed. You can also access information in the FOREIGN FORMAT file (#.44) entry used for the export. Two variables are available for use in the M code entered in the FOREIGN FORMAT file (#.44) fields: DDXPXTNO—Internal entry number of the EXPORT template in the PRINT TEMPLATE file. DDXPFFNO—Internal entry number of the Foreign Format in the FOREIGN FORMAT file (#.44). Consult the data dictionaries of the two files for fields that can contain useful information about either the format or the specific export itself. The EXPORT FIELD Multiple field (#100) in the PRINT TEMPLATE file (#.4) might be of particular interest. This Multiple contains information about each field being exported. Print Format Documentation Option Figure 25: Import and Export Tools—Print Format Documentation option VA FileMan ... [DIUSER] Other Options ... [DIOTHER] Data Export to Foreign Format ... [DDXP EXPORT MENU] Print Format Documentation [DDXP FORMAT DOCUMENTATION] You can list the available FOREIGN FORMAT file (#.44) entries on the system using the Print Format Documentation option. When you use this option, you are given the choice of specifying individual formats or of printing all of the formats on your system. Since your system can contain many formats, try to select individual ones.
FILE TRAILER You can use this field like the FILE HEADER field. The literal or M code is output after the exported data. Variables Available for Developer Use Some of the fields in the FOREIGN FORMAT file (#.44) allow you to enter M code, if you have programmer access. You can use data stored in the EXPORT template entry at the time the export is performed. You can also access information in the FOREIGN FORMAT file (#.44) entry used for the export. Two variables are available for use in the M code entered in the FOREIGN FORMAT file (#.44) fields: DDXPXTNO—Internal entry number of the EXPORT template in the PRINT TEMPLATE file. DDXPFFNO—Internal entry number of the Foreign Format in the FOREIGN FORMAT file (#.44). Consult the data dictionaries of the two files for fields that can contain useful information about either the format or the specific export itself. The EXPORT FIELD Multiple field (#100) in the PRINT TEMPLATE file (#.4) might be of particular interest. This Multiple contains information about each field being exported. Print Format Documentation Option Figure 25: Import and Export Tools—Print Format Documentation option VA FileMan ... [DIUSER] Other Options ... [DIOTHER] Data Export to Foreign Format ... [DDXP EXPORT MENU] Print Format Documentation [DDXP FORMAT DOCUMENTATION] You can list the available FOREIGN FORMAT file (#.44) entries on the system using the Print Format Documentation option. When you use this option, you are given the choice of specifying individual formats or of printing all of the formats on your system. Since your system can contain many formats, try to select individual ones.
fm22_2um2.docx