|
|
|
Field: Phone number types
|
|
Type
|
String
|
|
General Description
|
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 Group
|
Import phone number on user & answer sheet import job
|
|
Business Rules
|
- 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.
|
|
Auto mapping
|
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
|
|
Validation
|
- 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.
|
|
Notes
|
- For more information on importing country code please refer to the help file on Country.
|
