SOP for adding New DIDs to an account
- Darsh Bhatt
Follow the below mentioned steps.
If adding DIDs from Backend in account:
1) Update into DIDMaster table in “account_ID” column.
Example: UPDATE DIDMaster set account_accountID=3306 WHERE didID =99726.
You will get this didID from DIDMaster table with the help of DIDNumber.
Query: SELECT * from DIDMaster where didNumber = 2268700509;
Run the above query to find out the didID.
2) Configure Rate Plan for that DID. Please find the link of document for Rate Plan below.
Note: Everytime a New DID is added in the “ACCOUNT” then for a single DID rate plan should be configured.
If already he RatePlan is configured for that account then please follow the below steps to configure RatePlan for DID Number which is to be added in the account.
For example: This “2268700509” DID Number is to be added in Kissht Account.
Search any of the existing DID Number’s rate plan in DIDRateMaster table. This “2268461709” DID Number is existing in Kissht Account (3306). DID ID of this number is “22645“.
Run the below query.
SELECT * FROM DIDRateMaster dm WHERE did_didID =22645;
The result will be displayed and check the “obd_id” & “agentPlan_id” column. The value in both the columns will be same “461”. This ID is unique for every account.
Now we have to configure rate plan for new DID i.e. “2268461709”. DIDid of this number is 22645.
UPDATE DIDRateMaster SET agentPlan_id=461 WHERE id=22625;
UPDATE DIDRateMaster SET obd_id=461 WHERE id=22625;
After running these queries, the rate plan will be configured for that account.
If adding DIDs from Backend in Flows:
1) Insert into FlowDIDMapping table using didID or flowID.
Example: INSERT INTO centraldb.FlowDIDMapping(active, lastUpdatedTimestamp, flowID, didID)
VALUES(1, '2020-09-19 22:41:43', 8407, 22645);
After running the above query, 2268461709 DID Number will be added to the flow. (flowID : 8407)
2) Insert into FlowIvrChannelPoolMapping table with respect to ChannelPoolID.
Example: INSERT INTO centraldb.FlowIvrChannelPoolMapping(active, weight, flowID, channelPoolID, consumers, makeCallPresent) VALUES(0, NULL, 27726, 367, 1, 1);
This document has been developed by Phonon.io for the sole and exclusive use of the customer / prospective customer with whom this document is being shared. Further, this document has been provided by Phonon.io to the recipient in good faith and based on request from the recipient for the same. This document is a confidential document and contains confidential product technology, workflow and commercial details that are for the sole usage of the intended recipients of this document. Recipients are advised not to share this document with any third party that is not the intended recipient of this document and neither to bring this document in full or parts into the public domain. Any unauthorized access may be brought to Phonon.io’s notice immediately. Phonon.io is free to take any legal action it deems necessary against any person or entity that violates this confidentiality agreement. Phonon.io is bound and governed by the rules of the state of Gujarat in India. In case you are not in agreement with the terms set in this clause or are not an intended recipient of this document, please destroy the document and intimate us of the same at info@phonon.io.