SAVE LAYOUT command

Used to save an ACL table layout to an external table layout file (.layout), or to save table layout metadata to an ACL table.

Note

Prior to version 11 of ACL Analytics, external table layout files used an .fmt file extension. You can still save a table layout file with an .fmt extension by manually specifying the extension.

Syntax

SAVE LAYOUT {FILE|TABLE} TO {file_name|table_name}

Parameters

FILE | TABLE
  • Specify FILE to save an ACL table layout to an external table layout file (.layout).

  • Specify TABLE to save table layout metadata to an ACL table.

TO file_name | table_name

If you are saving an ACL table layout to an external table layout file, TO file_name specifies the name of the .layout file. The .layout file extension is used by default and does not need to be specified. The file is saved in the same folder as the ACL project.

If you are saving table layout metadata to an ACL table, TO table_name specifies the name of the output ACL table and the associated .fil file. The .fil file extension is used by default and does not need to be specified. The table is saved in the same folder as the ACL project.

You can specify an absolute or relative path to save the file or the table in an existing folder other than the folder containing the ACL project.

You must specify the file_name or table_name value as a quoted string if the name of the file or table, or the path, contains any spaces.

Remarks

The SAVE LAYOUT command can be used for two different purposes, explained in the sections that follow.

SAVE LAYOUT FILE

SAVE LAYOUT FILE saves the table layout of the open ACL table to an external table layout file with a .layout extension. A table layout contains metadata that provides a structured interpretation of the raw data in an associated source data file. A table layout does not contain any source data itself.

Saving a table layout as a .layout file makes the table layout and its metadata portable and reusable. The .layout file can be imported into any ACL project and associated with a matching source data file – that is, a data file with data elements that match the field definitions specified by the table layout metadata. For example, you could save the table layout of a transactions file from March, and associate it with a source data file containing transactions from April, assuming the structure of the data in the March and April source data files is identical. Used in this manner, .layout files can save you the labor of creating a new table layout from scratch.

For more information about the structure of ACL tables, see the ACL Analytics User Guide.

SAVE LAYOUT TABLE

SAVE LAYOUT TABLE extracts the metadata from the table layout of the open ACL table and saves it to a new ACL table. The new table is not the table layout itself, but rather a regular ACL table that contains a summary of the table layout metadata for the original table. Having access to this summary in an ACL script can allow you to make decisions in the script based on the information.

For each field in the original table the following pieces of table layout metadata are extracted into the new table. The name of the field containing the metadata in the new table appears in parentheses at the end of each line below. These field names in the new table are always generated in English regardless of which localized version of ACL you might be using.

Computed fields are included in the extracted metadata, but the expression used by the computed field, and any conditions, are not recorded. Start position, field length, and decimal places are also not recorded for computed fields.

Related fields are not included because they are not part of the table layout. Field-level filters and field notes are not included.

The values recorded for alternate column title and column width are the ones specified in the table layout, not the view-level values that can also be specified for columns.

Examples

a. Save a table layout to an external table layout file (.layout)

The following examples save the table layout used by the open table to an external table layout file called “Ap_Trans.layout”. In the first example, the table layout file is saved in the ACL project folder. In the second example, the table layout file is saved in the specified folder.

SAVE LAYOUT FILE TO Ap_Trans.layout

SAVE LAYOUT FILE TO "C:\ACL DATA\AP Audit 2013\Ap_Trans.layout"

b. Save a copy of table layout metadata to a new ACL table

The following examples save a copy of the metadata in the table layout used by the open table to a new ACL table called “Ap_Trans_layout_metadata”. In the first example, the new ACL table is saved in the ACL project folder. In the second example, the new ACL table is saved in the specified folder.

SAVE LAYOUT TABLE TO Ap_Trans_layout_metadata

SAVE LAYOUT TABLE TO "C:\ACL DATA\AP Audit 2013\Ap_Trans_layout_metadata"

Related reference
SAVE command
SAVE LOG command
SAVE WORKSPACE command
IMPORT LAYOUT command


(C) 2015 ACL Services Ltd. All Rights Reserved.