[ic] Interchange6 Shipping Draft
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:
>> 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