Sometimes (especially if you were using an old version of GoldMIne several years back) you may have some of your Contact Records set to US Phone format - the phone numbers will look okay on the screen, but if you then link to any dialer like TapiLink, the system may not work correctly. Normally all your Contact Records, if you work outside the US, will be formatted to International Phone format. This is the procedure to change all your records, so they all have the same consistent format.
To Globally replace all records to the International formatting please do the following:
- Backup your GoldMine Database/s
- Select Tools | Database Management | Global Replace | Update a field using advanced options.
In the Global replace wizard:
- Choose to replace the field Status (Note: This field will appear on the list after your key 5 field).
- Select 'Evaluate value as dBase Expression'.
- In the expression box cut and paste the following expression:
"I"+substr(contact1->status,2,2)
- Click Next | Click Next.
- Pick a filter if you only want to replace some of you records, otherwise leave on all contact records.
- Click Next | Click Finish.
Comments