We have baan 5.0 and we want integrate it with MS Office (excel and word). The ERP includes the Integration Pack but we don't know how it works. Thanks.

Search the forum for 'Office Integration', there is a lot of info for it in these forums.

Be aware that there are 2 forms of using that technology. You can interface to Excel and Word direct, but these are a little slow, somewhat buggy and I am not sure how much these are supported at this point. This was the earliest use of this technology - it's free.

New uses for this technology involve using OpenWorld to get the data. That's not free right now, but seemingly works much better - I have not used it.

Also, read this Baan solution: 127466
It has links to get the latest version of this software (at Service Pack 11 level), which also includes installation and user instructions (or so says the description).

Good luck.

Thanks a lot.

Originally posted by lbencic
New uses for this technology involve using OpenWorld to get the data. That's not free right now, but seemingly works much better - I have not used it.


Hi Lisa, you are not right with this statement. The Office Integration based on OpenWorld is also free. ;)

Andreas

O well, your right, I am corrected - the Office Integration is free, but OpenWorld is not, correct? That is in flux..hopefully SSA will release a free version or something similar soon - or do you know is that already happened..?

Hi Lisa,

the OpenWorld components you need for Office Integration are also for free. These are Adapter and Adapter for iBaan ERP.
Additionally you have to set up Bclm. During installation you have to order an activation key for these OW components via support but this is also free.
Hope this helps.

Andreas

So, it seems that some parts of OW are free to integrate with existing technology. Thanks Andreas, that is news to me. I would love to see a posting on what parts of OW are available with a support contract, and which parts are extra.

Sounds like a good Wiki topic :) I'll start one over there by the end of the day - if you know more about this subject, feel free to add to the Wiki.

Hi all.

Our technical support confirm that we need 3 components (all free): integration pack (server), Integration pack (client) and the open world adapter.

Hi Lisa,

This subject is very intersting.

How to get those components, should I request to Baan Support?

Thanks & Regards,
Harley

Hi Harley
I don't know, we have not done this - it's all (good) news to me. But from the past with things like webtop, we have contacted support and we get the product, the OW pieces needed, and some papers to sign off on saying we would only use for WebTop. From the post above, it would work probably the same way.

Also assuming they will give you full documentation as well. Bazram can confirm that maybe.

Thanks Lisa

Hi Harley,
as i mentioned in one of my previous posts the OW Components to use Office Integration are free.
We get our things directly from Baan (uups SSA Global). In our case we use OW 2.3. The package is called 'iBaan OpenWorld Adapter Suite 2.x Runtime'. In case of 2.3 it is Part Number 6506.0001.
The Office Integration 2.0 is available via Solution 126530 or herein mentioned Solutions for newer Versions on Baan Support Site.

By the way, installation and configuration of OW is not an easy task depending on your software environment. :confused:
To me it seems like we say in Germany: 'you want to shoot a bird with a cannon'.;)

Hope this helps,
Andreas

Hi, all

Our technical support tell us:
"Problems with Office integration occurs with Windows XP, 2000 or professional and MS Office 2000 or XP.
With Windows 98, 97, etc. Problems dissapear."

Probably he's right

we'll see it


Regards,

Bazram60