Lodahl's blog: System integration
Showing posts with label System integration. Show all posts
Showing posts with label System integration. Show all posts

25 August 2009

Wanted: Did you integrate OpenOffice in your business application?

One of the most common oppositions we hear from IT professionals and business managers against shifting away from Microsoft Office is this:

We cannot change away from MS because we are using MS Office in conjunction with this and that application
  • How difficult is it to integrate OpenOffice or ODF in an existing business application?
  • Do any of you have actual experience doing it?
  • How can we exchange knowledge and experiences on this matter?
Please give me comments

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):

06 December 2007

Lotus Notes to OpenOffice,.org integration

I was trying to help my Norwegian colleges find out why our Lotus Notes to OpenOffice.org integration didn't work properly. I have used several hours figuring out what the problem was.

Of cause field mapping must be accurate and in this case it's also case sensitive. And of cause: all required data must be available in the Notes-document.

Hokus pokus. It works.


Here is a movie that shows how it works

18 November 2007

It's not enough that the IT solutions works

-Solutions needs to add value !

Traditionally we think of laptops, servers, network, Windows operating system and pc programs when the talk comes to IT in business matters. But if you want to get the best of your IT investments, it's important that you don't make your discissions based on the amount of features and functions. Much more important things must be taken into consideration.

It's no big deal to buy a new server or to install an update to the database system. The challenge comes when we want to exchange the new technology into actual valuable working processes in the organization. One of the conditions for creating value is that the staff, customers, subcontractors and so on can and will learn how to use what comes from the investments. This can only happen if the investments has been

  1. based on business needs
    not from what others do or what you think would be a nice geek. The organizational needs must be covered up front, so that the solution can help improve the collaborative processes in the right direction.
  2. introduced during a successful implementation
    not only from a technical perspective, but also from an organizational perspective. Users must be involved, so the solution is set up to match the individual needs.
  3. adopted in a way that suits the business needs
    This is unfortunately not always the case in real life. Education and full introduction is necessary to get a successful implementation.

Today, words like Web2.0, mobile access and on demand as well as the technology behind it, is setting the agenda. Everything must be accessible from the web and from mobile devices. For instance, users can read mail and see customer information from CRM systems. Mobile access has limited functionality, but covers most of the needs.

We are going away from the traditional computer installed program. The trend is going towards focusing less on individual features and we accept that the applications work a little bit different from what we are used to.

This is a healthy development, because it's more important that a function is adding value to the people using it, for instance by enhancing collaboration, than adding a bunch of new buttons. Many has already discovered this by changing from Microsoft Office to the free and open OpenOffice.org. With a simular investment you can both install the software (free) and develop templates and macros as well as train the users in how it works. This is because the expenses moved from licenses to organizational implementation.

By doing this, you spend money on adding value, not only on making it work

21 August 2007

IBM Lotus Notes 8

...or ND8 as we prefer to call it, was released last Friday. I've been trying it out for some time now, and I must say that it looks great. I am looking forward to go deeper into the designer client as soon as I get some time.

I have already looked at two parts:

  1. composite applications
  2. productivity tools
The ability to create composite applications will be a very strong feature some day. The problem is, that Lotus Notes is no longer a so called rapid development environment. To create composite applications, you actually must be a hardcore programmer.

And I am very happy that Lotus Notes now comes with productivity tools and support for ODF (open document format).

Some day I hope to be able to ask IBM a few questions:
  1. When can we expect Lotus Notes rich text to be native stored as ODF ?
  2. Is it possible to import ODF documents into a Notes rich text field ?
  3. Why wont IBM Lotus say, that productivity tools is actually a clone/fork of OpenOffice.org ?
    Please see my blogpost here
  4. When can expect IBM staff to use their own applications at work, e.g. product presentations and text documents ?
    I'm tired of seeing IBM staff do presentations with an application like You-know-who Powerpoint. When are you ready to take your own medicine ?
Any way: congratulations. I believe that Notes 8 will be a success.

16 August 2007

System integration made easy

This video shows that system integration is not that hard...