|
 Resources
How to Upload Files in PrecisionTrack
If Trackmymail is encoding your file, it will be necessary to upload a file to us and receive an encoded file in return. Even if you are using tracking id ranges to create your own IMB’s, uploading certain data to the job allows us to enhance the reporting for your mailing. For example, you can upload names, account numbers and other look-up criteria to be used for looking up a single record online, or to be included in emailed reports that will include each of your records along with information about in-home dates.
Please choose from the following: (these will be links and jump to the detailed information below)
Option 1-I am tracking every piece of my mailing and would like for Trackmymail to process and encode the file to obtain my Intelligent Mail Barcodes. (Recommended)
Option 2-I am tracking every piece of my mailing and would prefer to download a range of numbers to create my own IMB.
Option 3- I am only tracking a SAMPLING of my mailing and will use my software to encode the file and create my Intelligent Mail Barcodes.
If Trackmymail is appending your IMB’s you are required to upload a file so that it can be encoded. Your file can be uploaded either when you are prompted during the job creation process or later by selecting the Uploads tab located at the top of the job summary page.
Upload File Format
Files being uploaded for IMB barcodes should appear in the format specified below. Field sizes shown are the maximum field size accepted. The columns must be either tab or comma delimited (.txt or csv). Fixed formatted files will not be accepted.
You have an option of providing Fields 1 and 2 only OR utilizing the additional fields such as name, address, etc., which will then be available for viewing in our single piece report.
If you opt to populate any field beyond field 2, please note that optional fields (through Field 20) must be represented, even if they are not populated. You may use headers in your uploaded file.
| Column |
Type |
Max Size |
Required/Optional |
| Customer Unique Identifier |
Alpha/Num |
20 |
Required |
| Postnet |
Numeric |
11 |
Recommended* |
| IMB (left 20 chars, excludes postnet) |
Numeric |
20 |
Reserved (Blank if TMM is performing file encoding) |
| Greeting |
Alpha/Num |
10 |
Optional |
| First Name |
Alpha |
50 |
Optional |
| Middle Initial |
Alpha |
2 |
Optional |
| Last Name |
Alpha |
50 |
Optional |
| Suffix |
Alpha |
10 |
Optional |
| Full Name |
Alpha |
100 |
Optional |
| Company |
Alpha |
50 |
Optional |
| Title |
Alpha |
50 |
Optional |
| Address 1 |
Alpha/Num |
128 |
Optional |
| Address 2 |
Alpha/Num |
128 |
Optional |
| City |
Alpha |
50 |
Optional |
| State |
Alpha |
2 |
Optional |
| Zip |
Numeric |
10 |
Optional |
| User Defined 1 |
Alpha/Num |
100 |
Optional |
| User Defined 2 |
Alpha/Num |
100 |
Optional |
| User Defined 3 |
Alpha/Num |
100 |
Optional |
| TMM-JobId |
Numeric |
8 |
Optional * Required for separate FTP uploads only |
* Records that are uploaded without a value in the Postnet field will not be included in any reports driven by ZIP (i.e. State, ZIP3, ZIP5, etc). This will result in the reports appearing to be out of balance.
The Customer Unique Identifier in the upload file is defined by you. It will be included in your download file and used to map the appended IMB information back to your record.
The Postnet must be 5, 9, or 11 digits. Do not include check digits.
Option A – uploading only 2 fields
| Customer Unique Identifier | Postnet |
| 8344382851 | 37027271155 |
| 8344382852 | 20879150941 |
| 8344382789 | 46750395920 |
| 8344382612 | 606041424 |
| 8344382853 | 468081226 |
Option B – Uploading with additional fields
Click here to see a sample file.
Uploading the File
- Create a tab-delimited or Comma delimited file as specified.
- Save your file locally as a .txt or .csv file.
- Click on the "Uploads" tab in your account, and select the job name from the drop down list of jobs
- Browse for your file and select it.
- Enter the email address where all email notifications for file uploads and the encoded file downloads will be sent
- Click the Upload File button at the bottom of the screen.
- Your upload is complete.
- -IMPORTANT- You may revise this data at any time by uploading a modified file and selecting the replace option. This will replace the existing information.
You will receive an email from customerservice@trackmymail.com after you upload your file. This will indicate a successful upload, or notify you of any problem. When the encoding process is complete you will receive a second email with a link to your encoded file.
The file returned will be in a tab-delimited format as follows.
| CustomerUniqueIdentifier |
OneCode |
EncodedOneCode |
| 0000000008344382851 |
0004000080300424830839370765229 |
FFDATTADDAAFAFDDFDTDTFADAFTTAFADTDDTAFFTAFFFFFDAFAFTFDAATTAFDTFFFT |
| 0000000008344382851 |
0004000080300864597439370278189 |
TDATDAFATAAFFTFADDTAAATDFDDTFTADDDTTAAFDTFTFDADDFAFADDFFTDATDDFFT |
| 0000000008344382789 |
0004000080300864597539467508524 |
FTTADFDDAFTADDFTTDDTATATTTFDADDAAAADTADFFTADATATDAAATADDTFTAFDAAT |
The completed IMB files can be obtained by clicking on the link to the encoded file you receive via email notification. You must be logged into your account in order to retrieve the file.
To Retrieve:
- Sign into your PrecisionTrack account
- Click on the link in your email notification
- You will be directed to the download screen where your encoded file is available as a compressed (.zip) file or as a .txt file
- Right-click on the link for the file type you would like to download and choose “Save-As”
- Save the file locally
The encoded file format is specified below. Field sizes are the maximum field size allowed.
| Column |
Type |
Max Size |
| CustomerUniqueIdentifier |
Alpha |
20 |
| Intelligent Mail Barcode |
Numeric |
31 |
| BarcodeId |
Numeric |
2 |
| SvcTypeId |
Numeric |
3 |
| SubscriberId |
Numeric |
6 |
| TrackingId |
Numeric |
9 |
| Postnet |
Numeric |
11 |
| Encoded IMB |
Char |
65 |
If you need assistance, please contact Customer Service at 888-444-9972, ext 1043 or customerservice@trackmymail.com
Please use this link to Print or Save instructions.
We provide you with the following to use on each piece of the mailing:
1. Barcode ID
2. Service ID
3. Mailer ID
4. Tracking ID range
The tracking ID range can be downloaded directly from your job information page once you have entered your job.
To upload a Mailing Detail Data file for Option 2:
Upload File Format:
Mailing detail files being uploaded for IMBs should appear in the format specified below. Field sizes shown are the maximum field size accepted. The columns must be either tab or comma delimited (.txt or csv). Fixed formatted files will not be accepted.
The file provided must have 20 fields. Fields 1-3 must be populated. Additional fields such as name, address, etc., can be utilized to enhance the reporting available the single piece report.
Please note that optional fields (through Field 20) must be represented, even if they are not populated. You may use headers in your uploaded file.
| Column |
Type |
Max Size |
Required/Optional |
| Customer Unique Identifier |
Alpha/Num |
20 |
Required |
| Postnet |
Numeric |
11 |
Recommended* |
| IMB (left 20 chars, excludes postnet) |
Numeric |
20 |
Reserved (Blank if TMM is performing file encoding) |
| Greeting |
Alpha/Num |
10 |
Optional |
| First Name |
Alpha |
50 |
Optional |
| Middle Initial |
Alpha |
2 |
Optional |
| Last Name |
Alpha |
50 |
Optional |
| Suffix |
Alpha |
10 |
Optional |
| Full Name |
Alpha |
100 |
Optional |
| Company |
Alpha |
50 |
Optional |
| Title |
Alpha |
50 |
Optional |
| Address 1 |
Alpha/Num |
128 |
Optional |
| Address 2 |
Alpha/Num |
128 |
Optional |
| City |
Alpha |
50 |
Optional |
| State |
Alpha |
2 |
Optional |
| Zip |
Numeric |
10 |
Optional |
| User Defined 1 |
Alpha/Num |
100 |
Optional |
| User Defined 2 |
Alpha/Num |
100 |
Optional |
| User Defined 3 |
Alpha/Num |
100 |
Optional |
| TMM-JobId |
Numeric |
8 |
Optional * Required for separate FTP uploads only |
* Records that are uploaded without a value in the Postnet field will not be included in any reports driven by ZIP (i.e. State, ZIP3, ZIP5, etc). This will result in the reports appearing to be out of balance.
The Customer Unique Identifier in the upload file is defined by you, and will be used to map the appended IMB information back to your record
The Postnet must be 5, 9, or 11 digits, Check digits are not included. Do not pad with 0’s.
Click here to see a sample file:
Uploaded data (simple format).
Uploaded data extended format with mailing detail data.
Uploading the File
- Create a tab-delimited or Comma delimited file as specified.
- Save your file locally as a .txt or .csv file.
- Click on the "Uploads" tab in your account, and select the job name from the drop down list of jobs
- Browse for your file and select it.
- Enter the email address where all email notifications for file uploads
- Select DO NOT Encode File
- Click the Upload File button at the bottom of the screen.
- Your upload is complete.
- -IMPORTANT- You may revise this data at any time by uploading a modified file and selecting the replace option. This will replace the existing information.
You will receive an email from customerservice@trackmymail.com after you upload your file. This will indicate a successful upload, or notify you of any problem.
If you need assistance, please contact Customer Service at 888-444-9972, ext 1043 or customerservice@trackmymail.com.
Please use this link to Print or Save instructions.
We provide you with the following to use on each piece of the mailing:
1. Barcode ID
2. Service ID
3. Mailer ID
4. Tracking ID range
You will generate the Intelligent Mail Barcode values for all non-tracked mail pieces. Please keep in mind when creating your non-tracking Intelligent Mail Barcodes that trackmymail's Confirm Subscriber ID (or Mailer ID) can not be used. You will use your own Mailer ID number instead. The Mailer ID (also called MID or Mailer Identifier) is a 6-digit or 9-digit number that identifies you as a mailer.
Example breakdown: IMB for a First Class letter of a tracked piece (with Tracking ID assigned by trackmymail.com) :
| 00 |
040 |
000803 |
007248308 |
39370765229 |
| Barcode ID |
Service ID |
Trackmymail Mailer ID |
Tracking ID |
Postnet |
Example breakdown: IMB for a non-tracked piece (Standard Mail):
| 00 |
702 |
000001 |
000000000 |
39370765229 |
| Barcode ID |
Service ID |
Your Mailer ID |
Tracking ID |
Postnet |
Note: trackmymail recommends tracking each piece in your mailing. If sampling is required, it is the mailers ultimate responsibility to adhere to the Intelligent Mail Barcode requirements for non-tracked pieces. Please refer to https://ribbs.usps.gov for detailed specifications and requirements.
To upload a Mailing Detail Data file (tracked pieces only)
Upload File Format
Mailing detail files being uploaded for IMBs should appear in the format specified below. Field sizes shown are the maximum field size accepted. The columns must be either tab or comma delimited (.txt or csv). Fixed formatted files will not be accepted.
The file provided must have 20 fields. Fields 1-3 must be populated. The additional fields such as name, address, etc., can be utilized to enhance the reporting available the single piece report.
Please note that optional fields (through Field 20) must be represented, even if they are not populated. You may use headers in your uploaded file.
| Column |
Type |
Max Size |
Required/Optional |
| Customer Unique Identifier |
Alpha/Num |
20 |
Required |
| Postnet |
Numeric |
11 |
Recommended* |
| IMB (left 20 chars, excludes postnet) |
Numeric |
20 |
Reserved (Blank if TMM is performing file encoding) |
| Greeting |
Alpha/Num |
10 |
Optional |
| First Name |
Alpha |
50 |
Optional |
| Middle Initial |
Alpha |
2 |
Optional |
| Last Name |
Alpha |
50 |
Optional |
| Suffix |
Alpha |
10 |
Optional |
| Full Name |
Alpha |
100 |
Optional |
| Company |
Alpha |
50 |
Optional |
| Title |
Alpha |
50 |
Optional |
| Address 1 |
Alpha |
128 |
Optional |
| Address 2 |
Alpha |
128 |
Optional |
| City |
Alpha |
50 |
Optional |
| State |
Alpha |
2 |
Optional |
| Zip |
Numeric |
10 |
Optional |
| User Defined 1 |
Alpha/Num |
100 |
Optional |
| User Defined 2 |
Alpha/Num |
100 |
Optional |
| User Defined 3 |
Alpha/Num |
100 |
Optional |
| TMM-JobId |
Numeric |
8 |
Optional * Required for separate FTP uploads only |
* Records that are uploaded without a value in the Postnet field will not be included in any reports driven by ZIP (i.e. State, ZIP3, ZIP5, etc). This will result in the reports appearing to be out of balance.
The Customer Unique Identifier is defined by you. Use a unique number that you will recognize for each record like a customer or account number.
The Postnet must be 5, 9, or 11 digits. Check digits are not included. Do not pad with zero’s.
Click here to see a sample file:
Uploaded data (simple format).
Uploaded data extended format with mailing detail data.
Uploading the File
- Create a tab-delimited or Comma delimited file as specified.
- Save your file locally as a .txt or .csv file.
- Click on the "Uploads" tab in your account, and select the job name from the drop down list of jobs
- Browse for your file and select it.
- Enter the email address where all email notifications for file uploads
- Select DO NOT Encode File
- Click the Upload File button at the bottom of the screen.
- Your upload is complete.
- -IMPORTANT- You may revise this data at any time by uploading a modified file and selecting the replace option. This will replace the existing information.
You will receive an email from customerservice@trackmymail.com after you upload your file. This will indicate a successful upload, or notify you of any problem.
If you need assistance, please contact Customer Service at 888-444-9972, ext 1043 or customerservice@trackmymail.com.
Please use this link to Print or Save instructions.
|