Bulk user creation

ujjwal06it
ujjwal06it Member
edited May 23, 2012 in Documentum #1

Is there any way to create 20+ user with same groups and ACL name in one shot?

Does anyone has any simpler way to create users in Documentum aplication?

Can you share DFC code for that?

Tagged:

Best Answer

  • sudheerreddy
    sudheerreddy Member
    edited May 23, 2012 #2 Answer ✓

    Hi ujjwal,

    -->first create file with extension of dql (ex: like "user.dql")

    -->in that write this queries ..

    create dm_user object set user_name= 'dsr1',set user_source = 'inline password',set user_login_name = 'dsr1',set user_password = 'dsr1',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr2',set user_source = 'inline password',set user_login_name = 'dsr2',set user_password = 'dsr2',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr3',set user_source = 'inline password',set user_login_name = 'dsr3',set user_password = 'dsr3',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr4',set user_source = 'inline password',set user_login_name = 'dsr4',set user_password = 'dsr4',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr5',set user_source = 'inline password',set user_login_name = 'dsr5',set user_password = 'dsr5',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    -->save the file ..(ex: you saved in the path  c:\user.dql)

    -->now run the that saved script using IDQL

    --> open IDQL and give credentials.

    -->Now execute like this " @c:\user.dql "

    users will be created

    Go through the attached pdf for better understanding

    Hope this will useful for you

    Regards,

    DSR

Answers

  • DCTM_Guru
    DCTM_Guru Member
    edited May 22, 2012 #3

    You can import bulk users by creating a LDIF file.  Read Content Server Admin guide for more details.

  • dnvhariprasad
    dnvhariprasad Member
    edited May 22, 2012 #4

    else you can use dqMan - a free tool from fme.de

  • lastnitescurry
    edited May 22, 2012 #5

    Can not have a user with the same name as a group.

    You could use a DQL script to create the users and groups

    You could use an API script to create the permission sets

  • ujjwal06it
    ujjwal06it Member
    edited May 22, 2012 #6

    @All: Can you send me dql scripts for that. I dn't have maximum knowledge rather than rusty to this technology.

    I would be very grateful to you. Many thanks in advance.

  • sudheerreddy
    sudheerreddy Member
    edited May 23, 2012 #7 Answer ✓

    Hi ujjwal,

    -->first create file with extension of dql (ex: like "user.dql")

    -->in that write this queries ..

    create dm_user object set user_name= 'dsr1',set user_source = 'inline password',set user_login_name = 'dsr1',set user_password = 'dsr1',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr2',set user_source = 'inline password',set user_login_name = 'dsr2',set user_password = 'dsr2',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr3',set user_source = 'inline password',set user_login_name = 'dsr3',set user_password = 'dsr3',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr4',set user_source = 'inline password',set user_login_name = 'dsr4',set user_password = 'dsr4',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    create dm_user object set user_name= 'dsr5',set user_source = 'inline password',set user_login_name = 'dsr5',set user_password = 'dsr5',set user_address = 'helloworld@gmail.com',set client_capability= 2,set default_folder='\temp',set user_privileges =16;

    GO

    -->save the file ..(ex: you saved in the path  c:\user.dql)

    -->now run the that saved script using IDQL

    --> open IDQL and give credentials.

    -->Now execute like this " @c:\user.dql "

    users will be created

    Go through the attached pdf for better understanding

    Hope this will useful for you

    Regards,

    DSR

  • ujjwal06it
    ujjwal06it Member
    edited May 23, 2012 #8

    Thank you so much sudheer..

  • sudheerreddy
    sudheerreddy Member
    edited May 23, 2012 #9

    And also you can import users by using LDIF

    open one notepad and write the following data:

    object_type:dm_user

    user_name:dsr1

    user_group_name:docu

    user_address:dsr1

    user_os_domain:ts_server

    user_privileges:8

    acl_domain:nghi421_816

    acl_name:Global User Default ACL

    client_capability:8

    object_type:dm_user

    user_name:dsr2

    user_group_name:docu

    user_address:dsr2

    user_os_domain:ts_server

    user_privileges:8

    acl_domain:nghi421_816

    acl_name:Global User Default ACL

    client_capability:8

    save it in LDIF format(ex: user.ldif)

    Once you have created this LDIF file, do the following items:

    -Log into the Documentum Administrator

    -Click on users

    -Click on file

    -Click on Import

    -Next to the "import file path" click on browse

    -Locate the LDIP file that you created

    -Click on "Import" at the bottom

    Regards,

    DSR