I am importing a constituent record with the normal information, however we want to add in the county and region based upon the zipcode. Is there a way to do this using virtual fields and/or dictionaries?
Thank you in advance.
After you've built the dictionary, you can then add two virtual fields for the county and the region. You'll use the Copy Field function on these virtual fields. The Seed will be the column that contains the zip code. Then apply the dictionary that you built on both virtual fields.
Of course, keep in mind that ZIP codes can cross county, or even state lines: http://en.wikipedia.org/wiki/ZIP_co...e_Prefixes
It is on the ImportOmatic roadmap to expand the Omatic Data Service (ODS) address standardization service to be able to also supply county for the exact address. If you haven't tried the ODS yet, you should give it a shot. You get 3,000 rows for free and it will significantly improve your duplicate search results (with name variations like "Robert", "Bob", "Robbie" and address variants) even if you're not using it to reformat your addresses.
Jeff - if I enable ODS in Address options, would it be able to convert a ZIP code to city and state? I'm importing sign-ups without an address line/city/state, just the ZIP, and would like to auto-add the city and state.