how to change or add vicidial_statuses values ???

All installation and configuration problems and questions

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

how to change or add vicidial_statuses values ???

Postby abhasbajpai » Mon Aug 28, 2006 10:09 pm

i want to change some vicidial_statuses values
like from 'NP','No Pitch No Price' to
'HU' , 'Hung Up'
I don't know sql so can u tell me the query to change this
on a live system (do i have to resart the mysql demon after doing this and if agents should be logged off)
and i want to know how to add some more vicidial_statuses values
like 'AS','above seventy'
its that can i do it like
use asterisk;
insert into vicidial_statuses values('AS','Above Seventy','Y');
on live system
or i hv log every agent off before doing this.
help needed
thanks
abhasbajpai
 
Posts: 89
Joined: Sun Aug 13, 2006 1:22 am

Postby mflorell » Tue Aug 29, 2006 9:17 am

UPDATE vicidial_statuses SET status='HU', status_name='Hungup' where status='NP';
mflorell
Site Admin
 
Posts: 18386
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 72 guests