Burt Export Formats
Note: Burt requires a separate license fee. Contact the Naviga Support Center for details.
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].
| Field Name | Field Length and Type | Field Contents |
|---|---|---|
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].
| Field Name | Field Length and Type | Field Contents |
|---|---|---|
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].
| Field Name | Field Length and Type | Field Contents |
|---|---|---|
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.
| Field Name | Field Length and Type | Field Contents |
|---|---|---|
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].
| Field Name | Field Length and Type | Field Contents |
|---|---|---|
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].
| Field Name | Field Length and Type | Field Contents |
|---|---|---|
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
