CID GROUP - Add bulk / multiple AREACODE CIDs

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

CID GROUP - Add bulk / multiple AREACODE CIDs

Postby zenithbsolutions » Thu Jan 03, 2019 2:14 pm

Hi,

I have a VoIP provider who charges the call based on the outbound CID (Interstate & Intrastate). I would like to define the outbound CIDs based on the Area Code in CID Group. As there are thousands of Area Codes. How can we upload multiple CIDs at once in CID Group?

Any help or suggestion would be appreciated.

Thank you.
zenithbsolutions
 
Posts: 122
Joined: Tue Aug 25, 2015 2:17 am

Re: CID GROUP - Add bulk / multiple AREACODE CIDs

Postby williamconley » Thu Jan 03, 2019 2:26 pm

1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) You don't. You use MySQL. Directly add them to the table. 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: CID GROUP - Add bulk / multiple AREACODE CIDs

Postby zenithbsolutions » Thu Jan 03, 2019 2:40 pm

Hi William,

Its a Vicibox 8.1.2 ISO Installation

SVN VERSION: 2.14-695a
BUILD: 181116-1133

Kindly share me the table name where we need to push the CID data and is there any tool to push them in MySQL as we need to enter a new query for each CID or is there any simple syntax to push them in bundle.

Thank you.
zenithbsolutions
 
Posts: 122
Joined: Tue Aug 25, 2015 2:17 am

Re: CID GROUP - Add bulk / multiple AREACODE CIDs

Postby williamconley » Thu Jan 03, 2019 3:04 pm

1) phpMyAdmin will be available IF you requested it during install. The single most powerful yet easy to navigate MySQL interface.

2) Whether or not you installed phpMyAdmin, mysql is always available from the command line of your server. SQL queries are technical and this is not a mysql forum. lol.

3) vicidial_campaign_cid_areacodes

4) a single insert command MAY contain an unlimited number of records to insert.

5) If you insert TWO manually in the web interface and then "mysqldump" the resulting vicidial_campaign_cid_areacodes entries, you will get a lot of extra, but in there will be a single line showing the precise syntax to add new entries. (That's what mysqldump is for: it "dumps" a record that can be re-imported to restore the database/table in question.) Beware: Do not dump the entire db. Do not reload more than just the single "insert into" line, as the mysqldump result often contains full construction information for the table and will Wipe the table before it adds the records if you're not careful. Just a single line with an "insert into" is all you'll need to add them. The same commands and concepts apply to phpMyAdmin: It just has a prettier interface that's not console based, it's web based.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: CID GROUP - Add bulk / multiple AREACODE CIDs

Postby mflorell » Fri Jan 04, 2019 8:33 am

You could always use the "Reports -> Admin Utilities -> Admin Bulk Tools" feature to mass-upload new AC-CIDs or CID-Group entries through the web admin:

AC-CID Bulk Add -
This allows you to paste in a listing of CIDs to insert into a campaign AC-CID list or CID Group list. There are three methods to choose from:
STATE LOOKUP - This will take a list of CIDs and insert them as Area Code Caller IDs into the selected campaign. The area code lookup is designed to work only with numbers in the North American Numbering Plan as it uses the first three digits of each CID. The description will automatically be filled with the appropriate US state abbreviation corresponding to the given CIDs 3-digit area code.
CSV - This will take a comma separated list in the format of NPA,CID,DESCRIPTION,ACTIVE and insert each line into the specified campaigns AC-CID list using the supplied values. For example, given a listing of 813,7271234567,Florida,Y will result in an AC-CID entry for area code 813 using the CID 7271234567 and a description of -Florida- with the status being active. Descriptions are limited to 50 characters. For CID Groups of a STATE type, use this format for CSV- STATE,CID,DESCRIPTION,ACTIVE. The -ACTIVE- column will only be used if the Active select list above is set to -Input-.
STATE FILL - Similar to the STATE LOOKUP method above, this will take a list of CIDs and insert them as AC-CIDs in the specified campaign but will also make an entry for each area code in a state based off the state the CID is in. For example, if given the CID 7271234567, 19 CID entries will be created with the same CID, one each for every area code in Florida. If you are inserting into a CID Group that is a STATE type, then you will not want to use the STATE FILL method.
CIDs must be between 6 and 20 digits in length and only digits 0-9 are allowed. Optionally, you can have the AC-CIDs set to active upon insertion.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 66 guests