You can set the output file and file type, as well as any additional XML or Excel options you can set the export order, including related fields and grouping options and you can choose to perform the import without displaying dialogs to the user. The available script step options are shown in Figure 20.11. The Export Records script step is quite powerful, capable of automating all export settings. The Export Records script step performs the bulk of the actual work, and the script then returns the user to his original layout (the layout from which he invoked the script). The script then performs Show All Records so that all member records currently in the system will be exported. The layout establishes context and thus governs which source table the exported records will be drawn from. This script first establishes its context by navigation to the Member_Detail layout. Exporting can be fully automated by using a script. Consider the script shown in Figure 20.11.įigure 20.11. In these cases, it makes sense to consider using a script to perform the export.Īll aspects of exporting can be scripted, from the selection of the records to be exported, to the determination of output file type, filename, and location, to the choices of specific fields and export options. In such circumstances it's typical that you'll want to export the same set of fields, for different data sets at different times. You may need to export a membership list to a text file periodically, or create a file containing information on this month's invoices to send to an accounting system that doesn't interact with FileMaker. Exporting, though, is often an operation you want to be able to perform repeatedly, on demand. All the techniques covered so far involve manual export operations, in which the user drives the process by hand, including the selection of output file type and filename, and the selection of fields for export.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |