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.

Template: products-default

  • A title (see type column) can be assigned to multiple sets
  • 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
  • Be careful of non-ascii characters. Verify when copying from Excel to Google Doc.
  • Do not include " in dimensions
  • Do not put fractions in the dimensions column. Use decimals instead (8 1/4 => 8.25)
  • Format dates as YYYY-MM-DD. For example, August 1 2015 should be formatted by your spreadsheet application as "2015-08-01".
  • Do not put "-" or "N/A" in fields (simply leave blank)
  • 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)
  • release_on is mandatory. it is the release date of the product format.
  • If release_on is in the future, then the status must be set to NYP.
  • available_on is optional. it is the earliest release date of all associated product formats.
  • unacceptable copyright: 0
  • unacceptable pages: 0
  • No need for title column if subtitle not included as well
  • Avoid duplicate categories (e.g., "Art" and "Arts")
  • Isbn columns (e.g., reinforced_book_isbn, pdf_isbn, etc) can be added or deleted. At least one isbn column is required. For each isbn column, a product format will be created if it doesn't already exist in the database. The format is dictated by the column name. The remaining product format values are the same for all formats as defined in the product template (e.g., each format will have the same price, copyright, pages, etc). To override these values, you must use the "product_formats-template" google doc.
  • Delete blank columns from the right end of the spreadsheet (i.e., columns without a header).
  • Delete blank rows rows from the bottom of the spreadsheet.
  • Avoid carriage returns in description and annotation.
  • Interest level max must be greater than or equal to interest level min
  • Unacceptable interest/reading level: 0