topic Help with OpenOffice transformations in Alfresco Archive

Help with OpenOffice transformations

ftoth — Tue, 24 Oct 2006 20:45:41 GMT

Hi,I'm exploring the OpenOffice stuff, and I'm stuck. I have OO 2.0.4 installed and running in the background according to the Alfresco doc.When I start Alfresco (1.4.0RC1), I get a message:6:34:22,005 ERROR [openoffice.connection.SocketOpenOfficeConnection] disconnected unexpectedlyI also get this

Re: Help with OpenOffice transformations

ftoth — Tue, 24 Oct 2006 20:53:00 GMT

I just read this post about connections being reconnected automatically:

http://forums.alfresco.com/viewtopic.php?p=10407&sid=4b51002d3251f58fbea8155dd3b6358b

So then my later questions are more important:

What's an example of a transformation that would use OpenOffice?
How can I set one up to verify that supported transformations are
working?

Thanks,

Fred

Re: Help with OpenOffice transformations

paulhh — Thu, 26 Oct 2006 12:23:10 GMT

Hi

Try transforming from Powerpoint to Flash.

Cheers
Paul

Re: Help with OpenOffice transformations

ftoth — Thu, 26 Oct 2006 18:27:15 GMT

Yes! I had actually gotten Excel to text working as well and that's very nice. However, my original issue is still there. Namely:

OpenOffice calc supports saving as XML. It does a very clean job of saving Excel files to XML. How can I access that particular transformation within Alfresco. When I choose XML as the "required format", all it does is copy the xls file with no changes. Is this something that can be simply added to the configuration? Or is coding necessary?

Thanks,

Fred

Re: Help with OpenOffice transformations

derek — Mon, 30 Oct 2006 13:47:32 GMT

Hi,

The bean responsible for this is the transformer.OpenOffice found in content-services-context.xml. It has a property documentFormatsConfiguration that can be overridden or changed. Currently, XML is not a valid target for the transformations, as configured.

If you want, you can investigate the neat JOOT library, which does the work, and various configuration options. The family and document-format notation is not that intuitive, but some reading up should solve that.

Regards