| Updating State based on ZIP | |
Posted: Thu Oct 11, 2007 10:46 am |
Points: 0 |
|
jrehm |
Obsessive GoldMiner |
|
|
Joined: 21 Nov 2006 |
Posts: 141 |
|
|
|
|
|
|
|
|
Is there any 3rd party stuff out there that I can update the state field based on the zip code? Had a customer mistakenly do a global replace on their state field, but the zips are good. No backup of course. |
|
|
|
|
Posted: Thu Oct 11, 2007 11:03 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
If you have a reasonably good Zip database, GoldBox has a way to do it. It's a 2-step process:
1. Import the Zip data into GoldBox's own table for that data (you may want to purge the existing data in that table, if it's questionable); then
2. Do a GoldBox Global Replace on the State field, using the GetState() function that GoldBox has. |
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
Posted: Thu Oct 11, 2007 2:08 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
|
|
|
|
ContactReview Forum Index » GoldMine 6
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|