Re: saving relationship diagram across sessions

Seb <[email protected]> Mon, 11 Jan 2010 10:07:11 -0600
Newsgroups gmane.comp.openoffice.dba.user
Organization Church of Emacs
Message-ID <[email protected]>
On Mon, 11 Jan 2010 16:41:08 +0100,
"Frank Schoenheit, Sun Microsystems Germany" <[email protected]> wrote:

[...]

> Okay, let's start with the simple part (it might take me a while to
> find the time to write that macro): unzip the .odb file with a tool of
> your choice (you might want to copy it to *.zip beforehand), and look
> into the file called settings.xml. Is there a XML node
> "layout-settings", which looks as if it could resemble the
> position/size of the windows in your relation designer?

Thanks for your help with this.  I can certainly see a "layout-settings"
node, but I get stuck interpreting it since I don't know the XML
language.  However, I expected to see a closing tag for the node
(something like "/layout-settings"), which isn't there.  Experimenting a
little by rearranging entities in the relation designer, saving, and
comparing against the settings.xml before this shows that the items
after the "layout-settings" node have not changed.  Here's the
settings.xml file in case you might spot something unusual.


-- 
Seb

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
settings.xml (application/xml, 8.8 KB)
<?xml version="1.0" encoding="UTF-8"?>
<office:document-settings xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="http://www.w3.org/2000/svg" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:db="urn:oasis:names:tc:opendocument:xmlns:database:1.0" office:version="1.2"><office:settings><config:config-item-set config:name="ooo:configuration-settings"><config:config-item-set config:name="layout-settings"><config:config-item-set config:name="Tables"><config:config-item-set config:name="Table1"><config:config-item config:name="ComposedName" config:type="string">public.deployments_beg</config:config-item><config:config-item config:name="TableName" config:type="string">public.deployments_beg</config:config-item><config:config-item config:name="WindowName" config:type="string">public.deployments_beg</config:config-item><config:config-item config:name="WindowTop" config:type="long">17</config:config-item><config:config-item config:name="WindowLeft" config:type="long">1241</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table2"><config:config-item config:name="ComposedName" config:type="string">public.waypoints</config:config-item><config:config-item config:name="TableName" config:type="string">public.waypoints</config:config-item><config:config-item config:name="WindowName" config:type="string">public.waypoints</config:config-item><config:config-item config:name="WindowTop" config:type="long">17</config:config-item><config:config-item config:name="WindowLeft" config:type="long">1105</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table3"><config:config-item config:name="ComposedName" config:type="string">public.communities</config:config-item><config:config-item config:name="TableName" config:type="string">public.communities</config:config-item><config:config-item config:name="WindowName" config:type="string">public.communities</config:config-item><config:config-item config:name="WindowTop" config:type="long">17</config:config-item><config:config-item config:name="WindowLeft" config:type="long">969</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table4"><config:config-item config:name="ComposedName" config:type="string">public.people</config:config-item><config:config-item config:name="TableName" config:type="string">public.people</config:config-item><config:config-item config:name="WindowName" config:type="string">public.people</config:config-item><config:config-item config:name="WindowTop" config:type="long">17</config:config-item><config:config-item config:name="WindowLeft" config:type="long">833</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table5"><config:config-item config:name="ComposedName" config:type="string">public.projects</config:config-item><config:config-item config:name="TableName" config:type="string">public.projects</config:config-item><config:config-item config:name="WindowName" config:type="string">public.projects</config:config-item><config:config-item config:name="WindowTop" config:type="long">17</config:config-item><config:config-item config:name="WindowLeft" config:type="long">697</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table6"><config:config-item config:name="ComposedName" config:type="string">public.ptts</config:config-item><config:config-item config:name="TableName" config:type="string">public.ptts</config:config-item><config:config-item config:name="WindowName" config:type="string">public.ptts</config:config-item><config:config-item config:name="WindowTop" config:type="long">17</config:config-item><config:config-item config:name="WindowLeft" config:type="long">561</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table7"><config:config-item config:name="ComposedName" config:type="string">public.seals</config:config-item><config:config-item config:name="TableName" config:type="string">public.seals</config:config-item><config:config-item config:name="WindowName" config:type="string">public.seals</config:config-item><config:config-item config:name="WindowTop" config:type="long">161</config:config-item><config:config-item config:name="WindowLeft" config:type="long">172</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table8"><config:config-item config:name="ComposedName" config:type="string">public.deployments_end</config:config-item><config:config-item config:name="TableName" config:type="string">public.deployments_end</config:config-item><config:config-item config:name="WindowName" config:type="string">public.deployments_end</config:config-item><config:config-item config:name="WindowTop" config:type="long">23</config:config-item><config:config-item config:name="WindowLeft" config:type="long">231</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table9"><config:config-item config:name="ComposedName" config:type="string">public.geolog</config:config-item><config:config-item config:name="TableName" config:type="string">public.geolog</config:config-item><config:config-item config:name="WindowName" config:type="string">public.geolog</config:config-item><config:config-item config:name="WindowTop" config:type="long">643</config:config-item><config:config-item config:name="WindowLeft" config:type="long">1497</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set><config:config-item-set config:name="Table10"><config:config-item config:name="ComposedName" config:type="string">public.species</config:config-item><config:config-item config:name="TableName" config:type="string">public.species</config:config-item><config:config-item config:name="WindowName" config:type="string">public.species</config:config-item><config:config-item config:name="WindowTop" config:type="long">23</config:config-item><config:config-item config:name="WindowLeft" config:type="long">22</config:config-item><config:config-item config:name="WindowWidth" config:type="long">120</config:config-item><config:config-item config:name="WindowHeight" config:type="long">120</config:config-item><config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item></config:config-item-set></config:config-item-set></config:config-item-set></config:config-item-set></office:settings></office:document-settings>