Excel to Create AMO scripts

[NYPQ-EN]

Good morning all,

I have been away for a bit and trying to convince my management to pony up the money for the Basics Hi-Path course.

I have a question:

How can I use Excel to Create a script for a Hi-Path AMO?
Specifically 40T phones and IP 40G phones.

I would appreciate it if someone could point me in the correct direction and it would be cool if I could see an example.

Thank you all and Have a blessed day.

Eric

 

[sbcsu]

Hi Eric,
Just copy the relevant lines from an AMO file.
They will be something like this:
ADD-SBCSU:1234,OPTI,DIR,1-1-79-0,OPTISET,1,16,11,7,1,7,1,0,0,N,0,Y,0,1,N,2,30,N,,,,,,,,Y,0,N,N,N,Y,N,,,,,,,,,5,,,,,,WITHIND,NORMAL,Y,ENGLISH,0,ALL,,0;

You can save them as a CSV comma delimited file in Excel.
Open it as an XLS file in Excel and then drag down to add in other extensions etc.

Save again as CSV when finished editing then open with Notepad or similar.

Send in to the HiPath/OpenScape 4000 using ComWin

 

[donb01]

The wy I do it is I do a REG-SBCSU for a station of the type I want, then I copy the output and paste it into notepad.
Then do a REG-SDAT for the same station and paste that after
and a REG-ZIEL and anything ele you might need.

Make sure in notepad you have one AMO string per line, no blank line at the top and no lines between AMOs.
Save the file something like OS40HFA-42.cmd (the number I used is the button table assigned. You could add other indicators as well.

When you want to use it open the file in notepad and choose REPLACE. Search for the current station number, and replace it with the new one, but travers the list one at a time to be sure you don't accidentaly get instances of that number sequence that are not station numbers. When done, you have to go to the first line and change the PEN to whatever the new phone will have, then hit Save.

In Comwin choose Macro --> Start --> Open, and specify your .cmd file
Once you have the file loaded you should be able to hit the icon that looks like a flathead screw and it should step thru the list, or tell you any errors in the code.

Note that when you clone a station it does not activate the "Key System" parameter on the Basic1 tab as far as I have done it. You have to tick that and save the station to do that.


Another way to do some of it is while viewing the station in Assistant you can click on Action --> Save as Template. Give it a group like OS40HFA and then a name to identify what it's for. Then when you are on a blank search screen in Assistand you can say Action --> Get Template to pull that in for a new phone. Then you can work in Assistant - you will have to fill in the PEN and the Device Family, and give it a station number before you hit save.



Don Bruechert, Voice Comm Analyst II
CareTech Solutions @ Holy Family Memorial
Manitowoc, WI, USA

 

[sbcsu]

Another way of working on the system is to go to ComWin and log on.
Then 'macro' 'retrieve system variant'
After that any command you type in you can do 'ComWin Edit'
Just click in the bottom part of ComWin and then hold down Ctrl and Tab