- Print
- DarkLight
- PDF
How to Mass Update Address standardization in FIMS
Article summary
Did you find this summary helpful?
Thank you for your feedback
How to Mass Update Address standardization in FIMS
Answer:
Mass updating address standardization in FIMS will involve exporting the information you wish to change, bringing it into excel to modify and then importing it back into FIMS.
You will do this using the Address Update Utility found on the file maintenance\profiles menu. This utility works similar to other import utilities except that this one will update existing records, not create new ones.
For example, suppose you want to change all Street's to St.'s. First run the user defined profile export, the export to word processing export, or export the data from a data grid.
Make sure you include the profile id in the data exported. Then open the resulting export file in excel and using the search and replace feature (or some other favorite method) , change all the records you want changed.
Use the Address Update utility to bring the changes back into the profile module.
You will do this using the Address Update Utility found on the file maintenance\profiles menu. This utility works similar to other import utilities except that this one will update existing records, not create new ones.
For example, suppose you want to change all Street's to St.'s. First run the user defined profile export, the export to word processing export, or export the data from a data grid.
Make sure you include the profile id in the data exported. Then open the resulting export file in excel and using the search and replace feature (or some other favorite method) , change all the records you want changed.
Use the Address Update utility to bring the changes back into the profile module.
Was this article helpful?