Difference between revisions of "OpenOffice.org 3.x"

From WPKG | Open Source Software Deployment and Distribution
Jump to: navigation, search
(Updated to OpenOffice.org 3.1.0)
m (I added a simple installer for a common OpenOffice installation without Quickstart and Auto-Update)
Line 38: Line 38:
 
Seems to reboot the system despite the reboot="false" option when Quickstart is already loaded (ie: execute wpkg-start.bat explicitly or manual restart the WPKGSrv).
 
Seems to reboot the system despite the reboot="false" option when Quickstart is already loaded (ie: execute wpkg-start.bat explicitly or manual restart the WPKGSrv).
  
 +
== OpenOffice.org 3.1.0: Easy Installation without Quickstart and Online-Update ==
 +
 +
To install OpenOffice.org without the Quickstart-Application (parameter gm_o_Quickstart) and wihtout the automatic Onlineupdate (parameter gm_o_Onlineupdate) use this package file. Just extract the OpenOffice-Installer and call the setup with the following package file.
 +
 +
<source lang="xml">
 +
<package id="openoffice" name="OpenOffice.org 3.1" revision="310" reboot="false" priority="0">
 +
  <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
 +
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
  <install cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' />
 +
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
  <upgrade cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' />
 +
  <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />
 +
</package>
 +
</source>
  
 
== Poor availability of installer without JRE ==
 
== Poor availability of installer without JRE ==

Revision as of 16:09, 27 July 2009

This is a silent installer and uninstaller for OpenOffice.org 3 (from OpenOffice.org/Sun Microsystems).


OpenOffice.org 3.1.0

Download the installer http://download.openoffice.org/, unpack files to a local directory, customize with Microsoft ORCA tool if needed, and upload to your software source repository the following files: 

java/
licenses/
readmes/
redist/
instmsia.exe
instmsiw.exe
ooo31.mst                          # Microsoft Transform File created by you with the ORCA tool, this is not necessary
openofficeorg1.cab
openofficeorg31.msi
setup.exe
setup.ini                          # this file contains the numeric ID you need for uninstallation, {43A650AA-D1DC-4C52-8819-D7848B3A08DA} in case of italian localized version

This example is for the italian localization, and associates OpenOffice as the default program for DOC, XLS and PPT files. Adapt to your localizations and change file associations to your needs. 


<?xml version="1.0" encoding="UTF-8"?>
<packages>
<package id="openoffice31-ita" name="OpenOffice.org 3.1 italian" revision="1" reboot="false" priority="0">

  <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
  <install cmd='msiexec /qn /i "%SOFTWARE%\ooo310-ita\openofficeorg31.msi" TRANSFORMS=%SOFTWARE%\ooo310-ita\ooo31.mst ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1' />
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\ooo310-ita\openofficeorg31.msi" TRANSFORMS=%SOFTWARE%\ooo310-ita\ooo31.mst ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1' />
  <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />

</package>
</packages>


Seems to reboot the system despite the reboot="false" option when Quickstart is already loaded (ie: execute wpkg-start.bat explicitly or manual restart the WPKGSrv).

OpenOffice.org 3.1.0: Easy Installation without Quickstart and Online-Update

To install OpenOffice.org without the Quickstart-Application (parameter gm_o_Quickstart) and wihtout the automatic Onlineupdate (parameter gm_o_Onlineupdate) use this package file. Just extract the OpenOffice-Installer and call the setup with the following package file. 

<package id="openoffice" name="OpenOffice.org 3.1" revision="310" reboot="false" priority="0">
  <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
  <install cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' /> 
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
  <upgrade cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' /> 
  <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />
</package>

Poor availability of installer without JRE

Beware that for many non-US localizations, italian included, OpenOffice.org installer is not available in the "without Java JRE" version. As a side effect, a "with Java JRE" is so bad behaved that it does create a directory %PROGRAMFILES%\JRE\ and copy the JRE installer "jre-windows-i586.exe" in it, even if you specified in the Microsoft Transform that JRE is not to be installed. Uninstallation then cleanly removes this directory, however this is a waste of resources and a waste of time.

Issue number 95374 has been filed in OpenOffice.org requesting "non JRE" installers for all localizations; it has been answered pointing out that resources for translation are short, so that not all versions are translated and submitted to the Quality Assurance process. Solution is to volunteer and help localization and QA teams.


Avoid registration window

<install cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\setup.xcu' />
<install cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\setup.xcu' />
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />

You can get setup.xcu and common.xcu from this location: http://wiki.services.openoffice.org/wiki/Documentation/Administration_Guide/Deactivating_Registration_Wizard


File types associations

Since Ooo does not configure file types other than ODF to be opened by default in Ooo I've created a registry file to set it (it has to be added for each user of the computer, so if you install Ooo as admin and have other users working consider adding batch script to 'All users'->'autostart'. Check WPKG Adding Registry Settings for details.

In order to avoid this in future releases, issue number 95375 has been filed in OpenOffice.org requesting the restore of "SELECT_WORD=1/0" and "SELECT_EXCEL=1/0" installer command line switches, which do not seem to be effective in the 3.0.0 release. As a workaround, Sun answered that the command line switch "REGISTER_ALL_MSO_TYPES=1/0", or equivalently the .msi file property "REGISTER ALL MSO TYPES" should be used to get what requested.


