FTP file naming convention

Instead of using the admin web interface, you can upload files via FTP for ingestion. The directory is processed every hour on the half hour. The files will appear in the ingestion list if they're properly processed. The file naming convention determines how the file is processed (see table below). If the file does not adhere to the naming convention, then the file will be placed in the failed directory of your account and not appear in the ingestion list.

Contact info@titleleaf.com for FTP account credentials.

Data files

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

Image files

File Name Ingestion Type
DOE_JOHN_pic.jpg Contributor Portraits
ISBN_fc.jpg Front Covers
ISBN_bc.jpg Back Covers
ISBN_int.jpg Spreads

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

Layout files

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.

Important: Be certain to follow the general FTP ingestion rules.