how to use processdata.pl to check duplicate data for astercc database

By | asterCRM | No Comments

There is a perl script named processdata.pl in astercc scripts directory, you can use it to check duuplicate or truncate for your astercc database.

First, need to configure astercc.conf about tow segment [check_duplicate] and [truncate_table], let’s go to astercc scripts dirctory(/opt/asterisk/scripts/astercc/), and edit astercc.conf

[check_duplicate] for configure paramer of checking duplicate data:

Format:  table = field1:field2:[field1,field2]|orderfield(default:id),order(default ASC)|condition_table:condition_display:foreign_key

for example: we want to check duplicate phonenumber in customer table  and order by created time asc, just add following line :

customer = phone:mobile:phone,mobile|cretime,asc

we define three table in default astercc.conf, customer, customer_lead and diallist. just like following:

[check_duplicate] ;Format=> table = field1:field2:[field1,field2]|orderfield(default:id),order(default ASC)|condition_table:condition_display:foreign_key
customer = phone:mobile:phone,mobile|cretime,asc
customer_leads = phone:mobile:phone,mobile
diallist = dialnumber|cretime,asc|campaign:campaignname:campaignid

and the configuration for truncate table is samlply, just add table name = 1 in  [truncate_table] segment:

[truncate_table] mycdr = 1
customer= 1
customer_leads= 1
note= 1
note_lead= 0
diallist= 1
dialedlist= 0

Now,  let’s execute processdata.pl  and follow the prompts to check dumpliate or truncate table step by step.

./processdata.pl

first step, you should select what you want to do , check duplicate or truncate, I selected check duplicate , just type “C” and press enter.

and then need to select which table you want to check,  just type the number of  table, I selected 1 for customer table;

next select which fields in table you want to check duplicate, I select ‘3’ for check phone and mobile .

now you should select a option from check duplicate :

the last step, it’ll list all of you selected and you need confirm to run:

press ‘Y’ to start checking

It’ll delete the duplicate and record data to a csv file.

 

billing with accountcode works on freepbx(asterisk) + aserbilling

By | asterBilling | No Comments

The asterbilling support billing with accoutcode since version 0.15 in asterCC 0.21 beta, the following content show how it works: We said you alread set the trunk and outbound rule in freepbx for dial out. Now, we should add a extension in freepbx as follwing image, and set the accountcode for this extension : Then we should configure astercc to billing with accountcode. first, set the parameter billingfield= accountcode in /opt/asterisk/scripts/astercc/astercc.conf and restart asterccd ( /etc/init.d/asterccd resstart ) Login to asterbilling and add the clid with accountcode Login as groupadmin or operator to test

multilingual telephone interpretation system solution

By | Regular functions in call center | No Comments

astercc provides a multi-way call system based asterisk, using this sytem, you could build a multilingual telephone interpretation system.

key features:

1. billing invoice

2. multi language IVR

3. calling card

4. part-time agent

5. different rate

6. low-cost (VoIP support)

7. web site integration

8. full conversation recording

9. multi-party conference

10. support reseller

11. detail report

12. inbound/outbound popup

user case:

1. https://www.callservice365.com

2. https://accesspath.com

asterCC released version 0.21 beta

