Lodahl's blog: Symfoni Software
Showing posts with label Symfoni Software. Show all posts
Showing posts with label Symfoni Software. Show all posts

04 June 2008

OpenOffice.org in enterpise

Symfoni Software held at the beginning of June its annual BRUKERFORUM. This year the event was held in Tallinn in Estonia, where around 65 of Symfoni Software's customers from Norway, Denmark and Sweden was together.

I am working as project manager at Symfoni Software Copenhagen office , but I am also leader of the OpenOffice.org community in Denmark. I spoke at the conference about how and why OpenOffice.org can be a good business for any IT department.

I discussed the possibility of implementing OpenOffice.org as an alternative to MS Office. I pointed out that before the implementation, you must take into account four factors:

1) users should be informed and trained. First, to achieve skills in order to continue to work effectively in the organization. But also to gain acceptance and understanding for the transition to open source. The reason is that one of the biggest challenges, is actually staff resistance and not technical or practical problems.

2) it must be examined tp what extent templates, macros and advanced spreadsheet are used in the organization. Prioritize what actions are required before implementation, and which can wait until later.

3) it must be examined to what extent there are business applications (e.g. ERP systems and enterprise data) with direct integration to MS Office. In many cases, such integration does not exist.

4) it must be considered if conversion of documents should be taken into account. For example. existing documents and future documents exchanged with customers, partners.

During the presentation, I told that if the company or organization has many users and few customizations, could achieve a very rapid benefit, while few users and many adjustments will make it less rapid to achieve benefit. However, it is also appropriate to consider partial transition to OpenOffice.org in the case that few people in the company need MS Office. This possibility has for many been a bad solution so far because we have seen difficulties exchanging different document formats. But after Microsoft has promised full support for ODF format from the beginning of 2008, this solution will become very relevant and viable option for many. In most cases, it will be possible to achieve economic benefits after only a few years.

The companies and organisations using Lotus Notes as a platform for mail, calendar and applications, should consider the use of Lotus Symphony from IBM. Lotus Symphony is actually a converted version of OpenOffice.org. Whether it is better than OpenOffice I will not be able to decide, but Symphony has one unique advantage in the future: It is part of Lotus Notes platform. I look forward to see what IBM will do in the future. By creating composite applications which open for building direct integration of data from Notes to the Office applications.

Mads Andersen from FTZ Autoparts followed my speak, by telling us how FTZ has chosen to switch from MS Office to the free alternative OpenOffice.org. Mads Andersen is working as IT consultant at FTZ Autoparts in Odense, Denmark. FTZ has chosen to use OpenOffice.org as the office application in the company. FTZ is in the situation that of the 550 users is only a few who use the Office application for other than to write a letter once and in a while. Many users and not advanced needs. Some users have initially been allowed to keep their MS Office, but Mads sayd that the plan is to eliminate the last MS Office installations in the future.

Roll out occurred almost without any problems. MSI installation is easy to handle. FTZ is úsing Citrix. Mads believe that FTZ has saved a lot of money by choosing OpenOffice.org rather than Microsoft Office. There is still a recurring problem when FTZ receive attachments from the Microsoft Office 2007, but in the FTZ, they have chosen a key solution, where the IT department takes care of conversion of documents.

Roll out has been going on relatively quietly. "The first two weeks gave a little extra work in support" sayd Mads and continues "but there was no need to do proper education." The support at FTZ has taken advantage of the voluntary support forum OOoForum in cases where users have had problems such as if the IT-supporters didn't resolve a problem themselves. Most problems have been when users couldn't find a specific function or feature in the program. "If there is something we should have done differently, it should be to examine exactly what features people use, and then we should produce information about this".

20 February 2008

Openoffice.org as integrated format in Lotus Notes

Yesterday and the day before I have been writing about how we have implemented OpenOffice.org text documents in our product eOffice.

Today we did the same in Symfoni QMS Quality Manager.

http://www.symfonisoftware.com/symfoniweb/sym010.nsf/pages/produktspek.html?open&prodkey=reportingofaccidents/deviations

So far we have implemented the document format successfully in the editorial process but there is still a few problems when publishing to public. I expect that we will finish this by tomorrow.

19 February 2008

Successfully mailmerge

Yesterday I got our mailmerge template ready. Today I found some additional issues, thus I needed to find out if my colleges could find out how to use it.

I found out that IBM made a serious mistake when they first implemented ODF file format in Lotus Notes. I hope to see 8.01 tomorrow.

The problem is, that if you ever try to open any ODF document with Lotus Notes (productivity tool or Lotus Symphony), the Eclipse framework takes over all (amd I meen all) the ODF file types. It's easy to change this back, by selecting the file, right-click, and select open with etc. So far it's all right. But it took me some time to figure out that Lotus Notes also takes the ODB (Database) file type as hostage. You must remember, that IBM has nothing to do with such file, because there is no ODB database thing in the application.

So, in case the user has ever opened a ODF file with Lotus Notes (approx: 100%), the mailmerge didn't work, because the mail merge wizard creates an ODB file to hold the connection from Lotus Notes to OpenOffice.org.

But Lotus Notes couldn't create such file, because the file type registration was corrupted - byt Lotus Notes.

Well, I learned that lesson today.

The result ?

I made a mailmerge letter based on a search query (32.000 adresses). Search time was about 20 minutes and the merge it self was about the double.

18 February 2008

Busy monday

First day at the office after a week on vacation. And a busy day too.

My company has decided to introduce common layout on our letter stationaries. Huh ?

So my job was to consolidate all the individual letter templates, contract templates etc. to a common company layout. Fantastic decision. The rest of the world did this in the late 80's I think.

OK now, we are using Lotus Notes in several versions and OpenOffice.org. We have decided to use the Swing Integrator from Swing Software (http://swingsoftware.com) and I can only recommend this solution.

Well, I started out making the blank letter template and decided to do some house keeping also, so I cleared all the data fields that was transfered, but not in use. Fascinating how little effort it takes to speed up a computer system. I also decided to improve the layout by removing (hiding) the field labels in case the field doesn't receive any data.

After that i was asked to look into the mail merge template to see if I could figure out what was wrong with it. I found out, that the data exchange wasn't very accurate, because about half the mapped data fields actually missed the target. No wonder why it didn't work. Ok, now it actually works, but I still have an error message on the screen, but I don't have the right (skills) to debug the thing.

I actually made it work, and tomorrow I'll try to run a massive test and see if its possible to mail merge several hundred (or 1,000) letters.

Se how easy it is to set up the field mapping (from Notes field to OpenOffice.org field):