Add new users and groups to CMS using SQL

system · September 16, 2009, 10:08am

Hi,

We are embedding WebI 3.1 into our web-based app as the reporting component.

How do I add new users and groups that have been added to our application into the CMS using SQL?

If it not possible to add new users and groups using SQL then what are my alternatives?

Thanks,
Chris

ChristianKey (BOB member since 2008-09-19)

SebastienGoiffon · September 16, 2009, 10:19am

You can’t use SQL script. You must use BO sdk…

system · September 16, 2009, 10:25am

I can see that we can use the ‘Import Wizard’ to import a text file (which could be generated using SQL) containing the users and groups that require adding.

Is it possible to automate the Import Wizard via a command line for example?

Or perhaps another way could be to use the BIAR Command Line Tool to automate importing users and groups?

Any views anyone?

ChristianKey (BOB member since 2008-09-19)

system · September 16, 2009, 1:09pm

It’s a JSP exercise. We built an app that allows us to add multiple users from one screen.

It’s posted here: BOXI R2 Bulk User-Group management Tool It should give you some ideas.

Steve Krandel (BOB member since 2002-06-25)