Changing the Format of Telephone Numbers in intelli-CTi for Infor CRM (Saleslogix)

Outline

Telephone numbers in intelli-CTi are managed by a system called intelli-TNS (Telephone Number System). To provide accurate dialling and callerID lookups intelli-TNS stores its telephone numbers in its own database tables, separately from the Account/Contact records in Infor CRM (Saleslogix). It also keeps the Account and Contact database tables updated with any changes made.

intelli-CTi uses the intelli-TNS data when dialling numbers, looking up callers and displaying telephone numbers on the screen.

Other processes that are unaware of intelli-TNS continue to use the telephone numbers stored in the Infor CRM (Saleslogix) Account and Contact tables. This applies to reports, Outlook/Blackberry synchronisation etc.

Changing the format of telephone numbers

To change the format, open up the Infor CRM (Saleslogix) LAN Client and go to the menu Tools=>Manage=>intelli-TNS System Settings. This will display a new window. In that window, choose the TNS Country Settings tab and click the Manage Countries button.

In this window you can change the telephone number format for each country using the fields shown below:

You can change the way that the telephone number area code and main number are formatted. You can also decide whether to display the country code with the telephone number.

There are separate options for whether to:

a) Display Country Code

  • This affects intelli-TNS and any applications that are aware of the telephone numbers stored in the intelli-TNS database tables.
  • intelli-TNS telephone numbers are formatted at run-time so if you change this setting it will take effect immediately.

b) Record Country Code in the Account/Contact

  • This affects the telephone numbers that are put into the Infor CRM (Saleslogix) Account and Contact tables. This is used by any application that is not aware of intelli-TNS.
  • These telephone numbers are formatted when they are created or edited. If you change this setting, it only applies to telephone numbers that are subsequently created or edited. It does not apply to any of the existing numbers in the database until they are edited.
  • If you want to force existing telephone numbers to be updated, see the following section.

Forcing format changes into the Infor CRM (Saleslogix) Account/Contact tables

When you change the format of telephone numbers, these changes take effect immediately for numbers displayed on the Account and Contact forms because these are formatted by intelli-TNS at run-time.

Other uses of telephone numbers e.g. reports, Outlook/Blackberry synchronisation etc. are likely to use the numbers stored in the Infor CRM (Saleslogix) Account and Contact tables. These are only updated when the telephone number is created or edited so you might wish to force the format change into the Account and Contact tables for existing numbers.

IMPORTANT NOTE 1: Before you do this, you should take note that every Account or Contact telephone number that is updated and its matching intelli-TNS record will need to be synchronised out to remote users. This could create a large amount of synchronisation traffic that is likely to impact the end user.

IMPORTANT NOTE 2: The process involves making batch updates to your data. You should make sure that you have a valid and recent backup of your system before you proceed.

To force the format change into the Account and Contact records you should:

1)  Run some SQL to make intelli-TNS think that the telephone number has changed. The following is an example that will force changes for all telephone numbers for the USA.

DECLARE @countryIso char(3)
 SET @countryIso = 'USA'
 UPDATE P SET SYNCREF_WORK = 'recreate' FROM QGTNS_CONTACTPROFILE P
 INNER JOIN QGTNS_CONTACT C ON (C.QGTNS_CONTACTID = P.TNSID_WORK AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_HOME = 'recreate' FROM QGTNS_CONTACTPROFILE P
 INNER JOIN QGTNS_CONTACT C ON (C.QGTNS_CONTACTID = P.TNSID_HOME AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_MOBILE = 'recreate' FROM QGTNS_CONTACTPROFILE P
 INNER JOIN QGTNS_CONTACT C ON (C.QGTNS_CONTACTID = P.TNSID_MOBILE AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_PAGER = 'recreate' FROM QGTNS_CONTACTPROFILE P
 INNER JOIN QGTNS_CONTACT C ON (C.QGTNS_CONTACTID = P.TNSID_PAGER AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_OTHER1 = 'recreate' FROM QGTNS_CONTACTPROFILE P
 INNER JOIN QGTNS_CONTACT C ON (C.QGTNS_CONTACTID = P.TNSID_OTHER1 AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_FAX = 'recreate' FROM QGTNS_CONTACTPROFILE P
 INNER JOIN QGTNS_CONTACT C ON (C.QGTNS_CONTACTID = P.TNSID_FAX AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_MAIN = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_MAIN AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_ALTERNATE = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_ALTERNATE AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_TOLLFREE1 = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_TOLLFREE1 AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_TOLLFREE2 = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_TOLLFREE2 AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_OTHER1 = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_OTHER1 AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_OTHER2 = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_OTHER2 AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_OTHER3 = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_OTHER3 AND C.COUNTRYISOCODE = @countryIso)
 UPDATE P SET SYNCREF_FAX = 'recreate' FROM QGTNS_ACCOUNTPROFILE P
 INNER JOIN QGTNS_ACCOUNT C ON (C.QGTNS_ACCOUNTID = P.TNSID_FAX AND C.COUNTRYISOCODE = @countryIso)

2)  Log out of Infor CRM (Saleslogix). This is important because intelli-TNS caches the country information so might use a cached version of the format instead of the new version.

3)  Run the intelli-TNS Number Migration Wizard from the menu Tools=>Manage=>intelli-TNS System Settings=>Migration=>intelli-TNS Number Migration.

 Related Resources:
Further Information:


See the intelli-CTi Help Center User Guidelines for important considerations of use.