Grouper Users - Open Discussion List

["Dr. Loris Bennett" <>]

This is what I have come up with:

        select replace(name,':auto',':all') as group_name,
        replace(display_name,'auto','all') as group_display_name,
        'loader "all" group' as group_description from grouper_groups_v

This works for Postgres and I assume something similar is possible with
other DBs.

Loris 


On Mon, 2009-03-09 at 10:07 +0100, Dr. Loris Bennett wrote:
> Hi Chris,
> 
> I finally got round to trying this out. It works fine for my SOR groups.
> In this case I have already created the folder hierarchy and the empty
> SOR groups and just let the loader fill them.
> 
> In the case of the roll-up groups, the loader creates the groups so
> there is no preexisting information about the display name. Here, too,
> one solution wold be to create empty groups in advance.
> 
> However, I was wondering whether there is any alternative to this. I am
> thinking along the lines of taking the display name of the SOR group in
> the folder and replacing the SOR bit of the display name with some
> roll-up identifier, i.e. 
> 
>       My Org Unit (SOR) -> My Org Unit (all) 
> 
> This should be possible with a bit of SQL jiggery-pokery, right?
> 
> Loris
> 
> On Tue, 2008-12-09 at 03:25 -0500, Chris Hyzer wrote:
> > This is done and unit tested for RC2.
> > 
> > https://bugs.internet2.edu/jira/browse/GRP-195
> > 
> > There is a new grouper loader attribute called grouperLoaderGroupQuery, 
> > where you write a query with a row for each group in a group list, and 
> > with one mandatory column "GROUP_NAME", and two optional columns: 
> > "GROUP_DISPLAY_NAME" (note, the UI term for this is display path, this 
> > includes display extensions for all parent folders), and 
> > "GROUP_DESCRIPTION".
> > 
> > Here is the doc for this attribute in the grouper loader doc:
> > 
> > grouperLoaderGroupQuery: query (optional) for SQL_GROUP_LIST which should 
> > return cols: group_name, group_display_name (optional), group_description 
> > (optional) which if there are used for the group display and and 
> > extension. Note: the parent stem display names are only changed when 
> > creating them. This should return all groups in the membership list, and 
> > if not there, its ok, the extension will be used as display extension, 
> > and a generated description. Note: the display name is the display path, 
> > with the display extension of each parent stem.
> > 
> > Note: I added this to the change log:
> > 
> > #  2008/12/9: v1.4.0 RC2 HEAD: if you are using grouper loader, and you 
> > are not auto creating types and attributes in grouper config, then add 
> > this new attribute with GSH:
> > 
> >     * subj=SubjectFinder.findById("GrouperSystem")
> >       sess=GrouperSession.start(subj)
> >       type=GroupType.createType(sess, "grouperLoader")
> >       read=Privilege.getInstance("read")
> >       admin=Privilege.getInstance("admin")
> >       type.addAttribute(sess, "grouperLoaderGroupQuery", read, admin, 
> > false)
> > 
> > 
> > When the group loader auto creates groups in the sql list, there is a new 
> > attribute where you can set group metadata (display name and 
> > description). Note: the display name is the display path, with the 
> > display extension of each parent stem.
> > 
> > Regards,
> > Chris
> > 
> > > -----Original Message-----
> > > From: Dr. Loris Bennett
> > > Sent: Tuesday, November 18, 2008 3:00 AM
> > > To: Chris Hyzer
> > > Subject: RE: [grouper-users] grouperLoader: Setting display name
> > >
> > > An extra columns sounds good. If the complete display name, e.g.
> > >
> > >         fu-berlin:central_services:computer_centre:auto|FU
> > >         Berlin:Central Services:Computer Centre:automatic|123456
> > >
> > > would that form a reasonable basis for setting display names for the
> > > folders and groups?
> > >
> > > Loris
> > >
> > > On Mon, 2008-11-17 at 13:23 -0500, Chris Hyzer wrote:
> > > > Currently there is not a way... how would you want to do it?  Another
> > > column in the membership query for group_display_name?
> > > > Or another way to translate (another query, or hook)
> > > >
> > > > Chris
> > > >
> > > > > -----Original Message-----
> > > > > From: Dr. Loris Bennett
> > > > > Sent: Monday, November 17, 2008 9:59 AM
> > > > > To: Grouper Users Mailing List
> > > > > Subject: [grouper-users] grouperLoader: Setting display name
> > > > >
> > > > > Hi,
> > > > >
> > > > > If I generate a whole hierarchy of folders with grouperLoader, is
> > > there
> > > > > any way to set the display names of the folders at the same time?
> > > > >
> > > > > Currently I am generating the folder hierarchy separately to set
> > > the
> > > > > display names and then allowing grouperLoader just to add the
> > > groups.
> > > > >
> > > > > Regards
> > > > >
> > > > > Loris
> > >
> > 
-- 
Dr. Loris Bennett (Mr.)
Freie Universität Berlin
ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
Compute & Media Service
Fabeckstr. 32, Room 221
D-14195 Berlin
Tel ++49 30 838 51024
Fax ++49 30 838 56721
Email 

Web www.zedat.fu-berlin.de