[ic] Interchange6 Shipping Draft

Lyn St George lyn at zolotek.net
Sat Mar 8 15:26:17 UTC 2014


On 08/03/2014 14:58, Sam Batschelet wrote:
> UPS
> USPS
> 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.



More information about the interchange-users mailing list