Eric,
Eric Dalquist wrote:
Drew,
I just finished going through the export scripts and giving the exported
files 'pretty' file names and putting each type in its own directory. I
also ran the crn dbunload to see what data is being unloaded there. I
did find one problem where in the list of tables to export there was the
entry 'UP_USER,UP_CHAN_TYPE' which I assume is supposed to be 'UP_USER',
'UP_CHAN_TYPE'
Good catch.
Once I changed that I went through the data.xml and wasn't sure if all
the tables being unloaded are needed.
- UP_USER appears to be taken care of by the export-user.crn and
export-layout.crn scripts.
** Long-winded Explanation **
There are 4 objects in uPortal that must have specific database Ids due
to hard-coded or configuration values that refer to them. They are:
- the 'system' user (id=0)
- the 'Everyone' group (id=0)
- the 'Portal Administrators' group (id=14)
- the 'All Channels' group (id=50)
Since these object *must* have these Ids, they are included in data.xml.
In fact, the dbunload.crn file that creates the data.xml doesn't even
go to the database at all to export these objects -- rows for these
objects are defined in the .default-data.xml series of files.
There is also a UP_SEQUENCE.default-data.xml file that defines the
sequences used by uPortal and starts them at appropriate values.
- UP_CHAN_TYPE appears to be taken care of by export-channel-type.crn
Yep -- if you're checking .channel-type files into
properties/db/entities/, you shouldn't need to unload from the
UP_CHAN_TYPE table here.
If you make this change, you may also wish to roll the 'UP_CHAN_TYPE'
sequence in UP_SEQUENCE.default-data.xml back to 1 (currently 100).
- UP_USER_PROFILE appears to be taken care of by export-user.crn
(See "Long-winded Explanation above.")
- UP_SS_STRUCT and UP_SS_STRUCT_PAR appears to be taken care of by
export-structure.crn
Yep -- if you're checking .structure files into properties/db/entities/,
you shouldn't need to unload from the UP_SS_STRUCT or UP_SS_STRUCT_PAR
tables here.
If you make this change, you may also wish to roll the 'UP_SS_STRUCT'
sequence in UP_SEQUENCE.default-data.xml back to 1 (currently 100).
- UP_SS_THEME and UP_SS_THEME_PARM appears to be taken care of by
export-theme.crn
Yep -- if you're checking .theme files into properties/db/entities/, you
shouldn't need to unload from the UP_SS_THEME or UP_SS_THEME_PARM tables
here.
If you make this change, you may also wish to roll the 'UP_SS_THEME'
sequence in UP_SEQUENCE.default-data.xml back to 1 (currently 100).
- UP_ENTITY_TYPE appears to be taken care of by export-entity-type.crn
Yep -- if you're checking .entity-type files into
properties/db/entities/, you shouldn't need to unload from the
UP_ENTITY_TYPE table here.
If you make this change, you may also wish to roll the 'UP_ENTITY_TYPE'
sequence in UP_SEQUENCE.default-data.xml back to 1 (currently 100).
- UP_GROUP appears to be taken care of by export-group.crn
(See "Long-winded Explanation above.")
Could you verify that we can just drop these tables from the data.xml
export since we have entity XML files for them?
All of my changes are committed so running a:
ant crn-export -Ddir=myData -Dtype=all
ant crn-make-data-xml
I've updated.
Would you like me to handle these? I could probably take care of it by
tonight, if it would help.
drew
--
Andrew Wills
UNICON, Inc.
Office: (480) 558-2476
http://code.google.com/p/cernunnos/
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions: The
Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
Subscribe to the conference blog, The Community Source Way
http://jasig2008.blogspot.com, for news and updates about the event.
Join the Conference networking site at http://ja-sigspring08.crowdvine.com/
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
