Burt Export Formats for TM
Note: Burt requires a separate license fee. Contact the Naviga Support Center for details.
In Targeted Marketing, you can export draw and truck information in a format required by Burt Technologies software. Three fixed-length ASCII files are created: one each for Draw Control, Draw by Ad Route, and Draw by Carrier Route. The files will be exported to the /dti/exchange/cm directory. A fourth fixed-length file for the File Name Index will also be created, or appended if it already exists.
The file formats are described below.
Draw Control File
Draw by Ad Route Checksum; file name: ARCTM.MMDDYY
Routing Schedule
X(6)
The Burt routing schedule defined in Format Set
Field Delimiter
X(1)
space
Publication Date
99/99/99
Delivery date selected in processing; formatted as MM/DD/YY
Field Delimiter
X(1)
space
Route Count
999999
Number of routes exported
Field Delimiter
X(1)
space
Draw Total
999999999 (9 dig.)
Total draw exported
Draw by Route (No publishing date)
Draw by Ad Route; file name: ARTM.MMDDYY
Ad Route
X(10)
Route ID
Field Delimiter
X(1)
space
Reserved
X(4)
spaces
Field Delimiter
X(1)
space
Draw Quantity
999999999 (9 dig.)
Draw for the route
Field Delimiter
X(1)
space
Class of Sale
X(2)
“HD” for Home Delivery; “SC” for Single Copy
Field Delimiter
X(1)
space
Product Type
X(2)
Product type defined in Format Set
Field Delimiter
X(1)
space
Ad Zone
X(8)
Ad Zone, Truck ID, or Zip Code assigned to the route (Ad Zone Type defined for the Burt Format Set). The Ad Zone option is available only if InsertPlus is being used.
Field Delimiter
X(1)
space
Editorial Zone
X(10)
Edition assigned to the route for the delivery date selected in processing
Field Delimiter
X(1)
space
Packages per bundle
9999
zeros
Field Delimiter
X(1)
space
Route Classification
X(6)
spaces
Field Delimiter
X(1)
space
Trip
X(10)
Truck ID
Field Delimiter
X(1)
space
Packet Number
9999
zeros
Field Delimiter
X(1)
space
First Key
9999
zeros
Field Delimiter
X(1)
space
Second Key
9999
zeros
Field Delimiter
X(1)
space
Bundle Order
X(4)
spaces
Draw by Route by Date, by Delivery Sequence, with Drop Sequence
Draw by carrier route; file name: CRTM.MMDDYY
Delivery Schedule
X(6)
The Burt routing schedule defined in Format Set
Field Delimiter
X(1)
space
Publication Date
99/99/99
Delivery date selected in processing; formatted as MM/DD/YY
Field Delimiter
X(1)
space
Reserved
X(5)
spaces
Field Delimiter
X(1)
space
Carrier Route
X(15)
Route ID
Field Delimiter
X(1)
space
Ad Route
X(10)
Route ID
Field Delimiter
X(1)
space
Reserved
X(4)
spaces
Field Delimiter
X(1)
space
Draw Quantity
999999
Draw quantity for the route
Field Delimiter
X(1)
space
Route Sequence
9999
zeros
Field Delimiter
X(1)
space
Drop
X(10)
Truck ID + TruckDropSequence.DropOrder
Field Delimiter
X(1)
space
Drop Sequence
9999
Drop order
Field Delimiter
X(1)
space
Trip/Load
X(10)
Truck ID
Field Delimiter
X(1)
space
Trip/Load Sequence
9999
zeros
Field Delimiter
X(1)
space
Truck
X(6)
Truck
Field Delimiter
X(1)
space
Sequence Offset
HH:MM
00:00
Reserved
X(10)
space
Field Delimiter
X(1)
space
Reserved
X(6)
space
Field Delimiter
X(1)
space
Zip Code
99999
Primary Zip for the route
Field Delimiter
X(1)
space
Class of Sale
X(2)
“HD” for Home Delivery; “SC” for Single Copy
Field Delimiter
X(1)
space
Product Type
X(2)
Product type defined in Format Set
Field Delimiter
X(1)
space
Ad Zone
X(8)
Ad Zone, Truck ID, or Zip Code assigned to the route (Ad Zone Type defined for the Burt Format Set). The Ad Zone option is available only if InsertPlus is being used.
Field Delimiter
X(1)
space
Editorial Zone
X(10)
Edition assigned to the route for the delivery date selected in processing
Field Delimiter
X(1)
space
PPB
9999
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)
spaces
Field Delimiter
X(1)
space
Presort Discount
99
zeros
Field Delimiter
X(1)
space
Packet Number
9999
zeros
Field Delimiter
X(1)
space
First Key
9999
zeros
Field Delimiter
X(1)
space
Second Key
9999
zeros
Field Delimiter
X(1)
space
Bundle Order
X(4)
spaces
File Name Index File
File name index; file name: FN
Delivery or Routing Schedule
X(6)
The Burt routing schedule defined in Format Set
Field Delimiter
X(1)
space
Publication Date
99/99/99
Delivery date selected in processing; formatted as MM/DD/YY
Field Delimiter
X(1)
space
Checksum File
X(12)
ARC[P, AC, AD].MMDDYY
Field Delimiter
X(1)
space
Draw by Ad Route
X(12)
AR[P, AC, AD].MMDDYY
Field Delimiter
X(1)
space
Draw by Carrier Route
X(12)
CR[P, AC, AD].MMDDYY
Field Delimiter
X(1)
space
Last updated
