Catalog Admin – Treeline Biblio Data Feed Specs

If your company does not work with ONIX, and you prefer to submit your core bibliographic data via spreadsheet rather than using Edelweiss’s online cataloging tools, please use our Treeline_Biblio_Data Excel Template, which is available here:  Treeline_Biblio_Data_Template_v1.

Click here to download a PDF version of this specification guide:  Treeline_Biblio_ Template Specs v1

And don’t forget to check out our Treeline_Biblio file Troubleshooting Tips here if you experience any issues with your Treeline_Biblio file processing.

Feed Specifications and Requirements

  • File Format: Excel (2007 or earlier) or DOS-formatted, tab-delimited Text (.txt)
  • File Name: “Treeline_Biblio_1.xls” or “Treeline_Biblio_[MMDDYY].xls” (or .txt)
  • FTP Drop Folder: [your FTP account]/edelweiss/import_data/ folder on our server at na-ftp.abovethetreeline.com

Contact your Edelweiss account manager or support@abovethetreeline.com before you post your very first Treeline_Biblio file to your FTP account, as we will need to configure your account to begin auto-processing these files.

This folder will be monitored by an automated process and feeds will typically be processed within 30 minutes of receiving them, though this processing window is subject to change and may be delayed if the volume of feeds needing to be processed is especially high. Processed feeds will be moved to the /edelweiss/import_data/processed folder and kept there for up to 3 months. The individual at your organization responsible for posting ancillary feeds may also be set up to receive the automatic alert email that lets them know if their file was successfully processed. Contact Support@abovethetreeline.com if you need to add or update this feed recipient list.

Note that all of the particular data formatting requirements are annotated in each column header field found within the Treeline_Biblio_Data template, as well as below.

Other Requirements:

  • All number values should be formatted as text
  • Include all columns found in this template
  • Do NOT add, edit, or remove any columns or column headers

*Required Fields

  1. EAN
  2. Title
  3. Cont 1 (Contributor 1)
  4. Pubdate
  5. Binding
  6. List Price
  7. BISAC Subject

Data Formatting Requirements for Each Field

Column A:  ISBN: text, 10 characters, no hyphens

Column B:  EAN: text, 10, 13, or 14 ISBN or EAN, no hyphens, *required field

Column C:  UPC: text, 12 digits, no hyphens or other characters

Column D:  Title: text, no abbreviations, may include sub-title if unavailable separately, not more than 200 characters long, *required field

Column E:  Subtitle: text, no abbreviations

Column F:  Edition: numeric (e.g. 2), formatted as text or number

Column G:  Edition Desc:  value must be from this list or else leave blank

  • ABR = Abridged
  • ANN = Annotated
  • ENL = Enlarged
  • LTE = Large Print
  • REV = Revised
  • STU = Student Edition
  • TCH = Teacher’s Edition
  • UBR = Unabridged

Column H:  Series Name:  text, no abbreviations, not more than 100 characters long

Column I:  Series Num: not currently used

Column J:  Cont 1:  text, name of the contributor or author 1, listed as Last Name, First Name, *required field

Column K: Cont 1 Role: value must be from this list or else leave blank and the default A01 role will be used:

  • A01 = Author
  • B01 = Editor
  • A12 = Illustrator
  • C01 = Compiled by
  • B06 = Translator
  • A13 = Photographer
  • A06 = Composer
  • E08 = Recorded by
  • D01 = Producer
  • E07 = Read by
  • Z99 = Other

Column L: Cont 2:  refer to specs listed for Cont 1 Column J above

Column M: Cont 2 Role:  refer to specs listed for Cont 1 Role Column K above

Column N: Cont 3:  refer to specs listed for Cont 1 Column J above

Column O: Cont 3 Role:  refer to specs listed for Cont 1 Role Column K above

Column P: Imprint:  text, Name of either Imprint or Publisher

Column Q: Pubdate:  text, this field must be formatted as MMYYYY, with the leading 0 included for all months January (01) thru September (09), *required field

