Prefix Code Summary
NOTE: The explanations refer to the old Interloc system.
NOTE 2: BookTrakker UIEE upload files do not contain any header information.
If you are using the UIEE files for your own web site then you may not want to put all the extra fields into Notes. We do this because the online services usually have only limited fields to use, so most of the data gets mapped into Notes.
BookTrakker uploads files using the .txt extension, such as Upload_1.txt
There is no header information in the upload file; it starts
out with the UIEE record right at the top of the file. There is a line between
records.
The following summary describes the various prefix codes used in UIEE files. Codes are listed in alphabetical order.
AA - Author (128 chars). This code applies to both importing and uploading records. Information preceded by the AA prefix is mapped directly to/from the Author field. Author in BookTrakker.
AI - Illustrator (50 chars). This code applies to both importing and uploading records. Information preceded by the AI prefix is mapped directly to/from the Illustrator field. Illustrator in BookTrakker
BD - Binding (50 chars). This code applies to both importing and uploading records. Information preceded by the BD prefix is mapped directly to/from the Binding field. Cover and/or Type in BookTrakker
BN - ISBN (15 chars) Not Used, see NC field.
CA - Category. (50 chars). Indicates what Categories the user wants this record to be placed in. Categories names are under the user’s control. Categories are Hit Lists in BookTrakker. The UIEE file allows for multiple Categories, all starting with CA|
CN - Condition (32767 chars).This code applies to both importing and uploading records. Information preceded by the CN prefix is mapped directly to/from the Condition field. Note that a feature in the UIEE import facility allows you to transpose Comments into Condition if desired. Book/DJ and/or Defects in BookTrakker
CO - Copies (10 chars) Number of copies. Quantity in BookTrakker
DP - Date Published (50 chars). This code applies to both importing and uploading records. Information preceded by the DP prefix is mapped directly to/from the Date Pub field. Date in BookTrakker
ED - Edition (50 chars). This code applies to both importing and uploading records. Information preceded by the ED prefix is mapped directly to/from the Edition field. Edition in BookTrakker.
FP - Shipping (15 chars) A new field added 8/28/2005. Fixed shipping. Media Mail shipping from the S&H field on the Prices tab in BookTrakker. Also used for zShops Media Mail shipping. Uploads automatically to zShops.
IM - Image URL (255 chars) URL pointing to an image of the book. This may be listed twice. Image URL in BookTrakker
KE - Keywords (50 chars). There can be up to nine keywords in each record, both in your own database and on-line. Keywords must be individually preceded by separate prefix codes - you cannot put them all on the same line. Main Topic (described below) is treated as a keyword in the on-line databases for searching/matching purposes. Keywords in BookTrakker
LG - Language (50 chars) A new field added 8/28/2005. Used for what Language the book is written in.
LO - Location (100 characters) Location of the book in the Seller's collection, same as Shelved in BookTrakker. (Was SH)
MT - Main Topic (50 chars). This code applies to both importing and uploading records. When importing, information preceded by the MT prefix is mapped directly to the Main Topic field. When uploading, Main Topic is treated as a keyword (see Record Field Summary for additional information). Topic in BookTrakker
NC
- Comments (128 chars). Used for ISBN, for the most
part. ISBN in BookTrakker.
NT - Notes (32767 chars). This code applies to both importing and uploading records. Information preceded by the NT prefix is mapped directly to/from the Notes field. Any of multiple fields in BookTrakker
PP - Place Published (100 chars). This code applies to both importing and uploading records. Information preceded by the PP prefix is mapped directly to/from the Place Published field. Place in BookTrakker
PR - Price (20 numeric chars). This code applies to both importing and uploading records. Information preceded by the PR prefix is mapped directly to/from the Price field. Note that Price is a required field for Inventory records. Any of three prices in BookTrakker
PU - Publisher (100 chars). This code applies to both importing and uploading records. Information preceded by the PU prefix is mapped directly to/from the Publisher field. Publisher in BookTrakker
SM - Shipping Multiplier (5 chars) Not yet used, waiting for ABE to include this in their database.
TI - Title (510 Chars). This code applies to both importing and uploading records. Information preceded by the TI prefix is mapped directly to/from the Title field. Title/Subtitle in BookTrakker.
TP - Type/Size.(50 chars). Size of the book. Generally not used in BookTrakker UIEE, but available if user wants to. Size in BookTrakker
UR - Record Number (50 chars). This code designates the User Record Number, which the on-line system uses to distinguish one record from another in your account. If you are uploading an External UIEE File, you must include the UR code in each record. No spaces or punctuation are allowed. Record Number or Record Code in BookTrakker, depending on type of number used. Numeric or alpha-numeric.
WT - Weight (50 chars) A new field added 8/28/2005. The weight of the book expressed in pounds or grams.
Listing Codes
Listing Codes tell the on-line system what to do with your uploaded records when they are received. Although there are only two codes that must be explicitly selected when performing data entry (Action and Family), all four codes must be included in a UIEE record. BookTrakker includes the Lifespan and Database codes automatically when uploading from the BookTrakker database. The following summarizes the required listing codes:
XA - Lifespan Code: This code is currently disabled, but is required nonetheless. The standard code that should be included in all records is XA|4.
XB - Action Code: This tells the on-line system the action to take when your record is received, and gives you a visual indication within the record itself of the record's working status. Action codes also appear in the Inventory List, Wants List, and Record Queue for quick reference. The prefix must be followed by a single digit, as follows:
1 - For Sale: This is the normal (default) code. It simply indicates the record will either be treated as a new or replacement record when it is uploaded.
2 - Sold: Remove: This code removes the record from the on-line For-Sale database..
5 - Special, Auction, Missing. Book is to be removed from online database.
7 - On Hold: Indicates you have a buyer but have not yet consummated the transaction. It removes the listing.
Any number after XB other than 1
is cause to remove the book from listing!
XC - Family Code: The Family Code tells the on-line system the broad classification under which the records falls. This code is used primarily for on-line searches to limit results to specific types of materials. The prefix must be followed by a two-character code, as follows:
BO - Books: General
XD - Database Code: The Database Code tells the On-Line System in which database to store the uploaded record. The prefix must be followed by a single character, as follows:
S - For-Sale Database
W - Wants Database
UR|10
AA|Author
TI|TITLE Subtitle
CN|Very Good in Very Good dust jacket; Defects
AI|Illustrated by Illustrator
MT|Topic
PU|Publisher
PP|Place
DP|Date 3005
ED|2nd Revised and Enlarged German Edition;
First Printing
BD|Hardcover
NC|ISBN
NT|Features; Trade PB; Illus. Type; Size;
Pages pages; Notes; Signed
NT|by Author & Illustrator
KE|Keyword 1
KE|Keyword 2
KE|Keyword 3
KE|Keyword 4
KE|Keyword 5
KE|Keyword 6
KE|Keyword 7
KE|Keyword 8
KE|Keyword 9
PR|6.00
CO|1
LO|Shelved
IM|http://www.booktrakker.com/Avocado/33333.jpg
XA|4
XB|1
XC|BO
XD|S
The
recommended wrap length is 80 characters, but it can occur at any desired line
length. Wrapping should always occur at the point a space character (ASCII 32)
appears in the text. If no space character is present, the line should not be
wrapped. For translation purposes if data continues to the next line there will
always be a space at the end of each line.