Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SMGR User Upload query

SMGR User Upload query

SMGR User Upload query

I have downloaded the excel file from SMGR required to upload bulk users. The excel file have many columns. Wanted to know which column must be filled to upload the bulk users successfully?
As i dont have all information as required in the excel file so i tried to filled out the user name/ext but file upload gave error.

RE: SMGR User Upload query

Your best starting point is to build a User manually in System Manager, then Export that User. You will then have nearly all the information ready to copy-paste for each additional user.

Some other things to consider:

User Provisioning Rules, Phone and Agent Templates are your friend so you don't have to cut and paste everything.

If you have a spreadsheet with columns of "first name", "Last Name", "Extension", and "Email Address" then you can pretty much go populate everything in the import file.
Create a 4th column and concatenate the Email Address with a Profile Name "#Primary". This will be used to identify components on different tabs.

Fields that are Required for SIP Endpoints

Basic Tab
  • Last Name
  • First Name
  • Login (I typically assign the user's corporate email address - user@company.com since it must be unique. You can also use [extension]@domain.com)
  • Communication Password (used for phone login)
Profile Set Tab
  • Login Name (same from Basic Tab)
  • Name (Name of the Profile. If only one, use "Primary". Additional Profiles are optional - "AgentID", for example)
  • Is Default (true for the Primary Profile. Additional profiles would be "false")
Handle Tab
  • Login name (This becomes the Login (email address) with #[profile name] - user@company.com#Primary)
  • Handle (SIP Handle - extension or E.164, used to log in the SIP phone)
  • Type (SIP or E.164, usually)
  • Domain (company's SIP domain - company.com)
Session Manager Profile Tab
Just about everything is required except for Conference Factory Set and Survivability Server, but fill those in if your system has them.

CM Endpoint Profile Tab
  • Login Name (user@company.com/#Primary)
  • Type (CM)
  • System (CM Name in System Manager)
  • Use Existing Endpoint (false. Set true only if the Station exists in CM but not assigned to a user)
  • Extension (same as used in the Handle)
  • Template (If you created a template all other fields will be populated based on the template. Otherwise, you'll need to fill in the remaining columns)
This should be enough to get you started. You can fill out other Tabs as necessary but again, Export a User that is exactly the way you want it to get a starting point.

RE: SMGR User Upload query

Thanks Bro, for the tip.
I will follow the steps.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close