OpenOffice for Windows

Maintainer

Michael Weinberger

Introduction

This contrib provides a RPM that integrates the OpenOfficePortable application (Windows Version) into the SME Server. The OpenOffice executables are installed in a Samba share so that users can run all modules like Writer, Calc, Impress etc. immediately after domain logon without any installation or configuration on their Windows XP/2000 computers. The individual OpenOffice user profiles are stored on the SME Server in a hidden Samba share.

	Warning:
	This contrib has been successfully tested on Windows XP and 2000 computers, but there is no guarantee that it will work on every Windows XP/2000 installation. It may depend on the servicepacks or other software you have installed. Please also note, that (optional) scripts add commands to the netlogon.bat that modify the Windows Registry. Take the usual precautions!

Installation

RPM Installation

/usr/bin/yum install --enablerepo=smecontribs smeserver-openoffice-portable

config gettype openoffice || config set openoffice service
config setprop openoffice status enabled
expand-template /etc/samba/smb.conf

Now wait until the 'openoffice' share appears in the Windows Network Neighborhood. This may take serveral minutes.

OpenOfficePortable Windows Binary Installation

On a Windows computer log into the domain as domain user 'admin' with the SME admin password. Download and save the OpenOfficePortable setup program from Soureforge download page. There are serveral localized versions available. In the installation chapter below the English version OpenOffice_Portable_2.3.1_Rev_2_en-us.paf.exe is used. (Use the latest version 2.4.0. The installation process is identical)

Run the OpenOfficePortable setup program.

	Note:
	Enter exactly the destination folder as shown in the screenshot, where MYPDC is to be replaced by the SMB servername of your SME Server.

Now walk through the setup dialog...

Accept the license.

If you leave these fields empty, these fields will be empty in the individual user profiles.

Enter any text, if you want the corresponding fields of the individual user profile pre-filled with the user's name (from the SME configuration database).

Uncheck automatic updates.

Do not register.

When you have finished the setup, OpenOffice starts. Open the 'Options' dialog.

Now walk through the options and adjust them to your needs. Note that you are about creating the initial default user profile for all existing and future new users. Once you have initialized the user profile, you cannot change it after that without starting from the scratch.

When finished click OK and log off from the domain.

Now you have created the default user profile.

Setup and Configuration on the SME Server

Initializing the User Profiles

Run the script

openoffice-init

This creates the user profile directories for all existings users and copies the default profile into them. The OpenOffice bootstrap.ini file is patched to use the new profiles path and the OpenOfficePortable.ini file is created. The user profiles are stored in /home/e-smith/files/ooSettings. When new SME users are created, the OpenOffice profile will be created automatically by an action script in the create-user event.

Users now can start OpenOffice by running \\MYPDC\openoffice\OpenOfficePortable\OpenOfficePortable.exe

Register OpenOffice File Extensions (optional)

On the SME Server run as root the script

openoffice-assoc-oo

This registers the file extensions .odb, .odg, .odm, .odp, .ods, .odt and .rtf and associates them to the OpenOfficePortable application. It is done by adding Windows Registry commands to the netlogon.bat file, which are executed at domain user logon.

Register Microsoft Office File Extensions (optional)

On the SME Server run as root the script

openoffice-assoc-ms

This registers the file extensions .doc, .xls and .ppt and associates them to the OpenOfficePortable application. It is done by adding Windows Registry commands to the netlogon.bat file, which are executed at domain user logon.

Assign Windows Drive Letter (optional)

On the SME Server run as root the script

openoffice-drive-letter <LETTER>:

This assigns a drive letter to the openoffice share. It is done by adding a 'net use' command to the netlogon.bat file.

Users now can start OpenOffice by running <LETTER>:\OpenOfficePortable

Update from 2.3.1 to 2.4.0

Log into the SME server as user root.

Install the smeserver-openoffice-portable-2.4.0-1.el4.sme.noarch.rpm RPM:

/usr/bin/yum update --enablerepo=smecontribs smeserver-openoffice-portable

Run the init script (to fix ownership and permissions)

openoffice-init

Log into a Windows workstation as domain user 'admin' with the SME admin password. Download and save the OpenOfficePortable 2.4 setup program from Soureforge download page. Run the OpenOfficePortable setup program. Choose the same path you have used at the first installation (see first screenshot of chapter OpenOfficePortable Windows Binary Installation)

On the SME server again run

openoffice-init

Distribute the OpenOffice Installation to other SME Servers

Log into the new server as user root and install and configure the RPM as described in the 'RPM Installation' section above.

Then log into the server with the OpenOffice installation and run

rsync -av  --delete /opt/openoffice/OpenOfficePortable NEW_SERVER_IP:/opt/openoffice/

Note: It is important to use the rsync command as it preserves timestamps, permissions and ownerships. The scp command would not work.

After the tranfer run on the new server

openoffice-init

Uninstall

Cleaning up netlogon.bat

openoffice-assoc-oo remove
openoffice-assoc-ms remove
openoffice-drive-letter remove
rm -f /home/e-smith/files/samba/netlogon/file-assoc-ms.*

Removing the RPM

/usr/bin/yum erase smeserver-openoffice-portable
signal-event workgroup-update

Removing the OpenOffice installation

rm -rf /opt/openoffice

Removing the user profiles

rm -rf /home/e-smith/files/ooSettings

Changelog

* Mon Apr 21 2008 Michael Weinberger <mweinber@neddix.de> 2.4.0-2
  Touch license files to avoid license dialog
* Mon Apr 21 2008 Michael Weinberger <mweinber@neddix.de> 2.4.0-1
  Update to 2.4
  Fix ownership of /opt/openoffice in script openoffice-init
* Sun Mar 16 2008 Michael Weinberger <mweinber@neddix.de> 2.3.1-11
  openoffice-delete-history as seperate script
* Sat Mar 15 2008 Michael Weinberger <mweinber@neddix.de> 2.3.1-10
  openoffice-delete-history added
* Fri Mar 14 2008 Michael Weinberger <mweinber@neddix.de> 2.3.1-9
  rename OpenOfficePortable.ini to OpenOfficePortable.ini.contrib
* Thu Mar 13 2008 Michael Weinberger <mweinber@neddix.de> 2.3.1-8
  OO Pathes fixed
  OpenOfficePortable.ini added
  openoffice configuration db record for enable/disable program share
* Thu Feb 28 2008 Michael Weinberger <mweinber@neddix.de> 2.3.1-7
  Spec file fix
* Thu Feb 14 2008 Michael Weinberger <mweinber@neddix.de>
  Initial release 

References

• http://www.openoffice.org/
• http://portableapps.com/apps/office/openoffice_portable
• http://portableapps.com/de/apps/office/openoffice_portable
• http://sourceforge.net/project/showfiles.php?group_id=151265&package_id=255647
• http://www.ooodev.org/projekte/oooportable/oooportable.html

---