<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>On 17 May 2009, at 23:23, Michael Krnac wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Work for you Aaron and Adrian :)<br><br>It would be cool to provide Packages that can be easily imported to Open Office.<br>This work have some steps.<br><br><ul><li>Find out how to import Cliparts into OO</li><li>Find out how the file structur have to be.</li><li>Write a script to package the Cliparts on this way</li><li>Try to import metadata from the OCAL to this OO-Package</li></ul>It would be cool if you guys can start with this.<br></blockquote><div><br></div><div>(Correct me if you know I'm wrong on any of this - I don't use Open Office so have been starting completely from scratch and had to believe what I read on the internet...)</div><div><br></div><div>I've done some looking into this and Open Office really has lousy support for clip art galleries. It also has pretty lousy support for SVG (via an optional component) but the PNG versions would be a good starting point at least.</div><div><br></div><div>Essentially, Open Office doesn't really support any metadata on clipart beyond just grouping them into separate galleries (think folders). So we'd need to build a gallery of animals, one for people, one for buildings etc. That's doable though, but not going to leverage most of the metadata that open clipart is collecting.</div><div><br></div><div>There are however a few key problems with distributing galleries in open office:</div><div><br></div><div>1. You need to create a .sdg, .sdv and .thm file to go with it. These are proprietary binary files and there's very little tooling or documentation on them. The easiest way to build them is to use Open Office itself to create a gallery and then copy the resulting files out.</div><div><br></div><div>2. Those files are named sgXXX.sdg where XXX is a number that needs to be unique. Managing installs where the filename might not be unique and also managing upgrades needs to be added to the scope.</div><div><br></div><div>Once you get over those issues, the package format is a pretty simple zip file but with a .oxt extension and it contains a few XML files to give details.</div><div><br></div><div>Interestingly there are prebuilt packages for Mandriva and Ubuntu (openclipart-openoffice.org). Anyone know where these came from as they seem to be the best starting point?</div><div><br></div><div>Cheers,</div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><div>Adrian Sutton</div><div><a href="http://www.symphonious.net">http://www.symphonious.net</a></div><div><br class="khtml-block-placeholder"></div></div></span></div><br></body></html>