Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   Small and Medium Business Communications (http://support.avaya.com/forums/forumdisplay.php?f=6)
-   -   Creating Extensions List CSV? (http://support.avaya.com/forums/showthread.php?t=13966)

castr239 04-01-2019 07:36 AM

Creating Extensions List CSV?
 
Hello,
I am relatively new to Avaya products, so I could be missing something basic.

I want to export a list of all extensions from the system.

When I login to the IP Office System, I can go to "Extensions" on the left side.
Now, at the bottom I have a "Print" button.

I can print this list of extensions as a PDF (or directly to a printer).
Is there a way I can get a csv (or tab-delimited, or fixed-width) export of all extensions plus their names?

Thank you

hurdk 04-01-2019 08:01 AM

I am not a IP office tech so I am not familiar but if you can ASA you can list stations then right click on the list and export to a .csv file that can then be sorted and reformatted any way you want.

thiel2 04-01-2019 08:55 AM

IP Office is a completely different animal from Aura......


What version of IP Office are you running? Partner, Basic, Essential, Preferred, Server?
What release? R11.0 is the latest

In what program do you see a "Print" button? Manager? System Status? Web Manager?

Use the Manager program to pull the configuration from the IO Office, then click on File > Import/Export > Export... click on User, change the Save In box to your desktop (or somewhere easy to find the exported file) and then go find the User.csv file and open in Excel. Here's your list of extension numbers and names.

castr239 04-01-2019 11:11 AM

@hurdk, thank you!

@thiel2,
The Avaya IP Office version we are running is Version 9.1.12.0 build 213
The "editions" question, I don't know how to answer.
I opened IP Office, yet I can't find anywhere the "edition" (Partner, Basic, Essential, Preferred, or Server).
Where could I find that information?

----
For the extensions Print button, I open up IP Office, then I go File --> Advanced --> System Status
I log in to the System Status program.
Once logged in, on the left-side tree, I click on "Extensions".
That brings up a big table with Extension Number, User extension, Name, IP Address, MAC, etc.

I attach a screenshot.
https://i.imgur.com/DMLlBaz.jpg


I'm going to try your File -- Export process now.

castr239 04-01-2019 11:14 AM

@thiel2,
The Export process to csv worked super.

I now have the data I can massage and get to the list the user's want.
Thank you!

thiel2 04-01-2019 02:52 PM

Cool - now that I see you are using System Status, here's something else you can do.....

On that Extensions view in System Status, click on any extension to highlight it. Press Control-a to highlight them all. Control-c to copy to your clipboard.

Now open a new Excel spreadsheet, go to cell A2, Right-click, Paste Special, text
You can add the headers manually on row 1, delete columns that you don't need, and you have still another extension view that you can sort as needed

Oh, and from the view, you are not in Basic or Partner mode. Go to Voicemail, if you see Embedded you are using Essential (aka Standard) mode, Voicemail Pro indicates Preferred edition.

castr239 04-02-2019 06:28 AM

Quote:

Originally Posted by thiel2 (Post 35206)
On that Extensions view in System Status, click on any extension to highlight it. Press Control-a to highlight them all. Control-c to copy to your clipboard.

Nice!
I'll do that next time.
More tools for the toolbox!

Quote:

Originally Posted by thiel2 (Post 35206)
Oh, and from the view, you are not in Basic or Partner mode. Go to Voicemail, if you see Embedded you are using Essential (aka Standard) mode, Voicemail Pro indicates Preferred edition.

Finally I know what I have.
I went into Voicemail, and I have:
Preferred Edition Additional Voicemail Ports
R8+ Preferred Edition (VM Pro)

Thank you!! :)


All times are GMT -7. The time now is 06:48 PM.