Page 1 of 1

Creating Users/Groups with CSV-import

Posted: Mon Apr 19, 2010 8:50 am
by Toto
Hello,

I want to create users and groups and all the settings with an import.
What are the necessary steps?
I would guess the first step is to insert the new users in the }client-dimension, then insert new groups in the }groups-dimension, then make the connection users to groups.

Are there any important steps between I am missing?
Would you recommend to get one big csv with all settings (user, user properties, user settings, groups, users2groups etc.) inside?

Thanks a lot,

Toto

Re: Creating Users/Groups with CSV-import

Posted: Mon Apr 19, 2010 12:04 pm
by lotsaram
Adding elements directly to the }Clients dimension and }Groups dimension and sending strings to the }ClientGroups cube will add the objects but more then likely all the changes to the security model will only take effect on a server restart. To correctly add users and groups to both the security model and the control objects you need to use the relevant security functions:
AddClient(ClientName);
AddGroup(GroupName);
AssignClientToGroup(ClientName, GroupName);

Note that you will need to change the GroupsCreationLimit tm1s.cfg parameter as the default maximum number of groups that can be created in a server session is 20.