How to see a report of all authorization packages of a user
Chrzanowski, Romola
We are re-creating all users because we are converting to LDAP. We've been told by OpenText that there is no way to modify an existing user account to become an LDAP account, and therefore must rename each existing account and then import it from LDAP. After the import, we then need to set the matching projects, modules and groups to match the original (renamed) user account.
I cannot find an RQL statement that will report all of the authorization packages of a user. I can only find how to report the authorization packages for a project, and then how to see the users and groups of an authorization package. What we need to see instead are the authorization packages for a single user.
Do you know of a way to see just the authorization packages for a single user?
Thank you.
Romola Chrzanowski
University Applications Development
University at Albany
Manuel Schnitger (OpenText)
as RQL normally just reflects the options, that are necessary for the
usage of the frontend, I don't really believe, that there is an RQL
statement, that lists all authorization packages of a user. What you
could do is: List all users/groups of a auth pack and write the users/
groups into an array or so. Then you list all users/groups and iterate
through the array. As soon as you find the user/group in such an array
you just write the name of the user as well as the name of the auth
pack. Not very fancy....I know ;-)
Best regards,
Manuel
On 12 Mrz., 15:47, "Chrzanowski, Romola" <rchrzanow...@albany.edu>
wrote:
Chrzanowski, Romola
Thanks for your suggestion. I am working on something like that. We have put our LDAP conversion on hold, pending figuring out how to set the new account to match the original. It is puzzling why Open Text does not include an export user function in Red Dot, or even a full report of a user.
We would also like to know a user's Start Page. If you happen to know how to see that through an RQL statement, I would appreciate finding that out.
Thank you.
Romola
Romola Chrzanowski
University Applications Development
University at Albany
518.437.4525
Hi Romola,
Best regards,
Manuel
--
You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group.
To post to this group, send email to reddot-c...@googlegroups.com.
To unsubscribe from this group, send email to reddot-cms-use...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
Jian Huang
I think Manuel also write a post on how to trace RQL commands via the logs, which can be used for discovering the RQL you need for the action you can perform via the interface.
Anyways, for loading the users and startpages
<IODATA loginguid="E30CC06B83F64BC182D540655A6750F5" sessionkey="E30CC06B83F64BC182D540655A6750F5"><ADMINISTRATION><SETTINGS action="load" languagevariantid="ENU" type="smarteditstartpage" projectguid="2F45C10A35DB4FEE815805D09B5029FB"></SETTINGS></ADMINISTRATION></IODATA>
For saving the users and start pages
<IODATA loginguid="E30CC06B83F64BC182D540655A6750F5" sessionkey="E30CC06B83F64BC182D540655A6750F5"><ADMINISTRATION><SETTINGS action="save" type="smarteditstartpage" smarteditstartpageguid="2FDA30ACB4B4455F9D6B87F65AE9EB19" projectguid="2F45C10A35DB4FEE815805D09B5029FB"><USERS><USER guid="24ECDF4C39444B54BC583F18894C517B"/></USERS><GROUPS></GROUPS></SETTINGS></ADMINISTRATION></IODATA>
RedDot and LDAP users are two entirely different user types. Most client plan the user type at the beginning on a project. Though user type conversion may still occur during midway, but it is usually a few users at a time, not enough to call for a product feature. If needed, you may contact support and visit www.solutionexchange.info and add the RedDot to LDAP user conversion as a feature request. Please keep in mind that like all software feature requests, the implementation priority is based on number of client requests.
The reddot plugin interface is a great way for developers like us to fill the niche feature void. I have written a plugin that mass converts RedDot to LDAP users using AJAX RQL (another Manuel post), it didn't take too long, like 2-3 weeks.
To post to this group, send email to reddot-cms-users@googlegroups.com.
To unsubscribe from this group, send email to reddot-cms-users+unsubscribe@googlegroups.com.
Manuel Schnitger (OpenText)
I think, Jian has already answered your questions. If not, then just
post your questions at www.SolutionExchange.info, our community
platform. I normally don't have a look at the Google groups every day
but get a notification whenever a new post is being send on the
SolutionExchange.
Best regards,
Manuel
On 13 Mrz., 13:45, "Chrzanowski, Romola" <rchrzanow...@albany.edu>
wrote:
Romola
that is far from elegant but if it will give me a report of all the
use information that I need, that will be good enough.
I am stuck right now trying to set the Project that I want to query
for all Authorization packages, like:
<AUTHORIZATION>
<AUTHORIZATIONS action="list" type="2"/>
</AUTHORIZATION>
The response is always for whichever Project I have set in the RedDot
interface. I need to be able to perform this query for every project
that a user may belong to. So far, I cannot find a way to set the
project through RQL (or ASP). I have looked at the session variables,
looked at the log files, tried to set the session variables for
ProjectGuid and Project, etc.
If you have any advice about how to set the project in RQL, I can move
ahead with my clumsy inelegant code.
Thanks for any suggestions.
Romola
On Mar 13, 12:50 pm, "Manuel Schnitger (OpenText)"
> Hi Romola,
>
> I think, Jian has already answered your questions. If not, then just
Jian Huang
I just thought of a method that might be faster to accomplish the reddot to LDAP user conversion.
Instead of writing an entirely automated ASP plugin, it might be faster to record the RQL for each step, then manually plugin the GUIDs and feed them into RQLConsole.
Just a thought, hope it is useful.
Best,
-Jian
> > To post to this group, send email to reddot-cms-users@googlegroups.com.
> > To unsubscribe from this group, send email to reddot-cms-users+unsubscribe@googlegroups.com.
Chrzanowski, Romola
Hello Jian,
Thanks for your help. After you provided the RQL that I needed to switch between Projects, I made good progress on the plugin to report the details of one user. It won’t be an automated conversion, but we are able to see the details of the existing user account that we then replace via import from LDAP. With more experience with plugins I might attempt to actually save changes via a plugin, but at least we are able to move forward with our LDAP conversions.
I appreciate your help and Anjam’s assistance.
Regards.
Romola
Romola Chrzanowski
University Applications Development
University at Albany
From: reddot-c...@googlegroups.com [mailto:reddot-c...@googlegroups.com]
On Behalf Of Jian Huang
Sent: Thursday, March 15, 2012 9:21 AM
To: reddot-c...@googlegroups.com
Subject: Re: How to see a report of all authorization packages of a user
Hi Romola,
> > To post to this group, send email to
reddot-c...@googlegroups.com.
> > To unsubscribe from this group, send email to
reddot-cms-use...@googlegroups.com.
> > For more options, visit this group athttp://groups.google.com/group/reddot-cms-users?hl=en.
--
You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/reddot-cms-users/-/Fxm6lvD5OJkJ.
To post to this group, send email to
reddot-c...@googlegroups.com.
To unsubscribe from this group, send email to
reddot-cms-use...@googlegroups.com.
Jian Huang
Glad to help and thank you replying back with results.
-jian