Page 1 of 1

Erasing manually from vicidial_auto_calls table

PostPosted: Thu Jul 12, 2007 12:21 pm
by eijal
Hi,
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
:)

PostPosted: Mon Jul 16, 2007 9:01 am
by mflorell
That is very interesting. I have not seen that before, could you post this to the issue tracker along with how you are doing CLOSER transfers and any relevent extensions.conf entries?