[ic] Interchange6 Shipping Draft

Sam Batschelet sbatschelet at mac.com
Sat Mar 8 15:58:03 UTC 2014

On Mar 8, 2014, at 10:26 AM, Lyn St George wrote:

> On 08/03/2014 14:58, Sam Batschelet wrote:
>> UPS
>> Royal Mail
>> Lyn thank you for providing the schema for each of these do you have information on obtaining the data to populate?
> Both UPS and now USPS provide xls files. For domestic US shipping the
> files will vary according to the originating zipcode. For UPS their zone
> file is an xls, but for USPS it's a web page. I just wrote little
> scripts to extract the data and put it into tables. I can give you the
> scripts if you like, though they're very rough :/ For the RoyalMail,
> they do everything they possibly can to make life difficult - you need
> to get their pdfs and copy rates by hand into a table (trying to
> automate the process and fix errors takes far longer than doing it by
> hand). Or you could pay stupid money for something that runs on windows
> and needs a mouse ... I will also dump the current tables into a tarball.

If you get a minute to dump that it would be great just so I can run some tests on the data.  Thanks a lot Lyn.


More information about the interchange-users mailing list