Livelink Outlook beginner

[forX]

Hi, my company have livelink and they ask me to do something.


I need first to implement an addon on outlook.
I need to search some work in livelink folder (and there like a million of folder)
I look at MAPI, but when I go too far on the folder tree, every thing froze.

I'm not sure where to go. if you have any tip.

I saw that we can use webdav, I'm not sure how?

what kind of lib I should use for get folders
and after I'm supposed to transfer an email to the folder found

so.. any tips will be helpful

tank you

 

[appnair]

you can use a combination of mapi+lapi or mapi+websvcs to do what you are after.however if your org stores 1 millions items under a parentid it is not healthy for retreival or manipulation.Perhaps with paging enabled in the livelink gui you are hiding the problems .If your intention is to find a folder by name under a certain parent and if you have 1 million items instaed of doing a listobjects and thereby hanging your code,I would try to create the folder you are creating.If it exists then livelink will produce an error.at this point you could ask for getObjectInfo for that folder and put your item there.I would suggest that you convince your org not to put too many items under a folder.You could also use livelink search or a livereport to query the livelink folder under the paraentid as they will be faster than trying to do listobjects which would hang normally but you can alaways do listobjects in a way like a sql script.

for eg I can run a listobjects lapi call in livelink akin to

select name,subtype,dataid from livelink.dtree where subtype=0 and name like 'folder ai am searching for'.

methods exist for doing this query in lapi I am not sure if they have it for websvcs.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[forX]

tanks for the tips,
but I'm still with my problem,
I know that I will never change their Livelink system (governmental company, too big, too much security and ….) I try to found a way to talk with our live technical support (or somebody who have the acces of the knowledge center of opentext)

So now I need to work with what I have.

