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).
