For licensing reasons, our shipping product tries to obtain UPS rate information without using the API. Most of this is reasonably straight-forward, but obtaining a complete set of zipcode-to-zipcode postal zones is a large hassle.
We're looking at the Worldship databases (with UPS's permission, but not support) for rate infromation, and most of the rate information is found in an Access file called RateEdit.mdb . However, the postal zone definitions seem to be in root-directory dat/idx files called rvzone* . Small sample (original is ~15MB):
/*File starts like this*/ ZONKWA ZONKWOA ZUNGERU zzzzzzzzzzzz /*rest of file is like this*/ US00400 00599 0670CAA0A0A0A9Z9Z90670001US01000 09999 0670CAA0A0A0A9Z9Z90670001US00400 00599 0670CAB0A0A0B9Z9Z90670001US01000 09999
Is this a parseable db language? and if so, how? (pseudo-code, any language)?