Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Templates for the data files listed below are available via Google Drive.

File Name

Ingestion Type

Description

default.csv

Default

To create/update products and their associated formats. As indicated by the name, it is the most widely used template.

awards.csv

Awards

To create/update awards conferred to products.

assembly_assignments.csv

Assembly Assignments

Assembly is the internal TitleLeaf term for Sets. This file associates titles to sets.

bestsellers-products.csv

Products Only

To define the sales rate of products. The sales rate is used to compose the best sellers list.

bisac_subjects.csv

Bisac Subjects

Internal use only

categories.csv

Categories

The internal TitleLeaf term for Subjects.

categories_products.csv

Categories to Products

To associate products to categories.

collections.csv

Collections

The internal TitleLeaf term for Series.

common_core_ela.xml

Common Core ELA

Internal use only

common_core_math.xml

Common Core Math

Internal use only

contributors.csv

Contributors

To create/update contributors (eg, Authors, Illustrators, Editors, etc).

contributor_assignments.csv

Contributor Assignments

To associate products to contributors.

contributor_interviews.csv

Contributor Interviews

To associate interviews to contributors.

editorial_reviews.csv

Editorial Reviews

To create/update editorial reviews.

editorial_reviews_products.csv

Editorial Review Products

To associate products to editorial reviews.

links.csv

Links

To create/update website links.

links_products.csv

Link Products

To associate products to website links.

postal_codes.csv

Postal Codes

To create/update postal codes.

price_changes.csv

Price Changes

Internal use only.

products.csv

Products Only

To update product data only (as opposed to product format data). See also default.csv.

product_formats.csv

Product Formats

To update product format data only (as opposed to product data). See also default.csv.

products_standards.csv

Product Standards

To associate products to standards such as the Common Core.

related_product_assignments.csv

Related Product Assignments

To create a relation between 2 products.

testimonials.csv

Testimonials

To create/update testimonials.

Image files

File Name

Ingestion Type

Description

DOE_JOHN_pic.jpg

Contributor Portraits

A photo of a contributor

ISBN_fc.jpg

Front Covers

Stored on the Product level

ISBN_fc2.jpg

Front Covers 2

Stored on the Product Format level

ISBN_int.jpg

Spreads

Stored on the Product level

ISBN_int2.jpg

Spreads 2

Stored on the Product Format level

ISBN_bc.jpg

Back Covers

Stored on the Product Format level

DESCRIPTION_web.jpg, DESCRIPTION_web.png

Web Images

Stored in the Image model

Ebook/Draft files

File Name

Ingestion Type

Description

ISBN_draft.pdf

Drafts

A draft file in PDF format containing multiple pages of the designated title.

ISBN.epub

Ebooks

An Epub file to be distributed and sold.

ISBN.mobi

Ebooks

A Mobi or KF8 file to be distributed and sold.

ISBN.mp3

Ebooks

A MP3 file to be distributed and sold.

ISBN.wav

Ebooks

A WAV file to be distributed and sold.

ISBN_ebook.pdf

Ebooks

A PDF file to be distributed and sold. Optionally (if requested during site setup), TitleLeaf will create an excerpt from the PDF file.

ISBN_ebook_cvr.pdf

Ebook Covers

A one-page PDF file of the front and back cover combined. It should contain crop marks. Along with the interior, it is used to create a final, salable PDF ebook.

ISBN_ebook_int.pdf

Ebook Interiors

A multi-page PDF file of the interior of a book. It should NOT contain crop marks. Along with the cover, it is used to create a final, salable PDF ebook.

ISBN_excerpt.pdf

Excerpts

An excerpt file in PDF format containing multiple pages of the designated title.

Other files

File Name

Ingestion Type

Description

PID_tg.[txt|rtf|pdf|doc|docx|csv|xml|xls|xlsx|xltx|zip]

Teaching Guides

A teaching guide document.

PID_ho.[txt|rtf|pdf|doc|docx|csv|xml|xls|xlsx|xltx|zip]

Handouts

A handout document.

...