Enterprise 3.0+OpenOffice.org3=No transformations...

[meansartin14]

Platform/Supporting Apps: Red Hat Enterprise Linux 5.2, MySQL 5.0.45, JDK 1.6.0 Update 7, OpenOffice.org 3, Tomcat 6.0.18 *came with Alfresco Enterprise 3.0 installer*

Alfresco Version: Alfresco Enterprise 3.0 (from AlfrescoEnterprise-3.0.0-Linux-x86-Install.bin) *TRIAL*

Background:
I am developing a prototype/proof-of-concept for my customers. I was previously using a trial of Alfresco Enterprise 2.2.0 for this purpose. It is important to note that with this prototype, I was not using transformations (thus, OpenOffice was never tied to Alfresco properly). However, I have since determined that I need to demonstrate this capability in my prototype due to customer usefulness.

Issue:
I have OpenOffice.org 3 installed and working properly (can bring it up using 'soffice' command). However, when I ran through the AlfrescoEnterprise-3.0.0-Linux-x86-Install.bin installer, no matter where I pointed Alfresco to for the OpenOffice program, it could not 'find' it. As such, I am unable to use the transformation feature, which I need to demonstrate.

After completing the installation, I modified several files to attempt to force Alfresco Enterprise 3.0 to know where OpenOffice.org 3 is. I modified these files by placing the appropriate path (/opt/openoffice.org3) as necessary. Here is a list of the files I've modified:

/opt/alfresco/tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml
/opt/alfresco/tomcat/shared/classes/alfresco/extension/remote-openoffice-context.xml.sample
/opt/alfresco/install_extension/openoffice-startup-context.xml.install

The installation directory for OpenOffice.org3 is as follows:

/opt/openoffice.org3/program/soffice‍

For reference, here are some commands that may provide more information:

[root@someserver ~]# whereis soffice
soffice: /usr/bin/soffice
[root@someserver ~]# which soffice
/usr/bin/soffice‍‍‍‍

I would greatly appreciate any help!

[loftux]

What does your openoffice-startup-context.xml look like?
Does it work if you manually run this startup command? Run the complete statement that is within the CDATA section.
I would try to remove the quotes if present.
This is what my startup command look like

/usr/lib/openoffice/program/soffice -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:///home/petl/.openoffice.org2/user -nologo -headless -nofirststartwizard -nocrashrep -norestore‍

I'm running open office with the existing OpenOffice profile (end:UserInstallation) on my local box. I've seen that if you want to use a separate profile location you may need to copy one existing, it does not always succeed to create it.

[meansartin14]

What does your openoffice-startup-context.xml look like?
Does it work if you manually run this startup command? Run the complete statement that is within the CDATA section.
I would try to remove the quotes if present.

Here's what that section of my openoffice-startup-context.xml file looked like:

<value><![CDATA["/opt/openoffice.org3/program/soffice" "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:////opt/openoffice.org3" -nologo -headless -nofirststartwizard -nocrashrep -norestore]]></value>[/code]

I removed the quotes, restarted Alfresco and viola… Transformations now appear to work properly!

This should definitely be written into the bug database, if it's not there already.‍‍‍‍‍