Help with OpenOffice transformations

[ftoth]

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 unexpectedly

I also get this message when I attempt to run a rule based transformation (Excel to XML).

Any idea what might be wrong? I can run OO normally (with GUI) with no problems. And, OO Calc supports a "save as" feature that does exactly what I'm trying to do.

Also, how can I tell what sorts of transformations are backed by OO? And are these logged somewhere?

Many thanks,

Fred

[ftoth]

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

[paulhh]

Hi

Try transforming from Powerpoint to Flash.

Cheers
Paul

[ftoth]

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

[derek]

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