Saving results and specifying results output folders

When you perform an operation on an ACL table and save the results to a new ACL table or a text file, you have several options regarding the manner in which you save the results, and the location of the results output folder.

Important

ACL tables include a table layout, visible in the ACL Project Navigator, and an associated source data file with a .fil extension, not visible in the Project Navigator, stored in a Windows folder. Understanding the difference between the table layout and the source data file can be important when saving results and specifying results output folders.

For more information, see The structure of ACL tables.

Saving results

When saving results to an ACL table or a text file, you have the following options:

Some operations allow you to save results to either an ACL table or a text file, while other operations allow saving to only an ACL table or only a text file.

When appending to or overwriting an ACL table, you typically append to or overwrite a table in the open ACL project. Appending updates the source data file but does not alter the table layout. Overwriting replaces both the source data file and the table layout.

By navigating to the appropriate Windows folder when saving results, you can also append to or overwrite the source data file for an ACL table in another project. When you do so, the updated or overwritten table remains in the other project and is also added to the open project, with both table layouts in the two projects sharing the same source data file. You should be certain that this is your intended outcome before saving results in this manner.

Specifying results output folders

When you save results, there are two types of ‘output folder’ to consider:

ACL project folders are not Windows folders, and creating an ACL project folder does not create a corresponding Windows folder. ACL project folders are virtual folders inside the ACL project file (.acl). You can move a table layout between ACL project folders and it has no effect on the location of the table’s source data file in a Windows folder.

When saving results to an ACL table, you have several options regarding placement of the table layout and the source data file, summarized in Table 1. You can independently control placement of the table layout and the source data file by using the SET FOLDER command for table layout placement, and standard Windows navigation for source data file placement.

Table 1. Table layout and source data file placement options

Placement options (output folder)

Table layout

  • the ACL project folder containing the active table (the default)

  • an ACL project folder other than the active table folder, specified using the SET FOLDER command

Source data file (.fil)

  • the Windows folder containing the ACL project (the default)
  • a Windows folder other than the folder containing the ACL project
  • the Prefix folder on the ACL Server (server tables only; the default)

  • a folder on the ACL Server other than the Prefix folder (server tables only)

Table 2 provides examples of using the SET FOLDER command to specify the appropriate ACL project folder for the resulting table layout. The output folder remains as whatever you set it – until you reset it, or close the project. Upon opening the project, the output folder reverts to the default of the active table folder. File paths specified in the SET FOLDER command must use a forward slash. You enter the commands in the command line.

Table 2. SET FOLDER examples

Command syntax

Description

SET FOLDER /Results

Table layout is placed in the Results ACL project folder rather than the active table folder.

SET FOLDER /Results/Duplicates

Table layout is placed in the Duplicates ACL project subfolder rather than the active table folder.

SET FOLDER /

Table layout is placed in the ACL project root directory rather than the active table folder.

SET FOLDER

Resets the output folder to the default of the active table folder.

DISPLAY OUTPUTFOLDER

Displays the current ACL project output folder.

Interaction between table layouts and ACL project folders

The interaction between table layouts resulting from operations and ACL project folders is summarized Table 3. In all cases, the Windows folder where you choose to save the source data file has no bearing on the location of the table layout or the project folder within ACL.

Table 3. Interaction between table layouts and ACL project folders

Action

Output folder in ACL is active table folder (default)

Output folder in ACL is specified by SET FOLDER command

Save results to new ACL table

Table layout added to same ACL project folder as active table

Table layout added to ACL project folder specified by SET FOLDER command

Append results to existing ACL table in project

Existing table layout not moved

Existing table layout not moved

Save results and overwrite existing ACL table in project

Table layout moved to same ACL project folder as active table, unless already in same folder

Table layout moved to ACL project folder specified by SET FOLDER command, unless already in same folder

Append results to existing ACL table in another project

Table layout added to same ACL project folder as active table

Table layout in other project unaltered

Both table layouts share the same source data file

Table layout added to ACL project folder specified by SET FOLDER command

Table layout in other project unaltered

Both table layouts share the same source data file

Save results and overwrite existing ACL table in another project

Related tasks
Running commands from the ACL command line
Harmonizing ACL project folders and Windows folders


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback