Need help creating batch file

[dwayne rattan]

HI,

Prime Collaboration is new to me. I have recently installed it on a UCS 220 server and added CUCM 9.1 to device setup. However, I do not know how to create the batch upload file. I have used

Order Type          User ID          Firstname          LastName          ProductName          Service Area          MacAddress          PhoneType          PhoneButtonTemplate

as my heading and saved it as a tab delimited file but it says no headers provided. Any Ideas ? And can you also provide some guidaince in obtaining the sample batch file.

Regards

Dwayne Rattan

[Anthony Gerbic · Accepted solution]

Dwayne,

I don't see the Doman heading in the list above. This may be causing the problem. Below is an example I have used:

OrderType    UserID    FirstName    LastName    Domain    ProductName    Phone Type    ServiceArea    MAC Address    Phone Button Template    Line Type    Voicemail Alias    Voicemail Display Name

add    rsmith4    Richard    Smith4    CISCOUS    Enhanced Phone Service    Cisco 7960    Atlanta    123456789096    Standard 7960 SCCP    Auto-Assigned Line    rsmith4    Richard

add    ksmith4    Kathy    Smith4    CISCOUS    Enhanced Phone Service    Cisco 7960    Atlanta    123456789100    Standard 7960 SCCP    Auto-Assigned Line    ksmith4    Kathy Smith

add    ssmith4    Susan    Smith4    CISCOUS    Enhanced Phone Service    Cisco 7960    Atlanta    123456789104    Standard 7960 SCCP    Auto-Assigned Line    ssmith4    Susan

add    djames    Don    James4    CISCOUS    Enhanced Phone Service    Cisco 7960    Atlanta    123456789108    Standard 7960 SCCP    Auto-Assigned Line    djames4    Don

Below is an example of a mixed order type batch where mulitple things are being done:

OrderType    UserID    FirstName    LastName    Domain    ProductName    Phone Type    ServiceArea    MAC Address    Phone Button Template    Line Type    Processor    Name    Director Number Info     

add    ksmith    Kathy    Smith    CISCOUS    Enhanced Phone Service    Cisco 7961    Atlanta    123456789100    Standard 7961 SCCP    Auto-Assigned Line              

add    ssmith    Susan    Smith    CISCOUS    Enhanced Phone Service    Cisco 7970    Atlanta    123456789104    Standard 7970 SCCP    Auto-Assigned Line              

add    djames    Don    James    CISCOUS    Phone Service    Cisco 9971    Atlanta    123456789108    Standard 9971    Auto-Assigned Line              

add    icadmin    IC    Administrator    CISCOUS    Call Pickup Group        Atlanta                CUCM-CiscoUnifiedCM    CPG1    3500/ Berkeley_Part_911    

deleteuser    rsmith        Smith    CISCOUS                                      

deleteuser    bclark        Clark    CISCOUS                                      

This example will show how you can mix the order types keeping common headers across the batch.

Hopefully this will get you going.

[dwayne rattan]

It was the Domain Thanks I put it in and it worked. But now after I provsion the Phone as such :

OrderType	UserID	FirstName	LastName	Domain	ProductName	Phone Type	ServiceArea	MAC Address	Phone Button Template	Line Type	Directory Number
add	drattan123	Dwayne	rattan123	TTPS_POS	Phone	Cisco 7912	Charge_Room	0011927c04d3	Standard 7912 SCCP	Chosen Line	1203

the phone registers but the line number does not come up and it says the line has reached its' limit. Could I be using the wrong productname or type ?

Regards

Dwayne

[Anthony Gerbic · Accepted solution]

Dwayne,

It is the product name. You asked it to add just a phone. If you want a phone and a line in the same order then order "phone service". The batch function for user service follows the base and bundles you see in the Subscriber Role UI.

Base Products:	Client User Settings Email Enable Mobility Support Enable Presence Enable Presence Client Enable SoftPhone Support Extension Mobility Access Extension Mobility Line Line Line on a Shared Phone Phone Remote Destination Profile Remote Destination Profile Line Unified Messaging User Services Voicemail

Product Bundles:

Enable Client Service (Includes Client User Settings and Enable Presence Client) Enhanced Mobility Service (Includes Voicemail, Extension Mobility Access and Extension Mobility Line) Enhanced Mobility Service with Unified Messaging (Includes Email, Voicemail, Unified Messaging, Extension Mobility Access and Extension Mobility Line) Enhanced Phone Service (Includes Phone, Voicemail and Line) Extension Mobility Access with Line (Includes Extension Mobility Access and Extension Mobility Line) Jabber Service (Includes  Cisco Unified Client Services Framework, User Services, Cisco Jabber  for Tablet, Cisco Dual Mode for Android, BlackBerry                                                                   MVS  Client and Cisco Dual Mode for iPhone) Messaging Service (Includes Phone, Email, Voicemail and Line) Phone Service (Includes Phone and Line) Presence Service (Includes Client User Settings, Enable Presence Client and Enable Presence) Remote Destination Profile Service (Includes Remote Destination Profile and Remote Destination Profile Line) Single Number Reach Service (Includes Remote Destination Profile, Enable Mobility Support and Remote Destination Profile Line) Unified Messaging Service (Includes Phone, Email, Voicemail, Unified Messaging and Line) Voicemail and Email Service (Includes Email and Voicemail)

Regards

[dwayne rattan]

Hey thanks again that was the main reason. Is there a way to delete phones that is their MAC's I have deleted users but when i try to upload the phone again it tells me the mac is duplicated.

[Anthony Gerbic]

Yes. Use the cancel phone before using the add phone

OrderType    UserID              ServiceArea              ProductName    Object Name

cancel         SampleUser1    SampleServiceArea    Phone              00001000000a

cancel         SampleUser2    SampleServiceArea    Phone              00001000000b

[dwayne rattan]

The quick site builder when I click on it, it opens up in another window but I can't do anything any ideas

[Anthony Gerbic]

You first need to choose a domain or create a new one. Then click on Configure Service Area.

You will then see the rows to create service areas. You work on these till you are confident they are set the way you want them, perhaps copying some and making minor changes. When you are satisfied submit the job and it will do the work of setting the service areas up. It will take a few minutes to complete and the UI will remain during the provisoining process.

Regards

[dwayne rattan]

Hey

I know its been a while, but I now want to provsion a couple hundred phones and would llike to know how do I put in the display name,ascii alerting name, line text label, CSS and route partition into the batch file.

[saifuddin]

Hi Anthony,

Could you please help me how to create the batch file which can help us to add/edit phones in CUCM10.x.

It would be really helpful if you share the steps from scratch as batch is new for me.

Thanks & Regards,

Saif