topic Enterprise 3.0+OpenOffice.org3=No transformations... in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185509#M138639 <HTML><HEAD></HEAD><BODY><STRONG>Platform/Supporting Apps:</STRONG><SPAN> 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*</SPAN><BR /><BR /><STRONG>Alfresco Version:</STRONG><SPAN> Alfresco Enterprise 3.0 (from AlfrescoEnterprise-3.0.0-Linux-x86-Install.bin) *TRIAL*</SPAN><BR /><BR /><STRONG>Background:</STRONG><BR /><SPAN>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.</SPAN><BR /><BR /><STRONG>Issue:</STRONG><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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:</SPAN><BR /><UL>/opt/alfresco/tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml<BR />/opt/alfresco/tomcat/shared/classes/alfresco/extension/remote-openoffice-context.xml.sample<BR />/opt/alfresco/install_extension/openoffice-startup-context.xml.install</UL><SPAN>The installation directory for OpenOffice.org3 is as follows:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>/opt/openoffice.org3/program/soffice<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>For reference, here are some commands that may provide more information:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>[root@someserver ~]# whereis soffice<BR />soffice: /usr/bin/soffice<BR />[root@someserver ~]# which soffice<BR />/usr/bin/soffice<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I would greatly appreciate any help!</SPAN></BODY></HTML> Thu, 30 Oct 2008 16:21:57 GMT meansartin14 2008-10-30T16:21:57Z Enterprise 3.0+OpenOffice.org3=No transformations... https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185509#M138639 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 p Thu, 30 Oct 2008 16:21:57 GMT https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185509#M138639 meansartin14 2008-10-30T16:21:57Z Re: Enterprise 3.0+OpenOffice.org3=No transformations... https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185510#M138640 <HTML><HEAD></HEAD><BODY><SPAN>What does your openoffice-startup-context.xml look like?</SPAN><BR /><SPAN>Does it work if you manually run this startup command? Run the complete statement that is within the CDATA section.</SPAN><BR /><SPAN>I would try to remove the quotes if present.</SPAN><BR /><SPAN>This is what my startup command look like</SPAN><BR /><PRE class="language-none line-numbers"><CODE>/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<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>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.</SPAN></BODY></HTML> Thu, 30 Oct 2008 18:07:17 GMT https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185510#M138640 loftux 2008-10-30T18:07:17Z Re: Enterprise 3.0+OpenOffice.org3=No transformations... https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185511#M138641 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">What does your openoffice-startup-context.xml look like?<BR />Does it work if you manually run this startup command? Run the complete statement that is within the CDATA section.<BR />I would try to remove the quotes if present.</BLOCKQUOTE><BR /><SPAN>Here's what that section of my openoffice-startup-context.xml file looked like:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>&lt;value&gt;&lt;![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]]&gt;&lt;/value&gt;[/code]<BR /><BR />I removed the quotes, restarted Alfresco and viola… Transformations now appear to work properly!<BR /><BR />This should definitely be written into the bug database, if it's not there already.<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 30 Oct 2008 18:43:40 GMT https://connect.hyland.com/t5/alfresco-archive/enterprise-3-0-openoffice-org3-no-transformations/m-p/185511#M138641 meansartin14 2008-10-30T18:43:40Z