By | Latest News | One Comment
  • [download#32#size]

asterCRM 0.075 in asterCC 0.21 beta:

  • added customer_lead and note_lead
  • added defined code for note

  • added user online statistic and user online report

  • added sms api

  • added user type and user privileges

  • added attend transfer for agent mode
  • added hangupcause, hangupcausetxt and dialstatus to cdr table
  • fixed bug of astercc daemon works with asterisk 1.2
  • fixed bug of incorrect didnumber on agent mode
  • fieed bug of incorrect curcdr works with astercrm.agi
  • added doubleCheckCampaign in astercc.conf
  • added export data to daillist directly
  • added count and time of tranfer to cdr and dialedlist

asterBilling 0.15in asterCC 0.21 beta:

  • added pushcall mode(works with pushcall.agi)
  • added billing by accountcode mode
  • added query and hangup current channels in system page

how to use auto-recyle feature in a dialer campaign

By | asterCRM | No Comments

we have improved the auto-recyle feature in new version, now you could config auto-recyle by campaign.

auto-recyle is used to recyle the number from table campaigndialedlist to diallist, so system could re-dial customer phone in some conditions, it has the following parameters:

Max trytime:   the maximum time the dialer will try dial

Recyle time:   it will start recyle when “Recyle time” seconds after the call is done

Enable Auto Recyle:  set to “yes” if you want to enalbe auto-recyle

Min Duration:  number will be recyled  when the full duration is less than this value, this duration including ring time

Agent Answer Min Duration:  number will be recyled  when agent talking time is less than this value

Customer Answer Min Duration:  number will be recyled  when customer answering time is less than this value

* number will be recyled only when it meets all conditions above

tutorial: use astercc,freepbx and asterisk to build a broadcasting system with IVR and Queue agents

By | asterCRM | No Comments

the most feature in astercc is the predictive dialer, using the dialer you could improve the work efficiency. In this tutorial, I will introduce how to setup a dialer with a pre-configed IVR:  when dialer start work, customers will hear a IVR which you configed in Freepbx, so we could also config in the IVR to accept customer input, and we can forward to an new IVR or agents in a queue.

1. config a Queue in freepbx

usually you want to config a queue to resonpse customer if they want to reach some live agent, so we config a queue first

2. config an IVR in freepbx

2.1 first we will add some voice in the IVR, you’d like to use a recording software, just notice that in asterisk, it requires to use wav format and 16bit, 8000HZ mono

2.2 add a recording

you can either upload the recording you finished in your pc, or use a ext. in system to record a new one

2.3 add IVR

now queue and recording is ready, we could add the IVR

in announcement, we select the recording we just done, and also we added two options to accept customer input, when customer hits 1, he will go queue 900, and when hits 2, he will go to ext. 5001.

4. add misc

then we need add a misc so the dialer could reach the IVR

remember this feature code 800, we will use it when configing campaign in astercc, you could use some other code as you like, just make sure it’s unique in your freepbx

now we finished the job in freepbx, you’d like to dial 800 from any extension, it supposes to bring you to the IVR.

5. config the campaign in astercc

login as admin, and go to campaign, add a campaign as following

make sure in “Inexten” you put the same code as in “misc application”, and in “Queue number” put the same queue number as your freepbx queue

6. add agent user in astercrm

you’d like to add some account for your agents if you want them get a popup form when they start answer customer calls, go to “Extension” to add astercrm account for your agents, make sure the account “extension” match the ext. in your freepbx

7. start dialer and test agent

before start dialer, you’d like to check your astercc.conf

make sure this parameter is configed as

doublecheckcampaign = yes

then restart astercc daemons

/opt/asterisk/scripts/astercc/asterccd restart

ask your agent login and as admin go to dialer page, start the dialer

as an agent, he will get a popup when customer answered the call and hit 1 for queue

8. check report

you could go to dialedlist to check the campaign status

* to get a working freepbx and asterisk easily, you could choose  astercc box, elastix, pbxinaflash or trixbox

asterCC and asterCC-BOX released version 0.2

By | Latest News | No Comments

asterCC and asterCC-box relaased version 0.2 final asterCC-BOX

  • fixed bug of default moh disabled cause for cannot use attend transfer

asterCRM 0.072 in asterCC 0.2:

  • fixed a bug of predictive dialer when dial a ivalid number with dahdi
  • fixed a popup bug when dialed number similar on agent number
  • added parameter convert_mp3 in astercc.conf to control processmonitors if converts records to mp3
  • fixed sql error when link without queue in astercc daemon
  • added export customer data in note page
  • fixed bugs of Campaign Report
  • fixed a bug of doesnt display trunk info in portal page
  • added parameter auto_note_popup in astercrm.conf.php for if auto popup note info
  • added parameter default_share_note in astercrm.conf.php for if share note default
  • added customertitle(Mr,Miss,Ms,Mrs,other) in customer table

  • fixed note to blank when confirm or cannel a customer
  • added auto pause on queue pannel of agent portal page

  • added parameter singleOutboundTrunk in astercc.conf

asterBilling 0.14in asterCC 0.2:

  • fixed bug of epayment with callshop_pay_fee setting
  • no longer support callback function(could use callback in version 0.12(asterCC 0.14))
  • fixed issue of astercclock cause for high CPU usage

mysql optimization for astercc

By | asterCRM | No Comments

for centos, open /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 key_buffer_size = 512M max_allowed_packet = 4M thread_stack = 256K table_cache = 128K sort_buffer_size = 6M read_buffer_size = 4M join_buffer_size = 8M myisam_sort_buffer_size = 64M table_cache = 512 thread_cache_size = 64 query_cache_size = 64M tmp_table_size = 256M max_connections = 768 max_connect_errors = 10000000 wait_timeout = 10 thread_concurrency = 12 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

How to restore astercc from backup

By | asterBilling, asterCRM | No Comments

If you bakcups the astercc database, code dirctoys and asterisk etc by backup.sh, you would get backup files as following:

./dir_backup ./dir_backup/localsave ./dir_backup/localsave/asterisk.2010-11-18-06.tar.gz ./dir_backup/localsave/astercc.2010-11-18-06.tar.gz ./backup.sh ./db_backup ./db_backup/localsave ./db_backup/localsave/astercc.2010-11-18-06.tar.gz ./db_backup/dbbk.log

All directory backup file is in dir_backup/localsave, such as above , the “./dir_backup/localsave/asterisk.2010-11-18-06.tar.gz” is backuped for asterisk etc and the “./dir_backup/localsave/astercc.2010-11-18-06.tar.gz” is backuped for astercc code. if you want restore directory, just untar .tar.gz file and move them to corresponding position. All database bakcup file is in db_backup/localsave, the “./db_backup/localsave/astercc.2010-11-18-06.tar.gz” is backup for database named astercc, if you untar the file,you would get a sql file such as astercc.2010-11-18-06.sql If you want restore database astercc, just run: mysql -uyourdbuser -pyourdbpassword astercc < astercc.2010-11-18-06.sql that’s all

A Sonicwell Product · Also: CXMind AI · WCC Contact Center