thanks to everyone for the help!, I think I'll store the preferences in the psml for the moment.
br, edgar On 8/1/06, David Sean Taylor <[EMAIL PROTECTED]> wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
