Mobile Number Parser Configuration
- Enterprise IT
- Mayuresh Balaji Kamble (Unlicensed)
Overview
Different organizations follow different ways of storing the employee mobile numbers in the employee database such as AD, HR Management systems etc. Moreover, different countries have different mobile number formats.
If the mobile number formats are incorrect, then the end users may not receive the SMS from SummitAI application thereby leading to operational issues. To overcome this problem, SummitAI is introducing a Mobile Number parser that would help to convert unstructured number formats to structured number formats, given that the parsing logic is accurately defined.
What is Mobile Number Parser?
Mobile Number Parser is a software component that takes input data (mobile numbers) and builds a data structure, this enables you to convert the unstructured mobile number to a structured mobile number by eliminating the difficulty involved in sending an SMS to a mobile number. Due to availability of various mobile number formats of the users across organizations create hassle when sending messages. To overcome this, you can use the Mobile Number Parser in SummitAI.
To further understand how the mobile number parser works, let us consider the following example:
Let us take mobile numbers of various countries with its country codes:
Types | |
Type 1 (India) | The Mobile Number is present along with country code. Ex: 919845xxxxx0 |
Type 2 (India) | The Mobile Number is present without country code. Ex: 9845xxxxx0 |
Type 3 (Singapore) | The Mobile Number is present with hyphen. 135-5xx7 |
Type 4 (America) | The Mobile Number is present with country code in braces. Ex: (555) 555-xxxx |
We can see that the mobile numbers are of different format. You can specify the conditions for the Mobile Number to parse the numbers, this converts the unstructured format of the mobile number to a structured format.
Case 1: Mobile Number Format = +91-9845xxxxx0
How to define the parsing logic for this format?
- Condition:
- Mobile Number Starts with “+” character
- Mobile Number Equals to “12” Characters
- Parsing Rules:
- Between Preceding & Succeeding: The preceding value is "+" and succeeding is "-". The value between these are identified as Country Code.
- After Focus Character: The Focus Character value is "-" and the of character after focus Character is “10”. The last 10 values are identified as mobile number.
- Field Mapping: Map the User-Defined Key value to Standard Field to identify the Country Code, State Code and Mobile Number stored in the User Master.
Note:
- By specifying the conditions, parsing and mapping requirements, the Mobile Number +91-9845xxxxx0 is parsed and categorizes "91" as Country Code and "9845xxxxx0" as Mobile Number.
- Based on your mobile number format you can specify the parsing parameters and use them to send SMS notification.
- The Parser will convert the mobile number in a structured format and send the SMS during the runtime.
Case 2: Mobile Number Format = 919845xxxxx0
How to define the parsing logic for this format?
- Condition:
- Mobile Number Does not contain “+” character
- Mobile Number Does not contain “&” character
- Parsing Rules:
- First Few Characters: The First value is "2". The first two values are identified as Country Code.
- Last Few Characters: The Last value is "10". The last 10 values are identified as mobile number.
- Field Mapping: Map the User-Defined Key value to Standard Field to identify the Country Code, State Code and Mobile Number stored in the User Master.
Case 3: Mobile Number Format = (91)9845xxxxx0
How to define the parsing logic for this format?
- Condition:
- Mobile Number Greater Than “10” characters
- Mobile Number Starts with “(“
- Mobile Number Equals to “12” Characters
- Parsing Rules:
- Before Focus Character: The Focus Character value is ")" and the of character before focus Character is 2. The first two values before “)” are identified as Country Code.
- Last Few Characters: The Last value is "10". The last 10 values are identified as mobile number.
- Field Mapping: Map the User-Defined Key value to Standard Field to identify the Country Code, State Code and Mobile Number stored in the User Master.
Benefits
Following are the benefits of using the Mobile Number Parser feature:
- Eliminates the troubleshooting time.
- On time notification due to accurately defined parser logic.
To configure Mobile Number Parser Rule:
Select Admin > Advanced > Notification > Mobile Number Parser Configuration.
On the MOBILE NUMBER PARSER CONFIGURATION page, click ADD NEW on the ACTIONS panel. The following page is displayed.
Figure: MOBILE NUMBER PARSER CONFIGURATION pageSpecify the required details to configure a Mobile Number Parser Rule. For more information about fields on the MOBILE NUMBER PARSER CONFIGURATION page, see Field Description.
Field Description
The following table describes the fields on the MOBILE NUMBER PARSER CONFIGURATION page:
Fields | Description |
---|---|
DETAILS | |
Rule Name | Specify the name of the Mobile Number Parser rule. |
Active | Activate or deactivate the rule by selecting the checkbox.
|
CONDITION | |
This section is available to define multiple conditions based on which the parsing logic can be executed. The condition options available in the Mobile Number drop-down. Figure: MOBILE NUMBER PARSER CONFIGURATION Page: Condition Section | |
Mobile Number | Define multiple conditions based on which the parsing logic can be executed. The conditions are as follows:
Also, you can define AND/ OR Conditions to the parser rule. |
Click icon to define multiple conditions based on which the parsing logic can be executed. | |
Click icon to delete the parsing logic conditions defined. | |
PARSING | |
This section is available to define various parsing rules. Figure: MOBILE NUMBER PARSER CONFIGURATION Page: Parsing Section | |
Extract Characters | Define the criterion based on which the characters can be extracted from the mobile number. The criteria that can be defined are as follows:
|
Parsing Logic | Based on the criteria defined, the ‘parsing logic’ controls are reflected dynamically as displayed in the above screen. |
User-Defined Key | Define a key name to the extracted character. Note: User-Defined Key text box supports up to 100 alpha numeric characters. The defined parsing logics are displayed in the grid view. You can edit an already defined parsing condition by clicking on the hyperlink on the User-Defined Key column. The User-Define Key column has a hyperlink. When you click on the hyperlink, the corresponding parsing condition loads in edit mode. You can then make the required changes and update it by clicking icon on the Add column. |
Preview | Preview the pattern based on the selected value in the ‘Extract Characters’ and ‘Parsing Logic’ column so that the Administrator is clear on the value that is extracted. |
Add | Add the parsing condition by clicking on the icon |
Delete an already added parsing condition by clicking on the icon available for every record in the grid view. When you click on the icon in the grid view, a pop-up with “Are you sure you want to delete the user defined key: (Mobile No) ?” message is displayed with the following options:
| |
MAPPING | |
This section is available to Map all the user defined keys to the standard attributes of the Mobile Number field.
| |
User-Defined Key | All the user defined keys in the Condition section will reflect as dropdown in the User-Define Key field. The Standard fields attributes are as follows:
|
Submit the parsing rule by clicking on the SUBMIT button. |
ACTIONS
This section explains all the icons displayed on the ACTIONS of the MOBILE NUMBER PARSER CONFIGURATION page.
SHOW LIST
Click SHOW LIST to display the LIST table showing all the configured Mobile Number Parser rule details.
Figure: MOBILE NUMBER PARSER CONFIGURATION page: List of Mobile Number Parser Rule Configured
To edit a Mobile Number Parser Rule detail, click the configured Rule Name. Make appropriate changes and click SUBMIT.
To display inactive Mobile Number Parser Rules, click the Include Inactive checkbox.
Note:
When the Mobile Number Parser Rule details are displayed under the LIST table, the ADD NEW icon is displayed on the ACTIONS panel. Click ADD NEW to add a new Mobile Number Parser Rule.
Confluence Cloud Migration Alert: Please refer to known issues you may encounter in Confluence Cloud: https://eitdocs.atlassian.net/wiki/x/wDGwAQ