CUCM5, insert phones/users using BAT, got error

[xiaoliangyue]

Insert Phones/users

Begin Time : 12/11/2007 11:05:53

Query :

Insert Phones/Users in lmc_phone_users_Dec11_2007.txt

Failure Details :

Device Name/User ID Error Code Error Description

-----------------------------------------------------------------------------------------

001D45B5E7D9 EXTENSION MOBILITY :: Error : Could not insert new row - duplicate value in a UNIQUE INDEX column.

Please help. Thanks

[Tommer Catlin]

Check your CSV File, I have n noticed lately that the column headers have a space before the first letter. This throws off the entire import then.

Also, do a double check. Open the CSV file in notepad, count the commas and fields. It should add up to 36 I believe. If you see commas missing, that is why.

YOu may also have to use the device format as SEP001D45B5E7D9

[xiaoliangyue]

Thanks, Tommer. I actually tried to add 10 phones/users, only the 1st failed with the above error msg.

[Tommer Catlin]

Can you copy and paste the raw Notepad for that one phone here?

[xiaoliangyue]

FIRST NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,DEVICE NAME,DESCRIPTION,CSS,DEVICE POOL,DIRECTORY NUMBER 1,FORWARD BUSY EXTERNAL DESTINATION 1,FORWARD BUSY INTERNAL DESTINATION 1,FORWARD NO ANSWER EXTERNAL DESTINATION 1,FORWARD NO ANSWER INTERNAL DESTINATION 1,PARTITION 1,ALERTING NAME 1,ALERTING NAME ASCII 1,SPEED DIAL NUMBER 1,SPEED DIAL LABEL 1,SPEED DIAL LABEL ASCII 1

,Desk1,41861,12345,,,12345,,,41861,,,,,,,,001D45B5E7D9,LMC Desk1,CSS_LMC_Unrestricted,,41861,,,,,,,,,,

[Tommer Catlin]

Yeah, the device name is not unique or it is not the correct format. Also make sure the UDP was already created. If it's not created, then you cant associated it to the line, etc.

[allan.thomas · Accepted solution]

Verify that the UDP name is unique, that it does not already exist. For example if you are using numerics for UDPs, then search device profiles for this same profile name.

Regards

Allan.

[xiaoliangyue]

Thanks Guys. It was UDP issue. resolved.

[allan.thomas]

No problem, good to hear you resolved the problem, appreciate the rating, thanks.

Best regards and seasons greetings.

Allan