Forum Discussion

prachetan's avatar
prachetan
New Contributor II
2 years ago

Security users update

hi ,

i am trying to add the users in OneStream planning application,

how to add the bulk users in OneStream, tried with extract xml file and copied that in Excel but formatting is not supporting. 

Note: External authentication Provided is AzureSSO

Thanks in Advance

  • The "User Management Console" solution (in Marketplace) has an Import Users feature that accepts a very simple comma-separated (csv) format with three fields. CSVs can be created and manipulated in Excel. It's also included in the "Cloud Administration Tools" solution.

    The "Sample Templates" solutions also allows to set up security for multiple users in Excel.

    For something a bit more complex, there is the "Provision Request Manager" solution, that basically monitors an SQL database table that you define and manage.

    In the worst case, you can always open the extracted XML in a real text editor (Notepad++ , jEdit...). The XML is indented, so it should be pretty easy to manipulate by copypasting rows.

     

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    The "User Management Console" solution (in Marketplace) has an Import Users feature that accepts a very simple comma-separated (csv) format with three fields. CSVs can be created and manipulated in Excel. It's also included in the "Cloud Administration Tools" solution.

    The "Sample Templates" solutions also allows to set up security for multiple users in Excel.

    For something a bit more complex, there is the "Provision Request Manager" solution, that basically monitors an SQL database table that you define and manage.

    In the worst case, you can always open the extracted XML in a real text editor (Notepad++ , jEdit...). The XML is indented, so it should be pretty easy to manipulate by copypasting rows.

     

    • prachetan's avatar
      prachetan
      New Contributor II

      Thank you so much Jack, resolved the issue as you suggested.

    • prachetan's avatar
      prachetan
      New Contributor II

      Thank you so much JackLacava, let me try that solution and will let you you.