Author Topic: Spread Sheet for Programming Mitel 250  (Read 2983 times)

Offline berkley

  • Jr. Member
  • **
  • Posts: 60
  • Country: us
  • Karma: +0/-0
    • View Profile
Spread Sheet for Programming Mitel 250
« on: June 01, 2017, 09:37:57 AM »
I have been told that there are spread sheets available to fill out and upload to the 250 in order to program phone, users etc.. If this is correct where may I locate these forms?

As always thank you for using your time and knowledge to help!!!


Offline acejavelin

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4100
  • 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: Spread Sheet for Programming Mitel 250
« Reply #1 on: June 01, 2017, 09:51:23 AM »
I have been told that there are spread sheets available to fill out and upload to the 250 in order to program phone, users etc.. If this is correct where may I locate these forms?

As always thank you for using your time and knowledge to help!!!
There is for the 3300, never heard of such a thing for the 5000. You can import users from the Configuration Wizard, but that is about it, everything else is manually done as far as I know.

Frontline

  • Guest
Re: Spread Sheet for Programming Mitel 250
« Reply #2 on: June 01, 2017, 12:52:23 PM »
you can import phones from a file. Under system>devices and feature codes>phones, right click anywhere in the open space on the right hand side and select "Create IP Phones from File"

Browse to the correct file. Make any changes needed and then click on import.

I have attached a blank import sheet

Offline Tech Electronics

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2983
  • Country: us
  • Karma: +89/-1
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #3 on: June 01, 2017, 01:27:50 PM »
Guys,

You can create Phones, Phantoms and Hotdesk Profiles, Users, and Mailboxes via csv files.

Thanks,

TE

Offline magnus

  • Full Member
  • ***
  • Posts: 156
  • Country: ca
  • Karma: +0/-0
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #4 on: June 01, 2017, 01:41:32 PM »
The easy way to get those csv files to work from is to export one first and use it as a tempate

Offline acejavelin

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4100
  • 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: Spread Sheet for Programming Mitel 250
« Reply #5 on: June 01, 2017, 04:45:58 PM »
huh... learn something every day. :)

Offline berkley

  • Jr. Member
  • **
  • Posts: 60
  • Country: us
  • Karma: +0/-0
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #6 on: June 02, 2017, 06:54:37 AM »
Thank you for the reply. The forms make it a bit quicker.

As always, I owe all of you.

Offline DND ON

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 908
  • Country: us
  • Karma: +23/-0
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #7 on: June 02, 2017, 07:23:03 AM »
I'm not really sure how much value there is importing the data. Whenever I tried, I spent more time fixing formatting errors than it would have taken to manually key in the phones.

Offline Tech Electronics

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2983
  • Country: us
  • Karma: +89/-1
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #8 on: June 03, 2017, 03:08:09 PM »
Guys,

If I may provide a little more direction for those who engineer/program new systems the easiest way to put in all the information is through the User's form. I would even go so far as to say that not all of the fields (columns) show up in the User's form, but can be manually added to it for it to create things automagically; yes I know that isn't a word.

To reduce mistakes on our part we have our customers fill out an Excel document that can be used to import the information into a csv file. If your default DB has all of your standard templates for each type of device then performing a copy/paste reduces programming time to a bare minimum.

Now, the adding of new devices is sometimes easier to just manually create them, but we have found that the original database is programmed faster using this method.

Thanks,

TE

Offline DND ON

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 908
  • Country: us
  • Karma: +23/-0
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #9 on: June 04, 2017, 09:03:28 AM »
Proving there's always more than one way to skin a cat, I never create Users unless there's a specific need. Keeps the database cleaner, fewer places to look for issues and easier to handle employee turnover. My experience is that only about 10% of phones need User features.

Offline Tech Electronics

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2983
  • Country: us
  • Karma: +89/-1
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #10 on: June 04, 2017, 09:09:28 PM »
DND ON,
 
I delete all User profiles not needed after importing all th base information into the DB. Typically only a couple of users actually use DEE per site, but as you know there are other reasons to create them as well.

Anyway it is just another way to program base information into the system quickly and get started on call flows.

Thanks,

TE

Offline jtsmith

  • Contributer
  • *
  • Posts: 8
  • Country: us
  • Karma: +0/-0
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #11 on: June 20, 2017, 11:25:37 AM »
YES on the User import csv. If you use that one it loads everything Ext, VM Boxes and all names. Like previously mentioned you delete unused user's.
Make sure you add a Password column to the end of the csv file (I've attached one for digital and IP) If doing digital phones make sure to prog. your cards
with no info just the ports before importing user csv.

Offline jtsmith

  • Contributer
  • *
  • Posts: 8
  • Country: us
  • Karma: +0/-0
    • View Profile
Re: Spread Sheet for Programming Mitel 250
« Reply #12 on: June 20, 2017, 11:26:59 AM »
sorry here's the digital csv


 

Sitemap 1 2 3 4 5 6 7 8 9 10