Column R: Status:  value must be from the following list or else leave blank and an IP/Active status will be applied to that title. Note that Edelweiss doesn’t automatically update these statuses, so we recommend using the IP code for all current and forthcoming active titles.

  • AB = Canceled
  • IP = Active ** Recommended for all NYP titles
  • MD = On demand
  • NP = Not yet published
  • OI = Out of stock indefinitely
  • OP = Out of print
  • TP = Temporarily out of stock

Column S: Media: text, the value must be from the following list or else leave blank:

  • A = Audio Product
  • B = Book
  • C = Calendar
  • D = Digital Carrier (i.e. CD ROM, Computer DVD, diskette)
  • J = Journal
  • K = Map
  • V = Video Product

Column T: Binding: value must be from the following list, and this is a *required field:

Media Type A:

  • AA = Analog Audio Cassette
  • CD = Compact Disc
  • DV = DVD

Media Type B or J:

  • BD = Board Books
  • BX = Boxed Set
  • FB = Fabric
  • LB = Library Binding
  • LE = Leather
  • MM = Mass Market Paperbound
  • PO = Printed Paper Over Board
  • SP = Spiral
  • TP = Paperback
  • TC = Hardcover
  • VB = Vinyl Bound
  • PD = Cards
  • XB = Dumpbin – Empty
  • XC = Dumpbin – Filled
  • XD = Counterpack – empty
  • XE = Counterpack – Filled
  • XF = Poster, promotional
  • XJ = Spinner
  • XL = Shrink-wrapped pack
  • ZA = General Merchandise
  • ZB = Doll
  • ZC = Soft Toy
  • ZD = Toy
  • ZE = Game
  • ZF = T-shirt
  • ZZ = Other merchandise

Media Type C:

  • DK = Desk
  • MN = Mini
  • WL = Wall

Media Type D:

  • DG = Electronic Book
  • CG = Game Cartridge
  • DO = MSDOS
  • MC = Macintosh
  • MX = Hybrid
  • WX = Windows

Media Type K:

  • FF = Folded
  • GG = Globe
  • NF = Not Folded, Rolled

Media Type V:

  • DV = DVD
  • VD = VHS
  • VK = Video Disk

Column U:  List Price: numeric formatted as text, US retail price only, do NOT include $ or other currency symbols, *required field

Column V:  CAD Price: numeric formatted as text, Canadian retail price only, do NOT include $ or other currency symbols

Column W:  Discount_Code: text, should reflect your internal discount code value, not a number or percentage

Column X:  Ctn Qty: Carton Quantity, numeric formatted as text

Column Y:  Pages: numeric formatted as text

Column Z:  BISAC Subject: BISAC Standard Subject Codes – Contact the Book Industry Study Group for a list of codes – www.bisg.org, must be listed as the (one) primary code, e.g. BIO004540, not the category description, *required field

Column AA:  Audience: value must be from the following list or leave blank

  • 01 = General/Trade
  • 02 = Children/Juvenile
  • 03 = Young Adult

Column AB:  Language: values are based on the ISO Language Codes; i.e.

  • ENG = English
  • SPA = Spanish
  • FRE = French
  • GER = German
  • ITA = Italian
  • CHI = Chinese
  • JPN = Japanese
  • MUL = Multiple Languages
  • RUS = Russian
  • POR = Portuguese
  • HEB = Hebrew
  • LAT = Latin

(Not currently displayed anywhere in Edelweiss)

Column AC:  Product Description: Product Long Summary Description, maximum of 1000 characters, either No HTML or Full HTML, NO Carriage Returns, and NO Author Bios

Column AD:  Height: numeric formatted as text, in inches, but only up to two places beyond the decimal points, e.g. 6.13 NOT 6.125.

Column AE:  Width: numeric formatted as text, in inches, but only up to two places beyond the decimal points, e.g. 6.13 NOT 6.125.

Column AF:  Thickness: numeric formatted as text, in inches, but only up to two places beyond the decimal points, e.g. 1.13 NOT 1.125.