# Burt Export Formats for TM

{% hint style="info" %}
**Note:** *Burt requires a separate license fee. Contact the Naviga Support Center for details.*
{% endhint %}

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`

<table><thead><tr><th>Field</th><th width="199.6153846153846">Format</th><th width="300">Description</th></tr></thead><tbody><tr><td>Routing Schedule</td><td>X(6)</td><td>The Burt routing schedule defined in Format Set</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Publication Date</td><td>99/99/99</td><td>Delivery date selected in processing; formatted as MM/DD/YY</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Route Count</td><td>999999</td><td>Number of routes exported</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Draw Total</td><td>999999999 (9 dig.)</td><td>Total draw exported</td></tr></tbody></table>

### Draw by Route (No publishing date)

Draw by Ad Route; file name: `ARTM.MMDDYY`

<table><thead><tr><th>Field</th><th width="150">Format</th><th width="324">Description</th></tr></thead><tbody><tr><td>Ad Route</td><td>X(10)</td><td>Route ID</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Reserved</td><td>X(4)</td><td>spaces</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Draw Quantity</td><td>999999999 (9 dig.)</td><td>Draw for the route</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Class of Sale</td><td>X(2)</td><td>“HD” for Home Delivery; “SC” for Single Copy</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Product Type</td><td>X(2)</td><td>Product type defined in Format Set</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Ad Zone</td><td>X(8)</td><td>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.</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Editorial Zone</td><td>X(10)</td><td>Edition assigned to the route for the delivery date selected in processing</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Packages per bundle</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Route Classification</td><td>X(6)</td><td>spaces</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Trip</td><td>X(10)</td><td>Truck ID</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Packet Number</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>First Key</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Second Key</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Bundle Order</td><td>X(4)</td><td>spaces</td></tr></tbody></table>

### Draw by Route by Date, by Delivery Sequence, with Drop Sequence

Draw by carrier route; file name: `CRTM.MMDDYY`

<table><thead><tr><th>Field</th><th width="150">Format</th><th width="323">Description</th></tr></thead><tbody><tr><td>Delivery Schedule</td><td>X(6)</td><td>The Burt routing schedule defined in Format Set</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Publication Date</td><td>99/99/99</td><td>Delivery date selected in processing; formatted as MM/DD/YY</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Reserved</td><td>X(5)</td><td>spaces</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Carrier Route</td><td>X(15)</td><td>Route ID</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Ad Route</td><td>X(10)</td><td>Route ID</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Reserved</td><td>X(4)</td><td>spaces</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Draw Quantity</td><td>999999</td><td>Draw quantity for the route</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Route Sequence</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Drop</td><td>X(10)</td><td>Truck ID + TruckDropSequence.DropOrder</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Drop Sequence</td><td>9999</td><td>Drop order</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Trip/Load</td><td>X(10)</td><td>Truck ID</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Trip/Load Sequence</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Truck</td><td>X(6)</td><td>Truck</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Sequence Offset</td><td>HH:MM</td><td>00:00</td></tr><tr><td>Reserved</td><td>X(10)</td><td>space</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Reserved</td><td>X(6)</td><td>space</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Zip Code</td><td>99999</td><td>Primary Zip for the route</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Class of Sale</td><td>X(2)</td><td>“HD” for Home Delivery; “SC” for Single Copy</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Product Type</td><td>X(2)</td><td>Product type defined in Format Set</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Ad Zone</td><td>X(8)</td><td>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.</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Editorial Zone</td><td>X(10)</td><td>Edition assigned to the route for the delivery date selected in processing</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>PPB</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Route Class</td><td>X(6)</td><td>spaces</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Reserved</td><td>X(3)</td><td>space</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Entry Discount</td><td>X(3)</td><td>spaces</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Presort Discount</td><td>99</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Packet Number</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>First Key</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Second Key</td><td>9999</td><td>zeros</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Bundle Order</td><td>X(4)</td><td>spaces</td></tr></tbody></table>

### File Name Index File

File name index; file name: FN

<table><thead><tr><th>Field</th><th width="150">Format</th><th width="324">Description</th></tr></thead><tbody><tr><td>Delivery or Routing Schedule</td><td>X(6)</td><td>The Burt routing schedule defined in Format Set</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Publication Date</td><td>99/99/99</td><td>Delivery date selected in processing; formatted as MM/DD/YY</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Checksum File</td><td>X(12)</td><td>ARC[P, AC, AD].MMDDYY</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Draw by Ad Route</td><td>X(12)</td><td>AR[P, AC, AD].MMDDYY</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr><tr><td>Draw by Carrier Route</td><td>X(12)</td><td>CR[P, AC, AD].MMDDYY</td></tr><tr><td>Field Delimiter</td><td>X(1)</td><td>space</td></tr></tbody></table>