Note: Burt requires a separate license fee. Contact the Newscycle Support Center for details.
Targeted Marketing address information can be exported for the Burt Address Manager application. A file map, “BurtMgr”, is used to export address data from Targeted Marketing. This file map has a usage of “TM”.
The entry discount and presort discount are exported to the carrier route (CR) file. Two Business Rules in the Route Services section to allow the entry of this information:
What entry discount code should be exported to Burt?
What presort discount code should be exported to Burt?
Note: Contact Naviga Support for assistance in setting up conversion programs.
The Burt Address Manager format is given in the following table.
AX_ID
Address ID
Float (decimal)
ADDR_KEY
Blank
Char
15
ADDRESS_TYPE
Dwelling types mapped to H, A or B in the conversion program.
Char
1
H=Home A=Apt B=Business
CARR_RTE
Address PO Route
Char
4
Postal Carrier Route
WALK_SEQUENCE
PO Route Sequence
Integer
ZIP_CODE
Address Zip
Char
5
ZIP_PLUS4
Zip Extension
Char
4
DPC
Blank
Char
2
STREET_NUMBER
Address House Number
Char
10
APARTMENT_NUMBER
Address Unit Number
Char
10
Unit type is not exported
BUILDING_NUMBER
Address Building
Char
10
STREET_NAME
Address Predirectional + Street Name+ Street Type+ Postdirectional
Char
50
CITY
Address City
Char
50
STATE
Address State
Char
2
LONGITUDE
Address Longitude
Char
11
LATITUDE
Address Latitude
Char
11
CENSUS_BLK
Blank
Char
20
TAP_HD_SUN
Carrier Route ID
Char
10
Burt Ad Route, Sunday
TAP_HD_DLY
Blank
Char
10
Burt Ad Route, Daily
SUB_HD_SUN
Y or N, based on whether occupant’s delivery schedule includes Sunday. This is determined by a conversion program.
Char
1
Y if Sunday subscriber; else N
SUB_HD_DLY
Same as field above, but for daily delivery. This is determined by a conversion program.
Char
1
Y if Daily subscriber; else N
TMC_TYPE
Blank
Char
1
Blank, optional
TMC_PROD
First character of TM product ID
Char
1
Blank, optional
TMC_EDITN
Blank
Char
4
Blank, optional
TMC_ZONE
5-digit Zip
Char
10
Primary Order Entry - Selection (Zip + directional)
SUB_ZIP
Blank
Char
1
Blank, optional
TMC_TG
Blank
Char
2
Blank, optional
TMC_ENTRY
Blank
Char
1
Blank, optional
SI_PRIZM
Blank
Char
2
Prizm demographic code
SI_1
Demographic answer (must modify to select demographic)
Char
2
User-defined selective
SI_2
Blank
Char
2
User-defined selective
Note: SI_2 - SI_15 can be changed to add additional demographics.
SI_3
Blank
Char
2
User-defined selective
SI_4
Blank
Char
2
User-defined selective
SI_5
Blank
Char
2
User-defined selective
SI_6
Blank
Char
2
User-defined selective
SI_7
Blank
Char
2
User-defined selective
SI_8
Blank
Char
2
User-defined selective
SI_9
Blank
Char
2
User-defined selective
SI_10
Blank
Char
2
User-defined selective
SI_11
Blank
Char
2
User-defined selective
SI_12
Blank
Char
2
User-defined selective
SI_13
Blank
Char
2
User-defined selective
SI_14
Blank
Char
2
User-defined selective
SI_15
Blank
Char
2
User-defined selective
Version
0 (zero)
Small int
Use to group address lists by effective date. Set to 0.