Find Data Row

Description

Sets the value of a variable as the row number in a CSV or Excel file in which a column contains a specified string. For more on how Fuga works with spreadsheets, see the article Working With Data in Fuga.

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

Location

The Find Data Row action is located in the Fuga Workshop panel under the Data actions category.

Parameters

File Location Parameters

These parameters help tell Fuga where to find the spreadsheet file. For more information, 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.

General Find Data Row Parameters

Text To Find Field
(string) The text to locate.
In Column Named Field
(string) The name of the column to search for text in.
Start Search From Row Field
(number) The row to begin searching from. Will search this row and all rows beneath.
Put Row Number In Drop-down
The variable to store the row number containing the text.

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>