How to import phone numbers into GoldMine in Non-US format

Version 1

    Details

    When 10-digit values like '3655926549' are imported into the GoldMine Phone fields, they are converted to the US format and appear as (xxx)yyy-zzzz for example '(365)592-6549'  


    This article explains how these 10-digit values can be imported without any formatting


     


    Resolution

     

    GoldMine (GMPE 9.2.1.92 and higher) has by default Decipher phone format activated in the mapping properties for any kind of Phone field

     

     
    To import the 10-digit numbers in US-format, the Decipher phone format must be CHECKED (default) in the import profile for the mapping properties

    To Import 10-digit numbers as they are, the Decipher phone format must be UNCHECKED in the import profile for the mapping properties
     
    Sample scenario with full steps:
    NOTE: Full steps in assuming a proper dbf field is available and all preconditions for an import are already met.
     
    1. Tools > Import and Export > Import Contact Records
    2. Import a new File + DBF format 
    3. Select the DBF file
    4. Verify accuracy using the preview for several import records (e.g. toggle convert to OEM for accented characters if necessary)
    5. Map import fields to GoldMine fields as desired
    6. For desired phone numbers > map the field or highlight if already mapped > Properties button 
    7. At the bottom UNCHECK the Decipher phone format > OK

    We recommend that you toggle the preview for the import to show how the record from the import file will appear in GoldMine.
     
    8. Save the import profile if desired and import the records
    9. Verify imported records 

    NOTE: The Decipher phone format option does not have any influence on the CONTACT1.STATUS field.  Therefore please check that the Phone format (Edit > Record Properties > Record related settings > Phone formatting tab) is set to Non-US format/International format after importing the records. Like the CONTACT1.STATUS field, the Decipher phone format option does not have any influence on how the Phone fields are viewed in GoldMine.