As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Is there any way of creating or updating users in Managed Reporting, with a script, or some other automated method? I have over 150 users to create for our upcoming project rollout. I really don't want to have to create them all manually.
I did find the BOTUPROF table in the ReportCaster DB (SQLServer) and it has user profile info. I changed one of the user's email addy in there, then pulled that user up in Managed Reporting, but the change was not there. I realize MR and ReportCaster are two different things, but I was hoping there were some tables for MR that I could write a script against.This message has been edited. Last edited by: Scott W.,
WebFOCUS 7.6.9 Windows Server 2003
Posts: 23 | Location: Nashville | Registered: April 10, 2009
Barring that setting MR Security to a DBMS and SQL inserts is probably the next most likely, though I believe technically not supported.
If you go this route, be sure to clear the cache in the WebFOCUS Admin Console after inserting the users if you want them to show up. Alternatively, you can disable the user/group/domain cache altogether under the advanced settings of the MR Realm driver.
Scott, Unfortunately it will not change over your existing users if you switch over to using a DBMS.
As a result you would need to recreate your existing users in the DBMS as well if trying to go that route.
I don't know much about licensing, but it might be worth calling your sales rep to see what is possible. Maybe there is a trial version of web services you could try out to make sure it meets your needs.
Another possibility might be using a tool like Fiddler2 to track the creation of a user HTTP call, and seeing if you can create something that could iterate through the user's creating them from the "MR Admin Console".
In 769 I don't think there was yet CSRF protections in the MR Admin Console that would make a technique like that near impossible.
Someone else had recommended editing the HTML files in the basedir directly, and I'd strongly recommend against that technique. If you do not create the HTML files exactly like the WebFOCUS product it might work now, but give you big headaches on a migration later on.
i follow your brief instructions , it was working very well with MS-SQLServer2008. i give it a test with Sybase SQL AnyWhere . unfortunately the tables were not created even i have recived "Selected action has been completed succesfully" from the batch file.
is there any place to check the log of the tables creation?
Qalqili, Yes, if there are any problems perceived by the utility, it will log it to a MR Realm trace.
To log things even if the utility didn't think there was a problem you can turn on MR Realm traces within the WebFOCUS Admin Console: Diagnostics -> MR Realm
The traces are viewable in the MR Admin console or on the file system at: /ibi/WebFOCUSxx/logs/
When the tool actually runs, it bases itself off of the SQL files found here: \ibi\WebFOCUSxx\utilities\realm\sql\
The PREFIX within the MR Realm configuration file (e.g. SQLS2005, SQL, ORACLE) is used to find the appropriate commands within the SQL files for the table creation and data inserts.
As a result if you're using a custom PREFIX, its not going to find anything within those SQL files, and therefore it will "complete successfully" really quickly without doing anything.
If you do need to create a custom PREFIX there are two options: 1) Manually create the tables, etc, based on the SQL you see from a different database, adjusting for any SQL syntax differences.
2) Configure the settings for a default database that is very similar to your database and run the script. After the tables and data are created, you can rename that section to your custom prefix.
If going with option #2, you can do this by manually editing the \ibi\WebFOCUSxx\config\mrrealm.cfg . A # comments out a line allowing you to temporarily duplicate a section so you can add it back later.
thanks very much for your help , it was like you said the SQL Syntax was not correct when i checked the MR_Realm Trace file. i am going to do it manually to adjust what happen in MS-SQLServer to be in SybaseSQL AnyWhere.