Read Extensions DB 2

[Gorellana]

Hi, in my company we publish the list of extensions every time we modify it, however, i'm trying to enhance the process by reading directly from the Avaya IPO 500 V2 internal DB, and posting it to the intranet.

Is there a way to do this, or how may i read directly from the IPO the list of extensions it has?

Thanks a lot for your assistance!
Best Regards
Gabriel

 

[holdmusic34]

You can use system status> extension> click Print tab or,

using Manager
go> File
Export>
Click User
Click Save In (select your detination)
Save as .csv text.

Go to your 'Save In' location and open the file with Excel.
Edit as necessary for visual appearance.

Kids, Kids, It's Avaya. You're both right.

 

[Gorellana]

Thanks Holdmusic34, but i'd like something else, i know already i can export to a file, but what i really need/want to, is to enable a a connection directly into the DB, that keeps the file in the intranet updated at the same time I do the modification.

I don´t really know if i can use a SQL or Oreacle connector to get to the DB, and from there do the backend program to update my directory automatically.

Thanks anyways for your option

 

[holdmusic34]

You would be looking into LDAP then.

System> Directory Services> LDAP

http://www.tek-tips.com/viewthread.cfm?qid=942601

http://www.tek-tips.com/viewthread.cfm?qid=1658644

http://www.tek-tips.com/viewthread.cfm?qid=1634868

Kids, Kids, It's Avaya. You're both right.

 

[Gorellana]

Thanks again for your reply holdmusic34, but then again, this is not what i need to do.

What i need to do is as simple as this:
1.- Read the extension DB from the Avaya IPO
2.- store this information in an externat DB (MS-SQL, Oracle or MySQL)
3.- automate an export proccess, done by me, to upload this info
4.- upload info in our intranet site, in a simple table display, displaying the exact extension for every member of the organization.

Both of the options you are giving me are indeed usefull, one allows me to send it to a simple file (could work, but is not the case), and the other one, as i can see, imports the info to my AD allowing me to update their user in the AD with the phone information, but is not what i'm intended to do.

Thanks again for your good will.

 

[holdmusic34]

No worries! Good Luck.

Kids, Kids, It's Avaya. You're both right.

 

[mforrence]

You could also use the directory function of IPO and quit updating the list

 

[TomMills]

yay for simplicity!

http://www.twitter.com/tem1985

APSS/ACIS/ACSS-SME
not arrogant, just succinct.

 

[tlpeter]

You coulds try this with tftp:

tftp 192.168.2.40 -c get "nasystem/user_list" /dev/stdout

192.168.2.40 should be changed to the IPaddress of your IPO.


BAZINGA!

I'm not insane, my mother had me tested!

 

[Gorellana]

You could also use the directory function of IPO and quit updating the list

Could you please explain me a little more on this?

To be completely honest, I have knowledge as a system manager, however, I have never managed VoIP, and this is something I'm being asked to solve...

Another user proposed to access via FTP, but i'm sure what would i need to do to get the info...

 

[tlpeter]

tftp, not ftp

Open a command promt and type the command tftp 192.168.2.40 -c get "nasystem/user_list" /dev/stdout

This is for a Linux machine so hopefully you have one or change it for a windows system.

This command should pull the user information out of the IPO.
But this command is old and there is a big possibility that this is not possible anymore.
Avaya's softconsole and phonemanager use tftp to pull user info out of the IPO so it should be possible.


BAZINGA!

I'm not insane, my mother had me tested!

 

[Gorellana]

Thanks a lot, i'm working on it now!