registry.reg: 

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppsx]
"Application"="simpress.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppsx\OpenWithList]
"a"="simpress.exe"
"MRUList"="ba"
"b"="soffice.bin"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppsx\OpenWithProgids]
"PowerPoint.SlideShow.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pptx]
"Progid"="OpenOffice.org.Pptx"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pptx\OpenWithList]
"a"="simpress.exe"
"MRUList"="ba"
"b"="soffice.bin"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pptx\OpenWithProgids]
"PowerPoint.Show.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppt]
"Progid"="OpenOffice.org.Ppt"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppt\OpenWithList]
"a"="soffice.bin"
"MRUList"="ab"
"b"="simpress.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppt\OpenWithProgids]
"PowerPoint.Show.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.rtf]
"Progid"="OpenOffice.org.Rtf"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.rtf\OpenWithList]
"a"="WORDPAD.EXE"
"MRUList"="ba"
"b"="soffice.bin"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.rtf\OpenWithProgids]
"rtffile"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pps]
"Progid"="OpenOffice.org.Pps"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pps\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pps\OpenWithProgids]
"PowerPoint.SlideShow.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docx]
"Progid"="OpenOffice.org.Docx"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docx\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docx\OpenWithProgids]
"Word.Document.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docm]
"Progid"="OpenOffice.org.Docm"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docm\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docm\OpenWithProgids]
"Word.Document.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx]
"Progid"="OpenOffice.org.Xlsx"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx\OpenWithProgids]
"Excel.Sheet.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsm]
"Progid"="OpenOffice.org.Xlsm"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsm\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsm\OpenWithProgids]
"Excel.Sheet.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otg]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otg\OpenWithList]
"a"="soffice.bin"
"MRUList"="ba"
"b"="soffice.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otg\OpenWithProgids]
"opendocument.DrawTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.doc]
"Progid"="OpenOffice.org.Doc"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.doc\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.doc\OpenWithProgids]
"Word.Document.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xls]
"Progid"="OpenOffice.org.Xls"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xls\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xls\OpenWithProgids]
"Excel.Sheet.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odp]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odp\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odp\OpenWithProgids]
"opendocument.ImpressDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otp]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otp\OpenWithList]
"a"="soffice.exe"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otp\OpenWithProgids]
"opendocument.ImpressTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odt]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odt\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odt\OpenWithProgids]
"opendocument.WriterDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott\OpenWithList]
"a"="soffice.exe"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott\OpenWithProgids]
"opendocument.WriterTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odg]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odg\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odg\OpenWithProgids]
"opendocument.DrawDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ods]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ods\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ods\OpenWithProgids]
"opendocument.CalcDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ots]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ots\OpenWithList]
"a"="soffice.exe"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ots\OpenWithProgids]
"opendocument.CalcTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odb]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odb\OpenWithList]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odb\OpenWithProgids]
"opendocument.DatabaseDocument.1"=hex(0):

My batch script looks like this (I'm sure it could be done better, but it works fine) Of course xcopy command needs to have one exported profile, just run Ooo, configure it and copy created files to a network location. 

if not exist "%APPDATA%\OpenOffice.org\3" regedit "/S \\server_name\software\OpenOffice.org3pl"\user_profile\ooo3.reg
if not exist "%APPDATA%\OpenOffice.org\3"  xcopy "\\server_name\Software\OpenOffice.org3pl\user_profile" "%APPDATA%" /Y /E

If someone has already Microsoft Office 2003 or 2007 and want to use Ooo, but doesn't want it to take over his MS files extensions try this: 

if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE12\winword.exe"
(if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE11\winword.exe"
(if exist "%PROGRAMFILES%\OpenOffice.org 3"
(if not exist "%APPDATA%\OpenOffice.org\3" 
regedit /S "\\_server_name\software\Office\OpenOffice.org3pl\user_profile\ooo3.reg")))

if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE12\winword.exe"
(if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE11\winword.exe"
(if exist "%PROGRAMFILES%\OpenOffice.org 3"
(if not exist "%APPDATA%\OpenOffice.org\3" 
xcopy "\\server_name\Software\OpenOffice.org3pl\user_profile" "%APPDATA%" /Y /E)))


OpenOffice Extensions

Similar to Firefox extensions, if you install OpenOffice extensions from within OpenOffice (using Tools → Extension Manager) they're installed per-user; if you install them from the command-line (using unopkg.exe), they're installed per-machine.

Extensions are set to either only be allowed to be installed per-user, not per-machine; or they can be installed per-machine but will prompt upon installation for the licence to be accepted (despite the fact the LGPL doesn't have to be accepted by the end user). This presents some difficulty in automating an installation of OpenOffice extensions. There's a worthwhile forum post related to this: [http://www.oooforum.org/forum/viewtopic.phtml?t=75460 'Shared' vs. 'My' Extensions]. For reference, see OpenOffice.org wiki's Simple License.

oiaohm: "CMD /c echo yes|unopkg add --shared extension.oxt" for install line works with all extenions makes the ones with licence install does not interfere with thoses without out. No batch file required. For people doing deploys on Linux and Mac with other systems it works with bash instead of command as well. Will added some full examples of extension deployment from what I use.

For instructions on automating installation of OpenOffice extensions, per-machine, see OpenOffice.org's wiki on unopkg.

Retrieved from "https://wpkg.org/index.php?title=OpenOffice.org_3.x&oldid=7212"