TitleLeaf

Template notes

All Templates

  • Column names must be as specified in the templates. If TitleLeaf does not recognize a column name, then the data will not be ingested.
  • The column order does not affect ingestion.
  • A column header with a red background is a required field. The row will not be successfully ingested without it.
  • Hover the cursor over the column header for column details.
  • Remove blank columns from the right end of the spreadsheet (i.e., columns without a header).
  • Remove blank rows rows from the bottom of the spreadsheet.
  • Avoid carriage returns in fields (eg, in description and annotation.
  • Be careful of non-ascii characters. Verify when copying from Excel to Google Doc.
  • Do not put "-" or "N/A" in fields (simply leave blank).

Template: products

  • A Title (see type column) can be assigned to multiple sets (eg, columns set1, set2, set3)
  • A Set (see type column) cannot be assigned to other sets
  • To assign a Title to a Set, the set row must precede the title row. In other words, the set must be defined (or it must pre-exist in the database) before it's used in columns set1, set2, set3
  • Both titles and sets can be assigned to a series/subseries
  • Format dates as YYYY-MM-DD. For example, August 1 2015 should be formatted by your spreadsheet application as "2015-08-01".
  • The proprietary_id is for the product (not the product format)
  • Unacceptable interest_level_min values: PK (use either P or K, for Preschool and Kindergarten respectively)
  • The first_release_on is optional, but recommended. It is the earliest release date of all associated product formats.
  • No need for title column if subtitle not included as well
  • Avoid duplicate categories (e.g., "Art" and "Arts")
  • The interest_level_max value must be greater than or equal to interest_level_min value
  • Unacceptable interest/reading level: 0

Template: product_formats

  • The proprietary_product_id is mandatory if creating a new product format. The value represents the proprietary_id of a pre-existing product. It is used to associate the product format record to the product record.
  • The proprietary_id is for the product format (not the product).
  • The format_name overrides the default format for the given product format row only. Refer to the Override Format Name guide for more information.
  • The release_on is mandatory. It is the release date of the product format.
  • If the release date is in the future, then the status must be set to NYP
  • Format dates as YYYY-MM-DD. For example, August 1 2015 should be formatted by your spreadsheet application as "2015-08-01".
  • Unacceptable copyright value: 0
  • Unacceptable pages value: 0
  • Do not include single or double quotes in the dimensions column. The value is assumed to be in inches.
  • Do not put fractions in the dimensions column. Use decimals instead (8 1/4 => 8.25).