Meridian Scripts 1

[Slider55]

I'm needing to make mass changes to directory numbers from a TNB or DNB list out of a Nortel PBx. I have to go through about 2000 numbers and change them all to DID's. I've read through some of the scripts to help me get started building this and thought maybe someones already done this before so I'd check. I see several examples of pulling information from Excel or txt. With my limited experience with scripting I'm wondering which way to go to get started.

Thank you!

 

[knob]

You might try checking some of the Nortel/Meridian forums that are on Tek-Tips as well to see if you can find someone with a script that performs those tasks.

http://www.aspectscripting.com

 

[Slider55]

Thanks!

 

[jamie2]

Slider... Starting out, the easiest thing to do is RECORD an action like building the set. Then if you are familiar with MSWords Mailmerge, copy the record script to word. Change the TN, DN, RNPG and such to FIELDS and merge the data in from an EXCEL spreadsheet.

 

[Slider55]

Do you have an example I could follow on this procedure....Thx!

 

[jamie2]

An example could be the script below of a (M2616) telephone. You will want to go to

http://www.pepedog.com/meridian

and download the MV.xls excel parser. Then print a TNB from your switch and save it as a *.txt file. Then use the MV.xls file to import all the TNB data into a excel data base. In the spreadsheet, I always go into the EDIT>REPLACE and remove the space after the columns KEY 0 thru KEY 58 or whatever the last one is. Anywhere in the example below you see << >> that is field in the Mailmerge, such as <<TN>>. The mailmerge Fields must be named the same as the excel file column headings.

After your data is merged into the data, COPY ALL and paste it in your Procomm script, but remember to put PROC MAIN at the beginning and ENDPROC at the end for your script.

Hope that is enough to get you going.


waitfor "REQ:"
transmit "OUT^M"

waitfor "TYPE"
transmit "2616^M"

waitfor "TN"
transmit "«TN»^M"

waitfor "REQ:"
transmit "NEW^M"

waitfor "TYPE"
transmit "3903^M"

waitfor "TN"
transmit "«TN»^M"

waitfor "DES"
transmit "A013^M"

waitfor "CUST"
transmit "0^M"

waitfor "FDN"
transmit "2200^M"

waitfor "TGAR"
transmit "«TGAR»^M"

waitfor "LDN"
transmit "^M"

waitfor "NCOS"
transmit "2^M"

waitfor "RNPG"
transmit "«RNPG»^M"

waitfor "SSU"
transmit "^M"

waitfor "SCPW"
transmit "1234^M"

waitfor "SGRP"
transmit "^M"

waitfor "CLS"
transmit "CTD PUA FNA HTA TDD HFA MWA IRA OLA LNA CNDA SFA CDCA
GPUA DPUA ARHA AHA USRA STSD^M"

waitfor "RCO"
transmit "0^M"

waitfor "HUNT"
transmit "2200^M"

waitfor "LHK"
transmit "1^M"

waitfor "LNRS"
transmit "16^M"

waitfor "SCI"
transmit "0^M"

waitfor "LPK"
transmit "2^M"

waitfor "PLEV"
transmit "^M"

waitfor "AST"
transmit "^M"

waitfor "IAPG"
transmit "^M"

waitfor "MLWU_LANG"
transmit "^M"

waitfor "MLNG"
transmit "^M"

waitfor "DNDR"
transmit "^M"

waitfor "KEY"
transmit "0 «KEY0»^M"

waitfor "CPND"
transmit "new^M"

waitfor "NAME"
transmit "«NAME»^M"

waitfor "XPLN"
transmit "^M"

waitfor "DISPLAY_FMT"
transmit "^M"

waitfor "VMB"
transmit "^M"

waitfor "KEY"
transmit "1 «KEY1»^M"

waitfor "CPND"
transmit "new^M"

waitfor "NAME"
transmit "«NAME»^M"

waitfor "XPLN"
transmit "^M"

waitfor "DISPLAY_FMT"
transmit "^M"

waitfor "VMB"
transmit "^M"

waitfor "KEY"
transmit "2 «KEY2»^M"

waitfor "KEY"
transmit "3 ADL 8^M"

waitfor "KEY"
transmit "16 MWK 3353^M"

waitfor "KEY"
transmit "19 CFW 4^M"

waitfor "KEY"
transmit "23 «KEY23»^M"

transmit "^M"
transmit "^M”

 

[Firebird Scrambler]

I've got a number of easy change procomm scripts & they are easy to use. You should find some at the link below.



All the best

Firebird Scrambler
Meridian Programmer in the UK

http://www.linkedin.com/in/davidbromley

Useful Nortel forum at

http://www.tspforum.com

If it's working, then leave it alone!.