Installing a Corporate Directory without using OTM / MAT
It's very easy to install the Corporate Directory on a Meridian V25.xx / Succession switch without having to use MAT or OTM etc, using the information obtained via the CPND Name block in LD 95. You can also add in other CPND Names from other systems if they use Network Linked Numbering onto the same csv file.
Print off & capture the CPND name block such as..
LD 95 REQ PRT TYPE NAME CUST 0 CPND_LANG PAGE DIG DN ALL SHRT YES
5200 Welfare Room 5201 Rest Room 5202 Delivery & Collections 5208 Donald Duck I2050 5209 Micky Mouse I2050 Phone 5230 Tom's MODEM 5234 Jerry's I2050 Phone 5235 Roger Rabbit's I2050 phone 5236 Mini Mouse's MODEM 5237 Bugs Bunny I2004 Phone
Save the file as a standard Text format i.e. names.txt. Edit the file to leave it with just the DN & Name. Using "Notepads" find & replace, it's easy to get it to find 5 spaces & replace it with 4 spaces & a ",". The messy bit is to put in a comma "," between the first & second name & to remove any part of a name that's not required. This will take you a while to complete.
Once you have done this it should look something like this..
5200 , Welfare, Room 5201 , Rest, Room 5202 , Delivery , Collections 5208 , Donald, Duck 5209 , Micky, Mouse 5230 , Tom's, Modem 5234 , Jerry's, I2050 Phone 5235 , Roger, Rabbit 5236 , Mini, Mouse 5237 , Bugs, Bunny
Save this file as a "CPDIR0.CSV". The idea being that this file will eventually be uploaded into the Nortel switch. Before we do this we will need to open the file by using Excel. The layout of the columns have to be changed as follows..
Last Name , First Name , DN , ORG (Which means...)
Room,Welfare,5200,ORG Room,Rest,5201,ORG Collections,Delivery,5202,ORG Duck,Donald,5208,ORG Mouse,Micky,5209,ORG Modem,Tom's,5230,ORG I2050 Phone,Jerry's,5234,ORG Rabbit,Roger,5235,ORG Mouse,Mini,5236,ORG Bunny,Bugs,5237,ORG
Before saving this file, highlight all of the columns & select the “sort” option. Click on column “A”, so that the Name data is arranged in alphabetical order. Also try & remove any spaces before & after the ",“ . The result should be something like this..
Bunny,Bugs,5237,ORG Collections,Delivery,5202,ORG Duck,Donald,5208,ORG I2050Phone,Jerry's,5234,ORG Modem,Tom's,5230,ORG Mouse,Micky,5209,ORG Mouse,Mini,5236,ORG Rabbit,Roger,5235,ORG Room,Welfare,5200,ORG Room,Rest,5201,ORG
Finally save the amended cpdir0.csv file & upload it into the system. Go into "pdt" and navigate to the "db" folder by using "c:/u/db" or "cd /u/db". Use the "pdt" command "rx cpdir0.csv" to upload the your cpdir0.csv file. After it's been uploaded, Check that it works by using the Corporate Directory function. If it doesn't, then use the "pdt" symload & INIT_CORP_DIR. Or UPDATE_CORP_DIR for Version 4.5.
e.g.
pdt> symload Loading symbols from "c:/p/sl1/res.sym" pdt> INIT_CORP_DIR value = 1 = 0x1 pdt> Total number of files 1 0 c:/u/db/CPDIR0.CSV Reading the corporate directory file for customer: 0 538 entries read for customer 0.
pdt>
Another useful tip that I have just received from another tek-tips member, Andras888 is this info below. I did not use the FTP feature because my switch is not on the network (CLAN). Instead I used a floppy disk, with the following command: pdt> cp /f0/cpdir0.csv .
Check the Corporate Directory function again & it should display your names. If is does not, then make sure that you have set all of your sets with a “CLS” = “CRPA”. Check in LD 81 for sets which have the CLS = CRPD & make the changes as required.
>LD 81 REQ LST CUST 0 DATE PAGE DES FEAT CRPD FEAT
CRPD 00 TN 064 0 00 01 PCA PCA 2 NOV 2004 CRPD 00 TN 064 0 00 03 PCA PCA 22 JUL 2004
NACT ****
|