mass2one Export Format
Note: The mass2one interface requires a separate license fee to use. Contact the Naviga Support Center for details.
File type: tab-delimited.
Location: /dti/exchange/cm
. The file name is user-defined.
Field | Description | Format |
---|---|---|
Subscriber ID | Subscriber’s account ID. Blank for non-subscribers. | 9999999999 |
Occupant ID | Subscriber’s occupant ID. | 9999999999 |
Product ID | Subscriber’s product. Blank for non-subscribers. | x(8) |
First Name | Occupant’s first name | x(12) |
Last Name | Occupant’s last name | x(30) |
Address Line 1 | House number, street name, street type and any pre-directional or post directional | x(30) |
Address Line 2 | Unit designator and unit number | x(30) |
City | Occupant’s city | x(28) |
State | Occupant’s state or province ID | x(2) |
ZIP Code | Occupant’s ZIP, including ZIP extension | 99999-9999 |
Phone | Occupant’s phone, including area code | 999-999-9999 |
House # | Occupant’s address information | x(10) |
House # Modifier | Occupant’s address information | x(3) |
Predirectional | Occupant’s address information | x(2) |
Street Name | Occupant’s address information | x(28) |
Street Suffix | Occupant’s address information | x(7) |
Post Directional | Occupant’s address information | x(2) |
Unit Type | Occupant’s address information | x(6) |
Unit Number | Occupant’s address information | x(8) |
Latitude | Occupant’s address information | 999.999999 |
Longitude | Occupant’s address information | 999.999999 |
PO route Type | Occupant’s address information | x |
PO Route Number | Occupant’s address information | 999 |
PO Route Sequence | Occupant’s address information | 99999 |
Email Address | Occupant’s e-mail | unlimited |
Subscriber Status | Occupant’s subscriber status: active, former, never or temp stopped | x(30) |
Delivery Schedule | Subscriber’s delivery schedule (blank for non-subscribers) | x(8) |
Start Date | Date of subscriber’s current (last) start date (blank for non-subscribers) | 99/99/9999 |
Expire Date | Current expire date for office pay subscribers (blank for all other occupants) | 99/99/9999 |
Original Start Date | Date of subscriber’s original start (blank for non-subscribers) | 99/99/9999 |
Start Source Code | Source code for current start (blank for non-subscribers) | x(8) |
Start Reason Code | Reason code for current start (blank for non-subscribers) | x(8) |
Payment Type | Payment method for active or temp stopped subscribers (blank for non-subscribers or former subscribers). Possible values are: office pay, carrier collect, auto pay bank draft, auto pay credit card, Auto Pay PayPal, paid complimentary, unpaid complimentary | x(20) |
Route (7 fields) | Occupant’s route ID for each day of the week, or “mail” if mail-delivered | x(8) |
Billing Method | Billing method for active or temp stopped subscribers (blank for non-subscribers or former subscribers). Possible values are: office pay, carrier collect, paid complimentary, unpaid complimentary | x(20) |
Last Complaint Date | Date of occupant’s last complaint | 99/99/9999 |
Last Complaint Reason | Reason code of occupant’s last complaint | x(8) |
Perm Stop Date | Last perm stop date for former subscribers (blank for all others) | 99/99/9999 |
Perm Stop Source | Source code for the perm stop. | x(8) |
Perm Stop Reason | Reason code for former subscriber’s last perm stop (blank for all others) | x(8) |
Temp Stop Date | If temp stopped, stop date for current temp stop (blank for all others) | 99/99/9999 |
Temp Stop Source | Source code for the temp stop. | x(8) |
Temp Stop Reason | If temp stopped, reason code for current temp stop (blank for all others) | x(8) |
Restart Date | If temp stopped, restart date for current temp stop, if known (blank for all others) | 99/99/9999 |
Last Payment Length and Term | If office pay, payment length and term of last payment (blank for all others) | x(12) |
Last Payment Date | If office pay, date of last payment (blank for all others) | 99/99/9999 |
Rate Code ID | Subscriber’s rate code. | x(20) |
“Do not Email” Indicator | If the occupant is assigned a solicitation code entered for the export, this will be set to “yes”; otherwise, “no” | yes/no |
Last updated