Field: Phone number types



Field: Phone number types

Field: Phone number types
String
There exists 13 ‘phone number’ types that appear in the Import Phone Number section. These 13 work in exactly the same way so they will all be explained in this help file. The 13 types are: Phone number not identified, Phone number home 1, Phone number home 2, Phone number mobile 1, Phone number mobile 2, Phone number business 1, Phone number business 2, Fax number home fax, Fax number business fax, Phone number main 1, Phone number main 2, Fax number 1, Fax number 2.
Import phone number on user & answer sheet import job
Catglobe does not separate fax numbers from phone numbers in the business rules it applies. One phone number type is unique for one user. If importing a phone number type for an existing user, any existing number of that type will be overwritten. To update this field for an existing user, you must select a User_Id column in step 1 of the import wizard. The value in this column will be used to determine which user’s record to update If user choose to import phone number information, there will appear a drop down list and user could choose a source column (on excel file) which will be used as country code for imported user's phone number. Phone numbers are always imported along with a country code. There are three ways that this country code can be established. The first way, if source phone number value starts with “+”, it will consider that this value includes country_code already. The second way, if the source phone number value doesn't start with “+”. Country code will be file in source country column which is mapped in step 2. The last one, If you do not select a country code in the drop down list or source value is blank, the system will look up the ‘DefaultCountryCodeForImportedUsers’ setting, as described in the ‘web.config’ help file, as the country code of the imported user's phone number. -Importing an empty string means that any number which may exist for the user will be kept. If you instead wish any existing number to be erased then insert "#ERASE" into the field.
In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown: UK: PhoneType_NotIdentified PhoneType_Home1 PhoneType_Home2 PhoneType_Mobile1 PhoneType_Mobile2 PhoneType_Business1 PhoneType_Business2 PhoneType_HomeFax PhoneType_BusinessFax PhoneType_Main1 PhoneType_Main2 PhoneType_Fax1 PhoneType_Fax2 DK: Bruger_Brugernavn TelefonType_IkkeIdentificeret TelefonType_Hjemme1 TelefonType_Hjemme2 TelefonType_Mobil1 TelefonType_Mobil2 TelefonType_Arbejde1 TelefonType_Arbejde2 TelefonType_Fax(Hjemme) TelefonType_Fax(Arbejde) TelefonType_Hovednummer1 TelefonType_Hovednummer2 TelefonType_Fax1 TelefonType_Fax2
Country code must be in the range of available values in table Country in database. If country code is not in the legal values, error message will be shown on the correct line to let the system user know. Error type: ERROR (the import job will not be allowed to be executed). An extensive phone number formatting logic has been implemented from version 5.4. To read more on how phone number formats are validated compared to the country they come from please click here
For more information on importing country code please refer to the help file on Country.