Edgar Poce wrote:
Hi
I'm working on a project in which I have a test server and a
production server. In the current configuration the psml files are
stored in filesystem and the jetspeed schema in a database. When I
migrate the production server to the latest stable version I'd like to
override only a subset of information of the portal. I'd like to
override only the psml files and the portletpreferences not tied to an
specific user.
I have no problems to migrate the psml files, but I still didn't find
the way to make an sql script to copy only the portlet preferences.
making an sql script is the right approach? anyone has experience in
such use case and like to share it? in case making an sql script is a
good choice, could anyone give me some tips?, which tables are
involved?, a brief description of the data model involved in my use
case would be great
thanks in advance,
Edgar
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Preferences are stored in the PREFS_NODE and PREFS_PROPERTY_VALUE tables
Select all prefs starting with /portlet_entity/ from PREFS_NODE, and
join to the PREFS_PROPERTY_VALUE on NODE_ID
They are linked to the PORTLET_ENTITY table, so you can grab all of
those as well if you plan to use entities
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