You talk about using Livelink search, did you mean something like call the web page prog (

http://livelink.mycompany/Livelink/livelink.exe)

add param like in get (somebody use get param in an other forum post)

I get the html result and analyse it (like a website grabber)

I just begin to looking a Livelink lib that you can add on outlook. Maybe that will help for folder creation. Its probably there that you have you getObjectInfo.(?)

I don’t know what is "livereport", if you said there's a way to do something like sql, that can be fantastic.

Did you have already code something with Livelink? Or maybe you know somebody that you may refer? If you can post something, be sure I will look at it.

Tank you for your help and time

 

[forX]

One of my coleague talk to me about lql, maybe I can use it. but somebody on this forum said that its better to use lapi???

 

[appnair]

LQL-Livelink query language you can call livelink search engine.It is just a html post to a livelink server

http://www.tek-tips.com/faqs.cfm?fid=3552

here is examples a lot of examples and coding guide in the kb knowledge.opentext.com
Livelink online help has examples as well


LiveReport-Is a object that you carete in livelink and it calls the livelink schema.So it is very easy to find things underneath a particular objid in livelink.BTW I guess you have logged into livelink so you know what when I mean objid,daytaid,parentid et alIf not try to get into your livelink webgui.It will help a lot

Livelink API or LAPI is a set of client libraries you load into your program and call a particular livelink instance
The sdk can be obtained in opentext if you are a paying customer.
see examples at

http://www.greggriffiths.org/livelink/development/lapi/

communities.opentext.com

Livelink API is old and obsolete now so if your org is on 9.7.1 it may have websvcs.Here in your coding you provide refernces to the webservices serverand use more modern programming methods.I do not think websvcs allows you to execute live reports

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[forX]

We are on 9.7.1, but I'm not sur about the websvcs, I don’t know what I can ask to my Livelink contact. I'm afraid that asking for a sdk, they will retreat.

I heard that we have an internal team and an external (consulting) team for Livelink. I don’t know how much I will be authorise to work.

Its possible that we have a web service, I don’t know yet, I will ask. (And can I call it from anywhere on the company?)

I think I don’t give enough info on my first post. that will help you to see where I am.
The most of what I will said will probably redundant (something that you already know Livelink is)

I'm new(intern) on the company, and a little thing on a big thing.
The company use Livelink since 10years. I'm supposed to develop something for my division and maybe for other division after (need to create something generic, we will see).
I had a little basic training how to use it.
The already have on explorer, a web "service" (login, control on Livelink.exe don’t know much about it). They have something install on pretty much all office apps (Livelink menu). On Outlook, Livelink is on the mail folder so you can drag a mail on a livelink folder.
For the moment, I just use little thing on vba

    Dim olApp As Outlook.Application
    Dim olNamespace As Outlook.NameSpace
    Dim olFolder As Outlook.MAPIFolder     
    Set olApp = New Outlook.Application
    Set olNamespace = olApp.GetNamespace("MAPI")     
    For Each olFolder In olNamespace.Folders

And I know that we have libs (lloffice, lliehelper, llEditProcess, llEdit, lldsui)
I don’t know what to do with that.

So now you know much where I am and you can see that your help is really enjoyed.

Did you have a tips about what I should ask?
Where I shoud start?If you would be me, what do you use to solve the problem (MAPI, LAPI,Websvcs,livereport,lql…) ?

I can never thank you enough

Good day

 

[appnair]

The success of any project is to understand the requirements.It looks to me that this company is re-inventing the wheel as the product called Livelink Explorer(now it called livelink connect) already has a Mail plugin(works with outlook and lotus mail clients)
Some companies do develop mapi plugins for livelink,they do it because they want to create auatomatic routines in the mailboxes such as periodic archiving without user intervention into livelink and so on.again that is also productised by OT some factors reamin like budgets usabilty etc that prompts people to code for these kinds,So I would advise that look exactly what they want developed,if it needs development and so on.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[forX]

I'm sure what they want, (I create a report with descriptions, state diag...)
its a tool, call by a button on outlook
the tool look at the object of the mail
and search specific word (mostly projectId) //I can do that
after, the tool seach a folder with the word found before
the third step is to move the mail into the folder

we have other thing to add like we can just show the folder at the end rather than move the mail.
we will try to add the id of the folder somewhere in the mail, like if we have "Re" mail, the tool will view the id and move the mail into.

its not so big, but if I do it with mapi, it will take so much time to found the folder. Thats why I search for something else.

do you think its still re-inventing the wheel

I'm not sure its internal modif for outlook integration, use have little possibilities, (open in livelink, save in livelink, save as., close modif, cancel modif, categories).

 

[ggriffit]

if you are just trying to file emails in Livelink, then the better option may be to use eLink. Using this you can assign an email address to a specific folder in Livelink and then copy that address in the emails and it will appear automatically in the folder.

eLink is a free module from OT as well.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[forX]

its not the email address I want to check, but the subject of an email,

I will look at eLink other options, tanks

 

[ggriffit]

ForX,
When a elink message arrives in Livelink, Livelink uses the email address to look up the relevant folder and then puts the message into that folder for you automatically, all you need to do is to add the relevant email address to the list of people the email is sent to.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[forX]

like I said, thats not what I want, I dont care who send or receive the mail, its only the subject who said where the mail should be moved.

 

[forX]

if you mean thats all elink cant do, ok, I think I will look somewhere else

 

[appnair]

you can create a outlook rule like "if subject contains this" then I sent it to this elink address....

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[ggriffit]

What you seem to be asking for is if the subject line contains 1234 then put the message in the folder mapped to 1234 in your system, is that correct ?

If it is then eLink is an appropriate solution as you can just cc 1234@elink.livelink.com - or similar - and the message will appear there with no programming involved at all, just setting up a mapping.

If you do want to do it from the Outlook client, then I would recommend that you Explorer/Enterprise Connect as a starting point as this will provide most of the funcitonality you need.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[forX]

the message will be more like

Re : 1234 | something | somethingelse | more subject description

theres more than 1 folder named 1234
there subfolder named "something"

if there's no folder, I need to say it

I need to show subfolder of the folder that I found because it might goes not at the root

and there will probably have more subtlety.

elink seems intersting at some point, but I dont know how to use it for the moment.

tanks

but I think I need to found another way

any other tips?

 

[ggriffit]

If you want to use the Subject line, I'd recommend storing the Data ID of the destination Folder you want rather than the entire path, as that could get very long or be renamed at any point which would make things difficult for you code.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[forX]

I have a little code that store a new meta tag with the livelink path and I use it to transfert email on this folder
I use the full path because I dont know how to get and use folder id on outlook (if you know ....)

but my biggest problem is to search the good folder by the subject.
because the folder name "contain" a part of the subject (its a special ID)
I can get this id, but search on all folder can take so many time because its too long with mapi search

the best for me can be 1: get a result by a search maybe by livelink service
2: get a full tree (maybe in xml) of the entreprise folder and search in the tree by myself, it will be faster then use outlook folder (because outlook folder get subfolder 1 by 1)

if you know how to get 1 of these

do you know what livelink offer to public (what service I can use? what is opened?

what opentext offer on support? (I need a reason to get the right to use technical support)

 

[forX]

can we use webdav for do a search by "SELECT"

like

http://msdn.microsoft.com/en-us/library/ms992615(v=exchg.65).aspx

for the moment , my query always return "HTTP Error 501 - Not Implemented", so that's mean that the server cant do that, or just that I do the wrong query (Its more like that)

any one know how to do it?

 

[appnair]

one would think that on the livelink server they have installed and configured webdav.if webdav is on your livelink server and the microsift example does not work then you would need to work with OT to figure out why the query does not work.returning results in a xml file is very easy to do in livelink and e.g in this forum itself

but if you have 5 million items under a folder the xml document will be very huge unless you want to restrict the scope so it becomes manageable

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair