Problem with BAT - Import/Export file format CUCM 8.6.2.20000-2

[Rune Heggelund]

Hi!

If I Export all Directory Number (Unassigned) the file format created by CUCM is as follow;

DIRECTORY NUMBER,ROUTE PARTITION,DESCRIPTION,ALERTING NAME,ASCII ALERTING NAME,VOICE MAIL PROFILE,CALLING SEARCH SPACE,PRESENCE GROUP,USER HOLD MOH AUDIO SOURCE,NETWORK HOLD MOH AUDIO SOURCE,AAR VOICE MAIL,AAR DESTINATION MASK,AAR GROUP,RETAIN THIS DESTINATION IN THE CALL FORWARDING HISTORY,CALLING SEARCH SPACE ACTIVATION POLICY,FORWARD BUSY INTERNAL VOICE MAIL,FORWARD BUSY INTERNAL DESTINATION,FORWARD BUSY INTERNAL CALLING SEARCH SPACE,FORWARD BUSY EXTERNAL VOICE MAIL,FORWARD BUSY EXTERNAL DESTINATION,FORWARD BUSY EXTERNAL CALLING SEARCH SPACE,FORWARD NO ANSWER INTERNAL VOICE MAIL,FORWARD NO ANSWER INTERNAL DESTINATION,FORWARD NO ANSWER INTERNAL CALLING SEARCH SPACE,FORWARD NO ANSWER EXTERNAL VOICE MAIL,FORWARD NO ANSWER EXTERNAL DESTINATION,FORWARD NO ANSWER EXTERNAL CALLING SEARCH SPACE,FORWARD NO COVERAGE INTERNAL VOICE MAIL,FORWARD NO COVERAGE INTERNAL DESTINATION,FORWARD NO COVERAGE INTERNAL CALLING SEARCH SPACE,FORWARD NO COVERAGE EXTERNAL VOICE MAIL,FORWARD NO COVERAGE EXTERNAL DESTINATION,FORWARD NO COVERAGE EXTERNAL CALLING SEARCH SPACE,FORWARD ON CTI FAILURE VOICE MAIL,FORWARD ON CTI FAILURE DESTINATION,FORWARD ON CTI FAILURE CALLING SEARCH SPACE,FORWARD UNREGISTERED INTERNAL VOICE MAIL,FORWARD UNREGISTERED INTERNAL DESTINATION,FORWARD UNREGISTERED INTERNAL CALLING SEARCH SPACE,FORWARD UNREGISTERED EXTERNAL VOICE MAIL,FORWARD UNREGISTERED EXTERNAL DESTINATION,FORWARD UNREGISTERED EXTERNAL CALLING SEARCH SPACE,NO ANSWER RING DURATION (SECONDS),TARGET (DESTINATION),MLPP CALLING SEARCH SPACE,MLPP NO ANSWER RING DURATION (SECONDS),HOLD REVERSION RING DURATION (SECONDS),HOLD REVERSION NOTIFICATION INTERVAL (SECONDS),ACTIVE,PARTY ENTRANCE TONE,PARK MONITOR FORWARD NO RETRIEVE EXT DESTINATION,PARK MONITOR FORWARD NO RETRIEVE INT DESTINATION,PARK MONITOR FORWARD NO RETRIEVE INT VOICE MAIL,PARK MONITOR FORWARD NO RETRIEVE EXT VOICE MAIL,PARK MONITOR FORWARD NO RETRIEVE EXT CSS,PARK MONITOR FORWARD NO RETRIEVE INT CSS,PARK MONITORING REVERSION TIMER,FORWARD ALL VOICE MAIL 1,FORWARD ALL DESTINATION 1,FORWARD ALL CALLING SEARCH SPACE 1,SECONDARY CALLING SEARCH SPACE FOR FORWARD ALL 1,CALL PICKUP GROUP

When I try to import the same file witout changing it, the import fail with the following error;

Import Configuration

Begin Time : 11/09/2011 12:32:40

Query :

IMPORT Directory Number (Unassigned) IN directorynumber.csv

Failure Details :

directorynumber          Error Code          Error Description

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

directory number is not a supported field.

java.lang.NullPointerException

The DIRECTORY NUMBER Colum is excacty the same as is was when it was exported.

Any one know what the correct value for DN is?

Bug?

[Rob Huffman]

Hi Rune,

I had a look at the associated bugs for CUCM 8.6/BAT and don't see any

that would seem to be hitting you here. A couple of questions though, if

you are working with unassigned DN's have they been removed from CUCM

(Route Plan) before trying the import? When doing the import has a Line template

been added to go along with the phone template?

Cheers!

Rob

[Rune Heggelund]

Hi Rob!

This is an import of lines without any phones.

I am able to import lines along with the phone template, and then delete the phone afterwards, but then the line is set to Active = NO.

I now have to manually set the lines to active via the Web GUI.

I have about 1500 lines without any phone so I wanted to use BAT for this..

[Brian W.]

I know this is very old thread.  But did you ever find a solution to this?

Thanks