...
Contact info@titleleaf.com for FTP account credentials.
Data filesTemplates for the data files listed below are available via Google Docs.
| 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. |
| 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. |
| File Name | Ingestion Type |
| DOE_JOHN_pic.jpg | Contributor Portraits |
| ISBN_fc.jpg | Front Covers |
| ISBN_bc.jpg | Back Covers |
| ISBN_int.jpg | Spreads |
| DESCRIPTION_web.jpg, DESCRIPTION_web.png | Web Images |
| 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. |
| 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. |
These are InDesign or Quark Xpress packages. The package directory must be zipped. The cover and interior packaged files can either be zipped together or separately. That choice dictates the following file naming.
| File Name | Ingestion Type | Description |
| ISBN_layout.zip | Layouts | A zip file containing both the packaged cover and interior of a given title. |
| ISBN_layout_cvr.zip | Layout Covers | A zip file containing the packaged cover only of a given title. The interior must also be provided to comprise a complete archive of the given title. |
| ISBN_layout_int.zip | Layout Interiors | A zip file containing the packaged interior only of a given title. The cover must also be provided to comprise a complete archive of the given title. |
| 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. |
...