Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

The File Formula field of a Channel Rule supports a variety of variables depending on the asset type.

For data files that group multiple products together (eg, CSV, XLSX, ONIX), the following variables are supported:

Variable

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-hhmm format. The time is in 24-hour format. Example: 20191231-0915

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

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.

  • No labels