I’m currently trying to create a view that draws from three different Notes databases, using a field that is found on the documents in the first database to locate the documents in the second database, and another field found on these documents to locate docs in the third database. Of course, I can’t use @DbColumn or @DbLookup in view column formulas, so I’m exploring other methods to get this info.
One option that was suggested to me was to use LEI’s virtual views feature to create a view using connection documents to the three Notes database. However, it looks like my version of LEI does not allow for connections to other Notes databases, just to other database platforms. I have Domino 6.5 installed, but I’m not sure what version of LEI we have installed here. I can say that the user interface shown in the “Implementing LEI 6.5” Redbook looks different than the user interface we have here, and that interface indeed shows a screen shot that offers “Notes” as a connection document option. However, “Notes” is not an option on my version of LEI.
So here’s my questions:
(1) How can I find out what version of LEI I have installed on my system?
(2) Does LEI 6.5 support connections to other Notes databases, as well as databases on other platforms?
(3) Can I set up a virtual view in LEI that displays data from multiple Notes databases?
(4) If I can’t do what I want to do with LEI, is there another way to go about getting info on documents from other Notes databases in a view?
I need to have a solution in place by tomorrow, so any help you can provide me is much appreciated!
If you have Domino 6.5 then you must have LEI 6.5 to match it, it will not physically install if it is another version. If you are really desparate to know what version then you can look at the console log it will tell you or you can use the file system and open up the LEI administrator (not exact, I do not have it in front of me) and check there. None of this is going to help you however.
LEI 6.5 is not for connecting to other Notes databases, after all that is what Notes is supposed to do.
You cannot get a Virtual View in LEI.
There is always another way to do everything. My first piece of advice is that this is a Relational problem. Notes is not very good at supporting Relational issues.
Therefore you have a several options that make the Relational problem into either a flat problem–and handle it in Notes, or take the data out of Notes into a RDBMS world, do the combine and then bring it back.
In Notes consider this: You have three databases and three forms with some fields on them.
You could create a database with one Form with all the fields from all the other three databases on it. Replicate the data from the three databases into the one database and there you have it in one flat form.
If the Replication idea does not work you can use a Lotus Notes product to combine data from different databases like Replic-Action.
Replic-Action will definately do what you want it to do. We use it ourselves for a similar problem.