Getting data from Livelink into Word

Application_Services_FUJITSU_(fuji_ware05_-_(delet

Hello,We are developing some WordTemplates that need to get data from Livelink using LAPI (via VBA)Has someone ever done this, and can you send me a simple example how to make the connection and get e.g. the list of all users from LL?It would be a great help if we could start from something existing.Thanks in advanceThe example can be sent to jr@asbuilt.switch.be

Find more posts tagged with

Comments

volvostephen

I really don't like writing 'code' but I love scripting... So - to facilitate everything I need to do in scripting, I use a product from Formard called LLCOM. It is a COM wrapper around LAPI and to get a list of users, you instantiate the object, create a session and then access the Members colection. Couldn't be simpler. Of course, the product has a fee assiciated with it but the more you use it, the better the ROI for you. So - if this is the only time you will ever use LAPI, then this may not be the right way to go but if you forsee using it more, then this is an awesome option. They will be releasing a .NET version of this soon as well.Just to add - I have writtien my own LAPI calls in the past and I much prefer this approach.

Application_Services_FUJITSU_(fuji_ware05_-_(delet

Hello,Do you mean Formark instead of Formard?Anyway, I've been looking around and haven't found some infor yet.Can you send me such an example ? Would be great anyway!Thanks in advance

volvostephen

Yes - I mean Formark.Here is an attached script. It is just vbs and it does a DB connection to a database and returns a recordset of users. The script then checks to see if that user is part of the LLCOM members collection and if not, will create an account. Not the exact same as what you want of course but it uses similar properties / methods.

David_Forbes_(dforbes_-_(deleted))

Here's a code sample covering Word integration as well connection to LL via LLcom. In this particlar example, there was a mapping of form fields to Word bookmarksI've attached the LLcom programmer's guide to give you a more complete understanding of LLcom