NUMSysCMDLauncher – Bulk User/Group Import/Modify/Delete from command line


This was something I always wanted to do, however kept skipping this. However I had a compelling reason to finish this on Friday.

Scott, this is my Guru Dakshina.

Some of the people who know me (which is a very few) knows that I started with Hyperion Web Analysis (which I still love) World wide support team. However they don’t know that Scott Metzler and Nouria Kehli (that’s a real small circle) were the ones who introduced me to the world of Hyperion.

Scott reached out to me with a business case this Friday (which was really nice of him), where he need to import some users to Shared Services Native Groups. He’ll get those users as a file which their respective native groups. My first advice was to use LCM and I know that Scott was going to say the following.

When you try to use LCM for importing users/groups the migration option is set to create/update. Once that option is set and you try to import new users to existing groups, the old users will be overwritten.

I know I can change that behavior in the API whether to overwrite or merge. I always wanted to give NUMSys a command line interface and I thought why not do it right here, right now :).

This is my way of saying Thank you Scott

You can use NUMSysCMDLauncher to import users/groups from a file now.

I’ll add this to NUMSys Web in the upcoming version. (It got delayed a lot, I know been, cray busy with lot of stuff)

NUMSysCMDLauncher 1.0 supports the following operations

  1. importuser
  2. importgroup
  3. deleteuser
  4. deletegroup

Usage is as follows

usage: NUMSysCMDLauncher
-D <-D>                               Use this if you are using encryption
-deletegroup                          Delete Group operation
-deleteuser                           Delete User operation
-encrypt <-encrypt=<encryptstring>>   Use this for encrypting strings
-file <-file=filename>                File with Users, Groups information
-help                                 prints usage
-importgroup                          Import Group operation
-importuser                           Import User operation
-p <-p=password>                      Password for connecting to Shared Services
-u <-u=username>                      Username for connecting to Shared Services

Encryption

NUMSysCMDLauncher also supports encryption and you can encrypt the entire command by navigating to the lib folder and issuing the following command


java -jar NUMSysCMDLauncher.jar -encrypt="-u=admin -p=password -deleteuser -file=C:TempHSSUsers.csv"

encryption

Copy the encrypted text to the bat file.

encrypted-bat

Import User(s)You can upload users from a file using the below given format.

impuserfile

If this is an existing user, the utility will skip the creation and switch to a modify mode.

completed-user-import-operation
Import Group(s)

You can upload groups from a file using the below given format, by default utility performs a merge option with the group’s assignment.

impgroupfile

You can perform creation of the group(s) along with group’s assignment. If this is an existing group(s) then utility will switch to modify mode.

In this example I’m creating a group called “AllAdmins” and adding “EPM Admins” group and “testuser1” user to this group.

completed-group-import-operation

You can mention the provider of the group/user, default is “Native Directory”.

Delete User/Group

You can bulk delete user(s)/group(s) by passing the username/groupname in a file

completed-user-delete-operation

completed-group-delete-operation


You can download NUMSysCMDLauncher from here

Documentation can be accessed here

I think I’ll add a new option in the next release where you can specify whether to overwrite a group assignment or perform a merge.


About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.