Installing a Corporate Directory without using OTM / MAT

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 ****