Re: new/CWS dba32g : configuration option to control the availability of "Create new database" option in the "Create Database" wizard

Drew Jensen <[email protected]> Mon, 11 Jan 2010 07:03:11 -0500
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Olivier Hallot wrote:
> Hello
>
> As indicated in the wiki:
> <quote>
> Configuration option to control the availability of "Create new 
> database" option in the "Create Database" wizard
>
> A configuration option 
> "/org.openoffice.Office.DataAccess/Policies/Features/Base/CreateLocalDatabase" 
> has been introduced, which is of type boolean, defaulted to "true", 
> and controls whether the "Create Database" wizard (started via 
> File/New/Database) exposes the "Create a new database" option. It can 
> be set in file: 
> .../basis3.2/share/registry/schema/org/openoffice/Office/DataAccess.xcs
> </quote>
>
> I gave a try on this new feature (since I was one who asked for it), 
> but I can only put it to work on a brand new OOo user.
>
> If I try this on an already existing user, it does not work.
>
> Have I missed something? Is there a way to tweak an existing user? 
> That is related to the issue of upgrading from previous OOo versions.
>
> Thank you
>
Hello Olivier,


it's a cache thing. ( Frank actually pointed that out to me. )

So - if you edited the xcs file directly *then* you must force an update 
to the cached settings to get it.

One easy way is just to open the extensions manager and change anything, 
disable and re enable an extension will do it and as far as I can tell 
to any extension. As soon as you do this the setting is picked up.

Of course this isn't how one is supposed to to this - one should use a 
script to change the property.

Here is an example basic methong Frank supplied in other email - note 
that was off the top of his head and I never tried it...just did the 
ExtMgr trick instead.

  Dim oProvider as Object
  oProvider = createUnoService( _
    "com.sun.star.configuration.ConfigurationProvider" )

  Dim args(0) as new com.sun.star.beans.PropertyValue
  args(0).Name = "nodepath"
  args(0).Value = _
    "/org.openoffice.office.Office.DataAccess/Policies/Features/Base"

  Dim oNode as Object
  oNode = oProvider.createInstanceWithArguments( _
    "com.sun.star.configuration.ConfigurationUpdateAccess", _
    args() )

  oNode.CreateLocalDatabase = FALSE
  oNode.commitChanges