Create block of users 2

[jak67]

Is there any way to create a group of h323 users, with out doing it 1 by 1. I need to create 100 voip users on a system.

 

[Westi]

export them via .csv and create them there then import them again

that creates the users but not the extensions, then make extensions auto create ( by default on) and when you log them in the extensions creates itself.

Joe W.

FHandw, ACSS (SME), ACIS (SME)

http://convergednetworks.ca

Interrupt the silence only if you improve it by saying something, otherwise be quiet and everybody will be grateful.

 

[amriddle01]

It's something asked for and ignored several times



"No problem monkey socks

 

[Johan1234]

If your customers fills out a "programming book" with all his wishes, you can use some creative Excel Macro's to generate user.csv and huntgroup.csv

Even 500+ users can be added in a few mouse clicks

Johan W.
ACIS-SME
ACSS-SME
APSS-SME

 

[hairlessupportmonkey]

Do you have this marvellous Excel spread sheet to hand to share?

ACSS - SME
General Geek

 

[Johan1234]

Sorry, can't post. It's company property. I've set up 2 files. 1 for the customer to fill in. A second with the code to generate the CSV's with.

To get you started i can show you some of de macro programming. After the part below, all columns are merged together with a comma seperating the data, and stored as a CSV file. Columns are filled in order:
1. Group Name
2. Extension
3. Ringmode (seq, coll, coll CW, etc..)
4. Queing (y/n)
5. Voice mail (y/n)
6. VM Broadcast (y/n)
============================

Sub Export_Groups()
k = 1
While Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 1) <> ""
GrRingMode = Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 3)
Select Case GrRingMode
Case "Collective"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 3) = "1,0,0,0"
Case "Sequential"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 3) = "0,1,0,0"
Case "Rotary"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 3) = "0,0,1,0"
Case "Longest waiting"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 3) = "0,0,0,1"
End Select

GrQueueing = Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 4)
Select Case GrQueueing
Case "Yes"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 4) = "1"
Case "No"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 4) = "0"
End Select

GrVoiceMail = Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 5)
Select Case GrVoiceMail
Case "Yes"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 5) = "1"
Case "No"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 5) = "0"
End Select

GrVMBroadcast = Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 6)
Select Case GrVMBroadcast
Case "Yes"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 6) = "1"
Case "No"
Workbooks("Config Conversion").Sheets("Huntgroup").Cells(k, 6) = "0"
End Select

k = k + 1
Wend
End Sub

Johan W.
ACIS-SME
ACSS-SME
APSS-SME

 

[TouchToneTommy]

Have a look at the IP Office Pre-Installation Data Gathering Workbook on Kyle's site.

Go to Format | Sheet | Unhide | Configuration.csv

Set up the User and Extension tab with the extensions in the order of the hardware in the system. This means filling in Analog stations in the middle of a list of Digital users, like when you have a Combo Card. But when you are done, unhide the configuration tab.

Export the configuration from the IPO. Open it in Excel. Delete everything up to Extension_Info_Start, and everything after User_Info_End

Copy and paste the columns from the Pre-Install Workbook to the exported configuration file. You'll have to copy the extension numbers to TWO places, one in Extension_Info, and the other in User_Info.

Save as csv, open in Notepad, delete all of the commas after Extension_Info_Start, Extension_Info_End, User_Info_Start, and User_Info_End.

Save that, import it into the IPO, and watch the extension numbers and Users change. Send config and reboot, and you're done.