AX2766

Run file processing on an Axiom file

If a file is set up to use file processing, you can process the file to automatically create various file outputs:

• Save snapshot copies of the file and automatically email them to various recipients.
• Print one or more sheets in the file using one or more print views.
• Export data in the file to a comma-separated values (CSV) or text file.
• Collect multiple output files into a single report package.
• Process multiple reports in batch.

You can use file processing in all spreadsheet Axiom files except file group templates; however, report files are the most common use case.

NOTE: The file processing menu command and the associated task pane are available only to administrators and to users with the Allow File Processing permission for the file.

1. Open the file. To view what the file is configured to do during file processing before running it, check the settings in the File Processing task pane.

2. In the File Processing task pane, in the Actions section, click one of the following options to start processing:
   • Process File: The file is processed once as is. The file is refreshed and the file processing action is performed. No multipass filter or settings are applied.

   • Process File Multipass: The file is processed multiple times, with a unique filter applied for each pass. For example, if the file is set up to process by DEPT, the file is processed once for each department. The data queries in the file are filtered automatically to return data for the current pass department only.

   TIP: You can also process the file using the File Processing menu on the Axiom tab. (In systems with installed products, this feature may be located on the Main tab.)

After file processing is initiated, the following occurs:

• The file is refreshed. If you perform multipass processing, the file is refreshed using a data filter for the current pass item.
• The file processing action is performed. If you perform multipass processing, the action may be performed after each pass or after all passes are complete, depending on the file processing settings.

A status bar displays the progress of the file processing. When the processing is complete, a confirmation box displays information about the process, such as how many passes were performed, how many files were created, and so on.

Note that the file itself is not saved as part of file processing. You can process a file even if you have read-only rights to the file. However, if the file processing is set up to save to the database, you must have rights to save data for that file.