Channel Rule File Formula
- Tim Peterson
The File Formula field of a Channel Rule or Package supports a variety of variables depending on the asset type.
Variables are designated in the File Formula field using the following, single-curly-bracket syntax:
{VARIABLE_NAME}For data files that group multiple products together (eg, CSV, XLSX, ONIX), the following variables are supported:
Variable Name | Description |
|---|---|
{BASENAME} | The simplified name of your TitleLeaf instance. Example: moopress |
{DATESTAMP} | The date in YYYYMMDD format. Example: 20191231 |
{DISTRIBUTION_ID} | The TitleLeaf ID for the given distribution. Example: 9999 |
{TIMESTAMP} | The date and time in YYYYMMDD-hhmmss format. The time is in 24-hour format. Example: 20191231-091502 |
For an individual asset file that is assigned to a specific Product or Product Format (eg, a cover or spread), the following additional variables are supported:
Variable Name | Description |
|---|---|
{name_by_author_and_product_name} | A combination of both the author’s name and the product’s name. Example: CynthiaAmoroso-Cows |
{name_by_collection_name_and_isbn_code} | A combination of both the collection/series name and the ISBN code (ie, the last 5 digits of the ISBN). Example: InTheBarnYard-08256 |
{name_by_collection_name_and_product_name} | A combination of both the collection/series name and the product’s name. Example: InTheBarnYard-Cows |
{name_by_isbn} | The full ISBN. Example: 9781503808256 |
{name_by_isbn_and_product_name} | A combination of both the full ISBN and the product’s name. Example: 9781503808256-Cows |
{name_by_product_id} | The TitleLeaf ID for the product. Example: 6501 |
{name_by_product_name} | The product’s name. Example: Cows |
{name_by_product_name_and_isbn_code} | A combination of both the product’s name and the ISBN code (ie, the last 5 digits of the ISBN). Example: Cows-08256 |
{name_by_proprietary_product_id} | The proprietary ID for the product (ie, your internal ID for the product). Example: PA15486 |
Non-alphanumeric characters such as spaces, dashes and colons are removed from the file name.