Author Topic: Changing email of all agents  (Read 3894 times)

gopal2k

  • Jr. Member
  • **
  • Posts: 60
  • Karma: 0
    • View Profile
Changing email of all agents
« on: December 03, 2013, 09:49:31 »
I would like to change the email column for all my agents configured in queuemetrics. The agents might be around 1000 numbers, I see in MySQL this table named "agenti_noti" all the agents information.

By using replace function in MySQL, if I change the value of email "descr_agente" will that be sufficient?

Please advise.

Thanks.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Changing email of all agents
« Reply #1 on: December 06, 2013, 15:48:46 »
What do you mean by "email" for an agent? the one you refer to is the description.
After you do the changes, wait a few minutes for QM to invalidate caches ad start reloading.

gopal2k

  • Jr. Member
  • **
  • Posts: 60
  • Karma: 0
    • View Profile
Re: Changing email of all agents
« Reply #2 on: March 03, 2014, 09:38:56 »
Sorry for my delayed reply. Yes the Agent description... while creating agents.

Actually I have so many agents, so will the replace command in mysql is sufficient to change bunch of email address?

Thanks.

mirkox

  • Full Member
  • ***
  • Posts: 231
  • Karma: 4
    • View Profile
Re: Changing email of all agents
« Reply #3 on: March 03, 2014, 15:29:37 »
Hi,

yes, just replace the values (and log out and in in QueueMetrics to see them updated).

I'd do a dump of the table before doing that, just to be on the safe side.

Mirko