Burt Export Formats
File type: Fixed length. A space is exported for field delimiters, unless the BurtPlus add-on is used, in which case a pipe symbol (|) is exported for field delimiters.
Location: /dti/exchange/cm. The names for each of the four files are given below. In the file names, [draw type] will be “P” (pending), “AC” (actual) or “AD” (advance), and [extension] will be the product ID and/or draw date (format mmddyy), based on the Business Rule What should the file extension be for Burt export files?. For example, if the Business Rule was answered “Product ID and Draw Date”, the Carrier Route file exported for actual draw on May 9 2012 for the Times would be named CRAC.Times050912.
Ad Route Checksum
File name: ARC[draw type].[extension].
Delivery Schedule
x(6)
The routing scheduled entered at runtime
Field Delimiter
x(1)
Space
Publication Date
mm/dd/yy
The draw date entered at runtime
Field Delimiter
x(1)
Space
Route Count
9(6)
Number of routes exported
Field Delimiter
x(1)
Space
Draw Total
9(9)
Total draw exported
Draw by Ad Route
File name: AR[draw type].[extension].
Ad Route
x(10) or x(15)
Route ID or ad zone ID or “MAIL” + editionID (based on Business Rules). Note: if Burt version 7 is used (based on Business Rules) this field is extended to 15 characters.
Field Delimiter
x(1)
Space
Reserved
x(4)
Spaces. Note: if Burt version 7 is used (based on Business Rules) this field and the previous delimiter are not exported, and the Ad Route field is extended to 15 characters.
Field Delimiter
x(1)
Space
Draw Quantity
9(9)
Draw for the route
Field Delimiter
x(1)
Space
Class of Sale
x(2)
Based on the Business Rules, this can be “HD” for Home Delivery and “SC” for Single Copy, or the first two characters of the route’s route type or single copy type
Field Delimiter
x(1)
Space
Product Type
x(2)
“I” if Product Type was Parts; “C” if Product Type was Routes or Completes (as prompted for at runtime)
Field Delimiter
x(1)
Space
Ad Zone
x(8) or x(15)
Ad Zone, Truck ID or Zip Code, as defined at runtime. Note: if Burt version 7 is used (based on Business Rules) this field is extended to 15 characters.
Field Delimiter
x(1)
Space
Editorial Zone
x(10)
Edition ID for draw date selected at runtime. If ad zones are exported as ad routes, an edition ID is only exported if all routes in the ad zone have the same edition.
Field Delimiter
x(1)
Space
Packages per bundle
9(4)
Zeros
Field Delimiter
x(1)
Space
Route Classification
x(6)
Spaces
Field Delimiter
x(1)
Space
Trip
x(10)
Truck ID or “MAIL” + editionID (based on Business Rules)
Field Delimiter
x(1)
Space
Packet Number
9(4)
Zeros
Field Delimiter
x(1)
Space
First Key
9(4)
Zeros
Field Delimiter
x(1)
Space
Second Key
9(4)
Zeros
Field Delimiter
x(1)
Space
Bundle Order
x(4)
Spaces
Draw by Carrier Route
File name: CR[draw type].[extension].
Delivery Schedule
x(6)
The routing scheduled entered at runtime
Field Delimiter
x(1)
Space
Publication Date
mm/dd/yy
The draw date entered at runtime
Field Delimiter
x(1)
Space
Reserved
x(5)
Spaces
Field Delimiter
x(1)
Space
Carrier Route
x(15)
Route ID or “MAIL” + editionID (based on Business Rules)
Field Delimiter
x(1)
Space
Ad Route
x(10) or x(15)
Route ID or ad zone ID (based on Business Rules). Note: if Burt version 7 is used (based on Business Rules) this field is extended to 15 characters.
Field Delimiter
x(1)
Space
Reserved
x(4)
Spaces. Note: if Burt version 7 is used (based on Business Rules) this field and the previous delimiter are not exported, and the Ad Route field is extended to 15 characters.
Field Delimiter
x(1)
Space
Draw Quantity
9(6)
Draw quantity for the route
Field Delimiter
x(1)
Space
Route Sequence
9(4)
Order in which route is dropped by truck, or “0000” (based on the Business Rules)
Field Delimiter
x(1)
Space
Drop
x(10)
Truck ID + first 4 digits of drop order
Field Delimiter
x(1)
Space
Drop Sequence
9(4)
Drop order. Burt is limited to a 4-digit sequence. If the route’s drop sequence is over 4 digits, only the first 4 digits will be exported.
Field Delimiter
x(1)
Space
Trip/Load
x(10)
Truck ID of truck that drops route
Field Delimiter
x(1)
Space
Trip/Load Sequence
9(4)
Zeros
Field Delimiter
1(1)
Space
Truck
x(6)
Truck ID (if relay trucks are used, parent truck)
Field Delimiter
x(1)
Space
Sequence Offset
HH:MM
00:00 or last for digits of the truck departure (based on the Business Rules)
Field Delimiter
x(1)
Space
Reserved
x(10)
Spaces
Field Delimiter
x(1)
Space
Reserved
x(6)
Spaces
Field Delimiter
x(1)
Space
Zip Code
9(5)
Primary Zip for the route
Field Delimiter
x(1)
Space
Class of Sale
x(2)
Based on the Business Rules, this can be “HD” for Home Delivery and “SC” for Single Copy, or the first two characters of the route’s route type or single copy type
Field Delimiter
x(1)
Space
Product Type
x(2)
“I” if Product Type was Parts; “C” if Product Type was Routes or Completes (as prompted for at runtime). Product types can also vary by route (as defined in Route Setup) and have other values.
Field Delimiter
x(1)
Space
Ad Zone
x(8) or x(15)
Ad Zone, Truck ID or Zip code, as defined at runtime. Note: if Burt version 7 is used (based on Business Rules) this field is extended to 15 characters.
Field Delimiter
x(1)
Space
Editorial Zone
x(10)
Edition ID for draw date selected at runtime
Field Delimiter
x(1)
Space
PPB
9(4)
Zeros
Field Delimiter
x(1)
Space
Route Class
x(6)
Spaces
Field Delimiter
x(1)
Space
Reserved
x(3)
Space
Field Delimiter
x(1)
Space
Entry Discount
x(3)
Entry discount specified in the Business Rules
Field Delimiter
x(1)
Space
Presort Discount
9(2)
Presort discount specified in the Business Rules
Field Delimiter
x(1)
Space
Packet Number
9(4)
Zeros
Field Delimiter
x(1)
Space
First Key
9(4)
Zeros
Field Delimiter
X(1)
Space
Second Key
9(4)
Zeros
Field Delimiter
X(1)
Space
Bundle Order
X(4)
Spaces
File Name Index File
File name: FN. Note that this file is appended each time the Burt Export is run.
Delivery Schedule
x(6)
The routing scheduled entered at runtime
Field Delimiter
x(1)
Space
Publication Date
mm/dd/yy
The draw date entered at runtime
Field Delimiter
X(1)
Space
Checksum File
x(12)
Name of Ad Route Checksum file created by export
Field Delimiter
x(1)
Space
Draw by Ad Route
X(12)
Name of Draw by Ad Route file created by export
Field Delimiter
x(1)
Space
Draw by Carrier Route
X(12)
Name of Draw by Carrier Route file created by export
Delimiter
X(1)
Space
Carrier Detail
This file will be exported when the Burt export is run with the BurtPlus add-on activated. One record will be exported for each route. Its primary purpose is to identify carriers/dealers and the routes they deliver/manage.
File name: CRD[draw type].[extension].
Carrier Route
x(15)
Route ID
Field Delimiter
x(1)
Pipe
Description
x(35)
Route name
Field Delimiter
x(1)
Pipe
Note
x(35)
Blank
Field Delimiter
x(1)
Pipe
Class of Sale
x(2)
Route’s class of sale (same as exported in CR file)
Field Delimiter
x(1)
Pipe
District
x(6)
First 6 characters of the route’s district
Field Delimiter
x(1)
Pipe
Zip Code
x(10)
Route’s Zip (same as exported in CR file)
Field Delimiter
x(1)
Pipe
Completes Only
x(3)
Blank
Field Delimiter
x(1)
Pipe
Complete at Plant
x(3)
Blank
Field Delimiter
x(1)
Pipe
Bundle Type
x(7)
“BULK” if route is bulked in truck sequence. Otherwise “LABELED”.
Field Delimiter
x(1)
Pipe
Label Type
x(8)
Blank
Field Delimiter
x(1)
Pipe
Carrier Manifest
x(3)
Blank
Field Delimiter
x(1)
Pipe
Carrier
x(10)
Account ID of carrier delivering the route. For dealers, the dealer account ID.
Field Delimiter
x(1)
Pipe
Special Instructions
-
Blank.
Carrier Messages
This file will be exported when the Burt export is run with the BurtPlus add-on activated, and contains messages for starts, stops, etc. similar to those that print on the bundle tops. For each message, seven records are exported with incrementing message sequences and the following content in the Message field:
Sequence 1. Message type (Start, Stop, Complaint, etc.) and product ID
Sequence 2. Subscriber’s address
Sequence 3. Subscriber’s last name, first name, phone, delivery placement, delivery instructions
Sequence 4. If message is for a stop and related to a move out, “Move Stop”; if related to a delivery schedule change, “Service Change”; otherwise the stop reason code and description. If message is for a start related to a move, “Move Start”; if related to a delivery schedule change, “Service Change”. If message is a delivery placement, new placement instructions. If message is related to a complaint, the complaint code and text. If message is a previous delivery, “Previous [previous delivery day] [previous delivery tran date] Delivery.” If a Message transaction, message text exports here.
Sequence 5. If a Message transaction and text is more than 254 characters, the rest of the message exports here.
Sequence 6. Delivery schedule ID, copies, subscription ID, transaction create date and time.
Sequence 7. Blank.
File name: CM[draw type].[extension].
Delivery Schedule
x(6)
The routing scheduled entered at runtime
Field Delimiter
x(1)
Pipe
Publication Date
mm/dd/yy
The draw date entered at runtime
Field Delimiter
x(1)
Pipe
Carrier Route
x(15)
Route ID
Field Delimiter
x(1)
Pipe
Sequence
9(4)
Sequence of this message within all messages exported for route. Each message record for a route will have a unique sequence number. The first digit of the sequence will be the first digit of the Deliverable Sort for the publication, as defined in Deliverable Sort setup. If no Deliverable Sort is defined for the publication, “0” will be exported for the first digit. Note: When a route delivers multiple publications, the first digit of the Sequence field will be the publication identifier.
Field Delimiter
x(1)
Pipe
Message
x(254)
Message text
Last updated