If your company does not work with ONIX and you prefer to submit your core bibliographic data via spreadsheet (rather than using Edelweiss’ catalog administration tools), please use our Treeline_Biblio_Data Excel Template, available here: Treeline_Biblio_Data_Template_v1.
Click here to download a PDF version of this specification guide: Treeline_Biblio_ Template Specs v1
Also, if you experience any issues with your Treeline_Biblio file processing, please check out our Treeline_Biblio file troubleshooting tips here.
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 after you post your very first Treeline_Biblio file to your FTP account. We will need to configure your account to begin auto-processing these files!
This FTP folder will be monitored by an automated process, with feeds typically processed within 30 minutes once we receive them. This processing window is subject to change and may be delayed if the volume of submitted feeds awaiting processing is high. Processed feeds will be moved to the /edelweiss/import_data/processed folder, and will remain there for up to 3 months.
The individual at your organization responsible for posting ancillary feeds may also be set up to receive an automatic alert email to let them know if files process successfully. Please contact support@abovethetreeline.com if you need to create this feed or update its recipient list!
Note that all data formatting requirements are annotated in each column header field, found below and within the Treeline_Biblio_Data template.
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
- EAN
- Title
- Cont 1 (Contributor 1)
- Pubdate
- Binding
- List Price
- 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.