- Print
- DarkLight
- PDF
How do I change it so that the phone numbers are in same format?
Article summary
Did you find this summary helpful?
Thank you for your feedback
Some people have entered phone numbers with dashes, some with periods. We want them all to be consistent. Can we do this?
Answer:
The tool for changing all the phone numbers to have the same format can be found in Tools > System Utilities > Admin Utilities > Profile Utilities > Format phone numbers
When running this tool you will select the format from the above screen.
After clicking Apply, the tool will display the following list of numbers it will examine and after clicking OK, will process the data and attempt to change the phone numbers to the selected format.
It removes all non-numeric data and then attempts to reformat it. If there aren't enough numbers ( or too many) or there is some other problem it will not change the data. You will get a series of message screens and finally a list of tables and the records in each table that could not be converted. You will have to manually change those records. Typically the phone numbers had invalid data such as
- GrantNum:20080001 contactphone:603-555-55555
- GrantNum:960025 contactphone:23907423098
- Relator-ID: 1158 granteephone:23907423098
- IDCode:a-b cell-phone:cell
If the Profile module was open when the tool was run, you must close it and re-open it to see the changes.
Was this article helpful?