CID GROUP - Add bulk / multiple AREACODE CIDs

[zenithbsolutions]

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.

[williamconley]

1) Welcome to the Party!

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.

[zenithbsolutions]

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.

[williamconley]

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.

[mflorell]

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.