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
Field | Format | Description |
---|---|---|
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
Field | Format | Description |
---|---|---|
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
Field | Format | Description |
---|---|---|
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
Field | Format | Description |
---|---|---|
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