Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

INSERT for 1 PHONES could not be processed for BAT

Hi All,

I am trying to upload the file .csv to CUCM for configuring phones in a bulk but ending with a error as "INSERT for 1 PHONES could not be processed'.

Could some one guide me how will be the csv file format for inserting phones in CUCM without using the .xlt file

Thanks in advance!!

Regards,

Saif

1 REPLY
Bronze

 Hi,Traditionally I have used

 

Hi,

Traditionally I have used a phone template and phone format along with the CSV most new deployments have single model phones or minimal meeting room phones so easier to configure manually. But this should get you started.

 

Go to Bulk Admin -> Phone File Format -> Create File Format

Add a new file format based upon add the fields you want to populate, make sure the maximum number of lines is at least one,  save it

Some Example Fields: DEVICE NAME,DESCRIPTION,DEVICE POOL,LOCATION,OWNER USER ID,DIRECTORY NUMBER 1,ASCII ALERTING NAME 1,ASCII DISPLAY 1,ASCII LINE TEXT LABEL 1,ALERTING NAME 1,DISPLAY 1,LINE TEXT LABEL 1

 

Go to Bulk Admin -> Phone File Format -> Add File Format

Drop Down Box Format File Name select the file format you just created, then click the hyper link View File Format to the right, there will then be a pop up which will have all the headings.

 

Copy and paste this into a notepad, save as CSV then open in excel add users as needed

Re-import CSV to UCM and add the file format to the CSV

 

Import the phones against the phone button template.

There are other items you would want to do now is owner ID, assign to user for CTI control, etc with other BAT utilities.

Hope this helps

31
Views
0
Helpful
1
Replies
CreatePlease to create content