cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
379
Views
0
Helpful
1
Replies

INSERT for 1 PHONES could not be processed for BAT

Md Saifuddin
Level 1
Level 1

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 1

heathrw
Level 4
Level 4

 

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