CeBIT 2010: Recipe for Office Migration
In the Open Source Forum at CeBIT, Florian Schiessl of the Munich city council shared his experiences about their migration to OpenOffice.
The city council of the Bavarian capital has more than 15,000 PC workstations in 51 locations across the city that were converted end of 2009 to OpenOffice. The migration was based on a decision the city council made in 2003 to make the desktops independent of particular software vendors by using Linux and open source.
The changeover occurred over a number of years in phases, starting with an analysis (2003-2005), evaluation of the consolidation potentials and definition of the migration methods (2005-2007), and ending with its implementation, training and quality assurance (2007-2009). Among the migration challenges, according to Shiessl, were the more than 21,000 existing Microsoft Office templates and the specialized sofware using the proprietary offices solution just for printing reports alone. Some of the templates could be combined to reduce the overall number.
The city then created its own Wollmux OpenOffice extension for template management that also served for forms creation whereby coworkers didn't need to know any macro languages. The Java software is currently generally available under EUPL European open source licensing

Wollmux relieved Office of 20% of its macros. It also provided the macros further migration paths such as producing images in Web-based database apps or transforming into platform-independent Java macros. If an Office macro were to remain, it would be moved in a library to prevent duplication.
As Schiessl explained, this all could unfortunately not be accomplished in the normal course of operation. The city therefore created an expanded office support center (EOS) with its own personnel and coworkers from the DBI service provider. In addition, an office working group continues to meet monthly and is one of the measure used in improving the acceptance of the migration process.
A key aspect was training users, added Schiessl. "Handing users a mandate isn't enough." Even standard training wouldn't suffice. Instead, customized training packages for text processing, spreadsheets and presentation programs became the successful solutions, further subdivided into modules and fine-tuned for different target groups such as users, template managers and administrators. An additional adjunct was the "Limux Knowledge World" e-learning module.
Workplace migration occurred in three phases. Installing OpenOffice next to the Microsoft product was the first step so that everyone could read and work on ODF documents. ODF then became the standard in phase two and coworkers were trained in its use. Microsoft Office was only deployed in exceptional cases, such as for as yet unmigrated specialized procedures. Phase two is now the current state of all Munich city council workstations. The third phase is uninstalling Microsoft Office, which already occurred with about half the PCs.
Public documentation exchange proceeds as follows: the city of Munich uses PDF for outgoing documents, with ODF used to process them. Problems are usually resolved by communication between the exchanging entities. Larger software version upgrades can also be resolved in the same way, Schiessl emphasized. He also added that both the EU and the German government accept ODF files as an official standard.
At the end of his talk, Schiessl provided the CeBIT audience with a few tips: they should attend early on to addressing the migration of specialized procedures by providing open APIs and formats. He claimed that some of this could have occurred a bit earlier in the Munich implementation. Planning should take flexibility and buffer time into account, to prevent so-called "U-boats," neglected problems such as leftover templates or processes, from surfacing from time to time even in late project phases.
The city council's conclusion: "We would do it again!" Schiessl: "The office product is a key to independence. Once you've solved the office issue, you're independent of any operating system." Further details on the project are at the official Limux project site and the unofficial blog, Planet Limux (note the "m" for "Munich"). At CeBIT, the project is in the Open Source Project Lounge in Hall 2.
Issue 261/2022
Buy this issue as a PDF
News
-
KaOS 2022.06 Now Available With KDE Plasma 5.25
The newest iteration of KaOS Linux not only adds the latest KDE Plasma desktop but sets LibreOffice as the default.
-
Manjaro 21.3.0 Is Now Available
Manjaro “Ruah” has been released and includes the latest Calamares installer, GNOME 42, and much more.
-
SpiralLinux is a New Linux Distribution Focused on Simplicity
A new Linux distribution, from the creator of GeckoLinux, is a Debian-based operating system with a focus on simplicity and ease of use.
-
HP Dev One Linux Laptop is Now Available for Pre-Order
The System76/HP collaboration Dev One laptop, geared toward developers, is now available for pre-order.
-
NixOS 22.5 Is Now Available
The latest release of NixOS with a much-improved package manager and a user-friendly graphical installer.
-
System76 Teams up with HP to Create the Dev One Laptop
HP and System76 have come together to develop a new laptop, powered by Pop!_OS and aimed toward developers.
-
Titan Linux is a New KDE Linux Based on Debian Stable
Titan Linux is a new Debian-based Linux distribution that features the KDE Plasma desktop with a focus on usability and performance.
-
Danielle Foré Has an Update for elementary OS 7
Now that Ubuntu 22.04 has been released, the team behind elementary OS is preparing for the upcoming 7.0 release.
-
Linux New Media Launches Open Source JobHub
New job website focuses on connecting technical and non-technical professionals with organizations in open source.
-
Ubuntu Cinnamon 22.04 Now Available
Ubuntu Cinnamon 22.04 has been released with all the additions from upstream as well as other features and improvements.