Erasing manually from vicidial_auto_calls table
Posted: Thu Jul 12, 2007 12:21 pm
Hi,
Everyday I always have to erase some records from the vicidial_auto_calls table, the kind of records to erase are:
I have using vicidial 2.0.3 in one machine together with asterisk, and in another server is the DataBase and Web Server.
As you can see, the records to erase are from de CLOSER campaign. Maybe I am missing some parameter.
THANKs
Everyday I always have to erase some records from the vicidial_auto_calls table, the kind of records to erase are:
- Code: Select all
+--------------+-------------+--------------+--------+---------+--------------------+----------------------+-------------------------------------------------------------------------+------------+--------------+---------------------+-----------+----------+---------------------+----------+
| auto_call_id | server_ip | campaign_id | status | lead_id | uniqueid | callerid | channel | phone_code | phone_number | call_time | call_type | stage | last_update_time | alt_dial |
+--------------+-------------+--------------+--------+---------+--------------------+----------------------+-------------------------------------------------------------------------+------------+--------------+---------------------+-----------+----------+---------------------+----------+
| 43374 | 192.168.2.5 | CL_AGENTES_L | CLOSER | 304699 | 1184258650.4719801 | J0712124335000304699 | Local/90009*CL_AGENTES_L*CXFER*304699**6202750455*51302*@default-d4b9,2 | 1 | 6202750455 | 2007-07-12 12:43:35 | IN | CLOSER-0 | 2007-07-12 12:44:11 | NONE |
| 43941 | 192.168.2.5 | CL_AGENTES_L | CLOSER | 279921 | 1184259411.5020199 | J0712125629000279921 | Local/90009*CL_AGENTES_L*CXFER*279921**8474371004*51326*@default-791a,2 | 1 | 8474371004 | 2007-07-12 12:56:29 | IN | CLOSER-0 | 2007-07-12 12:56:52 | NONE |
| 44033 | 192.168.2.5 | CL_AGENTES_L | CLOSER | 305077 | 1184259713.5117099 | J0712125841000305077 | Local/90009*CL_AGENTES_L*CXFER*305077**6202772146*51349*@default-8830,2 | 1 | 6202772146 | 2007-07-12 12:58:41 | IN | CLOSER-0 | 2007-07-12 13:01:54 | NONE |
+--------------+-------------+--------------+--------+---------+--------------------+----------------------+-------------------------------------------------------------------------+------------+--------------+---------------------+-----------+----------+---------------------+----------+
3 rows in set (0.00 sec)
I have using vicidial 2.0.3 in one machine together with asterisk, and in another server is the DataBase and Web Server.
As you can see, the records to erase are from de CLOSER campaign. Maybe I am missing some parameter.
THANKs