Save Vars

Description

Saves the values of variables. The values are saved into columns in the last row of a preexisting CSV or XLS file. For more on how Fuga works with spreadsheets, see the article Working With Data in Fuga.

Works On
This action works on a CSV or XLS file.
Changes Selection
This action does not change the selection.

Location

load

The Save Vars action is located in the Fuga Workshop panel under the Data actions category.

Parameters

The Save Vars action’s parameters can be found on both the File and the Mapping tabs in the Save Vars action’s parameter area. The parameters under the File tab specify where to find the data file and which row to start loading into the spreadsheet from. The parameters under the mapping tab specify which variable is loaded into which column.

File Location Parameters

These parameters help tell Fuga where to find the spreadsheet to load the variables into. The file must already exist and include column names. For more information on locating files, see the article on File Paths.

Path Field
(string) The absolute path, relative path, or file name for the spreadsheet file. 

  • If the Absolute Path option is selected from the Directory Options drop-down: The Path field contains the absolute path of the CSV or Excel file (e.g., “C:Documents:My Project:Spreadsheets:MyProjectData.xls”). To easily locate the absolute path, press the “…” button on the right hand side of the field to browse files.
  • If one of the Relative To options is selected from the Directory Options drop-down: The Path field contains the path relative to the directory. If the file is located in the top-level of the directory, this will be the file name (e.g., “MyProjectData.xls”). If the file is in a sub-folder of the directory this will be the name of the sub-folder or sub-folders plus the file name (e.g., “Spreadsheets:MyProjectData.xls”).
Directory Location Drop-Down
Tells Fuga where to look for the spreadsheet file. You must set each of these directories except for the current document directory using the Set Directory action

  • Absolute Path – Default. Specifies that the Directory field contains the absolute path of the spreadsheet.
  • Relative to Global Directory – Searches for the spreadsheet file in the global directory as set using the Set Directory action.
  • Relative to Current Document – Searches for the spreadsheet file in the directory that the current InDesign document is located in, unless the current document directory has been changed using the Set Directory action. The document must be saved to use this option or an error will be raised.
  • Relative to Database Directory – Searches for the spreadsheet file in the database directory as specified using the Set Directory action.
  • Relative to Images Directory – Searches for the spreadsheet file in the images directory as specified using the Set Directory action.
  • Relative to innd Files Directory – Searches for the spreadsheet file in the InDesign documents directory as specified using the Set Directory action.
  • Relative to Logo Directory – Searches for the spreadsheet file in the logo directory as specified using the Set Directory action.
  • Relative to Output Directory – Searches in the spreadsheet file in the output directory as specified using the Set Directory action.

Mapping Tab

These parameters assign variables to columns in a spreadsheet. If the variable matches the column name, it is possible to only input the variable name (this match must be case-sensitive). If you insert the name of one column, however, you must do so with all the columns.

Variable Column
The variable being assigned to the column. To insert a new variable name press the + button on the right side of the table and selected the variable to use from the menu that appears.
Column Name Column
(string) The name of the spreadsheet column to save the variable’s value into.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>