Grouper Users - Open Discussion List

[Dominique Petitpierre <>]

Hello,

On 03/14/2013 05:04 AM, Chris Hyzer wrote:
...
> > - Reporting: extract various informations from the exported file for
> >     the purpose of checking (e.g. diff), documenting or doing statistics.
>
> Are there things that can be done with XML that cannot easily be done with 
> SQL?

Certainly SQL is better suited; I was anyway talking about one off
quick and dirty extractions with tools like grep, sed, awk, perl.

Personally I would prefer to leave the DB as a black box and use
Grouper supplied tools instead of reverse engineer how Grouper stores
things in the DB. In case I change my mind, beside the schema and the
source code,
- is there a document that describes the hows and whys of the DB?

The old style xmlexport has the advantage that its output is close to
the UI view of groups (sequential, nested).

...
> > Just to be sure, with gsh -xmlimport,
> > - is it OK to import an object that has a new name (e.g. it has been
> >     edited by hand in the exported xml file) but has the same UUID as an
> >     existing object?
>
> No, it will rename the existing record I think... if you rename in XML, you 
> should change the UUID, which and search and replace it, which isn’t 
> convenient

OK.

That is why I was concerned about uuid still appearing in the xml file
exported by the old style xmlexport even though the property
export.uuids=false, the original purpose of this thread!


--
Meilleures salutations,
Dominique Petitpierre

* Unsolicited commercial email is NOT welcome at this address. *
Mr Dominique Petitpierre       Email: 
User@Domain
IT Division                    User=Dominique.Petitpierre
University of Geneva                  Domain=unige.ch
24 rue General-Dufour          Voice: +41 (0)22 37 97117
CH-1204 GENEVA                 Fax  : +41 (0)22 37 97986
(Switzerland)                  WWW  : http://www.unige.ch/dinf/