|
< back |
Submission of results
Once you have Mailsorted or Walksorted the Test Address List or tested for International Bulk Mail or International Destination Sort, you must submit the resulting Computer Planning Report, Line Listing and sorted Test Address List to the Mailsort Technical Department.
When submitting reports, please provide adequate contact information, indicate which Mailing Scheme you have used (e.g. Mailsort 1400, Mailsort 700 Mixed Weights etc. - see: Sorting the Test Address List), and in the case of Mailsort 1400, whether or not your software uses the Undersized Directs principle (NB: Undersized Directs are not applicable to Mailsort 700).
When submitting an International Bulk Mail test, please ensure that you also submit an Epro file for testing.
Please send your printable reports and electronic files by email to: mailsort@caci.co.uk. Your electronic files must be attached as plain text (ASCII) Comma Delimited files.
The Comma Delimited Format require all trailing spaces are removed from fields which are then enclosed in quotation marks and must be separated by commas; records must be terminated by Carriage Return (ASCII: 13) and Line Feed (ASCII: 10) characters.
Also, please do not include any descriptive records e.g. field/file headers. The validation process will attempt to test them as a valid record.
Once we have received your Computer Planning Report, Line Listing and sorted Test Address List we will compare these reports with our Reference Solution. We will then send you our report of any differences we find. Naturally we are not able to supply you with the information contained in our Reference Solution as this would undermine the testing process, but we are able to give pointers to assist you in diagnosing potential problems with your software. If possible we will draw your attention to specific selections on a Line Listing, which contain errors.
The accuracy of pricing information on Computer Planning reports is not taken into consideration for the evaluation of test submissions. However, you may wish to compare the prices generated by your software with those from the Mailsort Price Calculator.
Computer Planning Reports
The following table indicates all the fields and the order in which you MUST supply them for Mailsort 1400, Mailsort 1400 Mixed Weight, Mailsort 1400 Undersized Direct, Mailsort 1400 Undersized Direct Mixed Weight and Mailsort 120:
IMPORTANT NOTES:
Click here to download an example CPR file in plain text (ASCII) Comma Delimited format.
| Report Section | Field Name | Required? |
| General Information | Database Version | Yes |
| Mailsort Parameters | Mailsort Service | Yes |
| Minimum Selection Size | Yes | |
| Format | Yes | |
| Weight of Item (Average) | Yes | |
| Job Reference Number | Yes | |
| Presortation Statistics | Address Records Processed | Yes |
| Postcodes Matched | Yes | |
| Post Towns Matched | Yes | |
| Address Not Matched | Yes | |
| Number Suitable For Mailsort | Yes | |
| Postcode Statistics | Full Postcode - Eligible Items | Yes |
| Full Postcode - Eligible % | Yes | |
| Outward Postcode Only - Eligible Items | Yes | |
| Outward Postcode Only - Eligible % | Yes | |
| Postcode Level - Eligible Items | Yes | |
| Postcode Level - Eligible % | Yes | |
| No Postcode - Eligible Items | Yes | |
| No Postcode - Eligible % | Yes | |
| Sortation Statistics | Direct Selection - Number | Yes |
| Direct Selection - Total Items | Yes | |
| Direct Selection - % Match | Yes | |
| Direct Selection - Bags | Yes | |
| Residue Selection - Number | Yes | |
| Residue Selection - Total Items | Yes | |
| Residue Selection - % Match | Yes | |
| Residue Selection - Bags | Yes |
The following table indicates all the fields and the order in which you MUST supply them for Mailsort 700:
IMPORTANT NOTES:
Click here to download an example CPR file in plain text (ASCII) Comma Delimited format.
| Report Section | Field Name | Required? |
| General Information | Database Version | Yes |
| Mailsort Parameters | Mailsort Service | Yes |
| Minimum Selection Size | Yes | |
| Format | Yes | |
| Weight of Item (Average) | Yes | |
| Job Reference Number | Yes | |
| Presortation Statistics | Address Records Processed | Yes |
| Postcodes Matched | Yes | |
| Post Towns Matched | Yes | |
| Address Not Matched | Yes | |
| Number Suitable For Mailsort | Yes | |
| Postcode Statistics | Full Postcode - Eligible Items | Yes |
| Full Postcode - Eligible % | Yes | |
| Outward Postcode Only - Eligible Items | Yes | |
| Outward Postcode Only - Eligible % | Yes | |
| Postcode Level - Eligible Items | Yes | |
| Postcode Level - Eligible % | Yes | |
| No Postcode - Eligible Items | Yes | |
| No Postcode - Eligible % | Yes | |
| DPS Statistics | DPS Matched - Eligible Items | Yes |
| DPS Matched - Eligible % | Yes | |
| Default DPS Allocated - Eligible Items | Yes | |
| Default DPS Allocated - Eligible % | Yes | |
| No DPS - Eligible Items | Yes | |
| No DPS - Eligible % | Yes | |
| Sortation Statistics | Direct Selection - Number | Yes |
| Direct Selection - Total Items | Yes | |
| Direct Selection - % Match | Yes | |
| Direct Selection - Bags | Yes | |
| Residue Selection - Number | Yes | |
| Residue Selection - Total Items | Yes | |
| Residue Selection - % Match | Yes | |
| Residue Selection - Bags | Yes |
The following table indicates all the fields and the order in which you MUST supply them for Walksort and Walksort Mixed Weight:
IMPORTANT NOTES:
Click here to download an example CPR file in plain text (ASCII) Comma Delimited format.
| Report Section | Field Name | Required? |
| General Information | Database Version | Yes |
| Walksort Parameters | Walksort Service | Yes |
| Format | Yes | |
| Weight of Item (Average) | Yes | |
| Job Reference Number | Yes | |
| Presortation Statistics | Address Records Processed | Yes |
| Postcodes Matched to Walksort Code | Yes | |
| Postcodes Unmatched | Yes | |
| Penetration Statistics | Total Walks in Posting Area | Yes |
| Estimate Total Address (Walks X 375) | Yes | |
| Walksort Mailing Penetration % | Yes | |
| Sortation Statistics | Walk Selection - Number | Yes |
| Walk Selection - Total Items | Yes | |
| Walk Selection - % Match | Yes | |
| Walk Selection - Bags | Yes |
Line Listings
The following table indicates all the fields and the order in which you MUST supply them for Mailsort 1400, Mailsort 700 and Mailsort 120 Letters:
IMPORTANT NOTES:
Click here to download an example Line Listing file in plain text (ASCII) Comma Delimited format.
| Field Name | Required? |
| SSC | Yes |
| Selection Name | Yes |
| Total Items | Yes |
| Cumulative Items | Yes |
| Estimate Bags | Yes |
| Cumulative Bags | Yes |
The following table indicates all the fields and the order in which you MUST supply them for Mailsort 1400 Mixed Weight Large Letters and A3 Packets:
IMPORTANT NOTES:
Click here to download an example Line Listing file in plain text (ASCII) Comma Delimited format.
| Field Name | Required? |
| SSC | Yes |
| Selection Name | Yes |
| Total Items | Yes |
| Cumulative Items | Yes |
| Estimate Bags | Yes |
| Cumulative Bags | Yes |
| Items upto 100gms | Yes |
| Actual Weight | Yes |
| Assumed Weight | Yes |
| Items 101gms To 250gms | Yes |
| Actual Weight | Yes |
| Assumed Weight | Yes |
| Items 251gms To 750gms | Yes |
| Actual / Assumed Weight | Yes |
| Total Actual Weight | Yes |
| Total Assumed Weight | Yes |
The following table indicates all the fields and the order in which you MUST supply them for Mailsort 1400 Mixed Weight Packets:
IMPORTANT NOTES:
Click here to download an example Line Listing file in plain text (ASCII) Comma Delimited format.
| Field Name | Required? |
| SSC | Yes |
| Selection Name | Yes |
| Total Items | Yes |
| Cumulative Items | Yes |
| Estimate Bags | Yes |
| Cumulative Bags | Yes |
| Items upto 100gms | Yes |
| Actual Weight | Yes |
| Assumed Weight | Yes |
| Items 101gms To 250gms | Yes |
| Actual Weight | Yes |
| Assumed Weight | Yes |
| Items 251gms To 2000gms | Yes |
| Actual / Assumed Weight | Yes |
| Total Actual Weight | Yes |
| Total Assumed Weight | Yes |
The following table indicates all the fields and the order in which you MUST supply them for Walksort Letters:
IMPORTANT NOTES:
Click here to download an example Line Listing file in plain text (ASCII) Comma Delimited format.
| Field Name | Required? |
| Walkcode / SSC | Yes |
| Total Items | Yes |
| Cumulative Items | Yes |
| Estimate Bags * | Yes |
| Cumulative Bags * | Yes |
The following table indicates all the fields and the order in which you MUST supply them for Walksort Large Letters and A3 Packets:
IMPORTANT NOTES:
Click here to download an example Line Listing file in plain text (ASCII) Comma Delimited format.
| Field Name | Required? |
| Walkcode / SSC | Yes |
| Total Items | Yes |
| Cumulative Items | Yes |
| Estimate Bags * | Yes |
| Cumulative Bags * | Yes |
| Items upto 100gms * | Yes |
| Actual Weight * | Yes |
| Assumed Weight * | Yes |
| Items 101gms To 250gms * | Yes |
| Actual Weight * | Yes |
| Assumed Weight * | Yes |
| Items 251gms To 750gms * | Yes |
| Actual / Assumed Weight * | Yes |
| Total Actual Weight * | Yes |
| Total Assumed Weight * | Yes |
Mailsorted / Walksorted Test Address Lists
The following table indicates all the fields and the order in which you MUST supply them for Mailsort / Walksort Sorted Test Address List:
IMPORTANT NOTES:
Click here to download an example Mailsorted Test Address List file in plain text (ASCII) Comma Delimited format.
| Field Name | Required? |
| Name | Yes |
| Address 1 | Yes |
| Address 2 | Yes |
| Address 3 | Yes |
| Address 4 | Yes |
| Address 5 | Yes |
| Address 6 | Yes |
| Postcode | Yes |
| Delivery Point Suffix | Yes |
| Weight Indicator | Yes |
| Mailsort / Walksort Code | Yes |
| Please note that address label files which are preformatted for printing will not be suitable. |
| When submitting Mailsorted Address Lists for Mailsort 1400 or 700, please ensure that the Mailsort codes supplied are the 'final' codes applied. For example, if an item was successfully matched by Postcode to a Direct Selection yet was allocated to a Residue selection, you must supply the Residue Selection code rather than the Direct Selection code. |
| > next: Software suppliers list |