Author Topic: Mass deletion of System Speed Calls  (Read 2959 times)

Offline irongladiator

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 346
  • Country: us
  • Karma: +13/-0
    • View Profile
Mass deletion of System Speed Calls
« on: February 17, 2017, 02:15:26 PM »
Hello Fellow Mitel Techs,
Does anyone here know of a way to delete ALL system speed calls in the MCD? (I got about 1000 of em') I tried to export and remove the entries via the spreadsheet and import, but no luck. So far It looks like it is just one at a time.

Thanks,
-Iron


Offline acejavelin

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4097
  • Country: us
  • Karma: +133/-0
  • High-tech, heavy metal redneck!
    • View Profile
    • Like what I do and wanna help out? Send me a donation!
Re: Mass deletion of System Speed Calls
« Reply #1 on: February 17, 2017, 03:27:34 PM »
Hello Fellow Mitel Techs,
Does anyone here know of a way to delete ALL system speed calls in the MCD? (I got about 1000 of em') I tried to export and remove the entries via the spreadsheet and import, but no luck. So far It looks like it is just one at a time.

Thanks,
-Iron
When you delete the first one, then it should say how many records to delete, enter like 100 and preview, if it looks good, press OK.

Offline sarond

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1401
  • Country: au
  • Karma: +73/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #2 on: February 17, 2017, 05:59:14 PM »
Pet Peeve, you can't delete a range of Speed Dials.
It seems to be one of the only forms that don't allow range programming.

Offline irongladiator

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 346
  • Country: us
  • Karma: +13/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #3 on: February 17, 2017, 06:37:12 PM »
When you delete the first one, then it should say how many records to delete, enter like 100 and preview, if it looks good, press OK.

Hi acejavelin,
Nope....once I hit the Delete button I get this....



As you can see, I cannot click on anything other than "OK" or "Cancel".  :( Oh well, it is what it is. I think sarond is correct though only can be done one at a time. But on the plus side it took me a little over an hour and a half to delete all system speed calls!  ::)

Anyways, thanks guys!

Thanks,
-Iron

Offline x-man

  • Hero Member
  • *****
  • Posts: 1129
  • Country: gb
  • Karma: +25/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #4 on: February 18, 2017, 06:20:39 AM »
I don't suppose it responds like a normal window and you can shift click to highlight more than one entry at a time (don't know just a thought).

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #5 on: February 19, 2017, 11:44:14 AM »
This would sound a little like hacking, but you can try to do following:

1) do backup
2) in the backup file clear the \vmail\temp\db\backup\data_save\SPEED_CALL.37 file (delete the file and create and empty SPEED_CALL.37 file)
3) restore from the updated backup file

I have not verified this in the lab is trying this method is under your risk ;-)

The format of these files is quite simple, the meaning of the extension e.g. the .37 is actually a size of each record in the file, so clearing the content of the file means 0 records in it.

Offline BlackSunshine

  • Full Member
  • ***
  • Posts: 190
  • Country: us
  • Karma: +1/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #6 on: February 19, 2017, 05:18:56 PM »
Can't you export the current list then clear all them out or maybe leave one with excel then import new list

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #7 on: February 20, 2017, 04:11:37 AM »
Quote
Can't you export the current list then clear all them out or maybe leave one with excel then import new list
No, this does not work, at least not in the 14.0.0.97.

Offline irongladiator

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 346
  • Country: us
  • Karma: +13/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #8 on: February 20, 2017, 01:16:41 PM »
I don't suppose it responds like a normal window and you can shift click to highlight more than one entry at a time (don't know just a thought).

x-man,
Even though I was 99.9% sure that wouldn't work I tried it anyways.....and nope....No dice.

Thanks,
-Iron

Can't you export the current list then clear all them out or maybe leave one with excel then import new list

BlackSunshine,
Just as petr.necas stated, that don't work either. I actually tried that first too. We are using 13.2.1.27, it no likey in there either. One at a time is thee only "Official" way it seems, I'm not brave enough to try petr.necas' little "Try at your own risk" hack, hahaha

Thanks,
-Iron

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #9 on: February 21, 2017, 01:30:35 PM »
I realized, if the speed calls are referenced on other forms, like on the Call Rerouting form, it will probably not be the best idea to hack the backup file and import.

Online ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #10 on: February 22, 2017, 07:48:17 AM »
What would happen if you exported the CSV file, then deleted all of the "Actual" numbers and re-upload them again?   I'm wondering if leaving the actual number field blank would delete it?

Ralph

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #11 on: February 23, 2017, 08:48:15 AM »
Gives a "The directory number is defined elsewhere. The directory number is invalid." error message.

Offline Ronan

  • Full Member
  • ***
  • Posts: 149
  • Country: fr
  • Karma: +1/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #12 on: March 12, 2019, 06:19:43 AM »
Anyone found a solution to this. I have hundreds to delete and it's annoying as hell.

Online ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #13 on: March 19, 2019, 09:40:25 PM »
Look for a scripting program.
I use Auto Hot Key.  It's free but powerful.
You could script a keystroke to click, delete, click delete, click delete.

Ralph

Offline Ronan

  • Full Member
  • ***
  • Posts: 149
  • Country: fr
  • Karma: +1/-0
    • View Profile
Re: Mass deletion of System Speed Calls
« Reply #14 on: April 11, 2019, 09:39:46 AM »
Interesting, I'll try that. Thanks :)


 

Sitemap 1 2 3 4 5 6 7 8 9 10