Skip to main content
P
prachetan
Newcomer
January 10, 2023
Solved

Security users update

  • January 10, 2023
  • 1 reply
  • 0 views

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

Best answer by JackLacava

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.

 

1 reply

J
OneStream Employee
JackLacavaOneStream EmployeeAnswer
OneStream Employee
January 12, 2023

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.

 

P
prachetanAuthor
Newcomer
January 17, 2023

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

Terms & ConditionsAccessibility statement