Loading metadata to Livelink using Bulk Loader API's

[bhumble]

Hello,
I'm in need of some real direction. I am new to all tools I am about to mention, so please speak in layman terms for my understanding.

I am currently working on extracting data from an Oracle8 database and loading that data into cvs format files from a UNIX system. I will then be loading the metadata into Livelink. Bulk Loader is the utility I'm expected to interface with to accomplish this task in a somewhat real-time batch process. I will be using Java to write the script, which is also new to me. Could some please tell me how to approach the task of loading the data into Livelink using Bulk Loader utilities/functions?

 

[appnair]

I think you need to make sure about Comma Separated Values or
Concurrent Version Systems utility.The bulk loader is a livelink affinity partner product that is made by

http://www.syntergy.com/products/bulk_load/index.html

which allows you to bulk load a Comma Separated Value input file.If you are going to use the bulk loader utility that is mentioned above please be re-assured that anything you may need will be fully covered under thier documentation

If you need to write something from scratch and use java which also is my favorite language pls see my posting using the Livelink Application Programming Interface at

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

I recently did a bulk download tool for my present company keeping all configuartion info in XML and I'm sure you won't have too much problem in converting that to an upload tool.

The ability to perceive or think differently is more important
than the knowledge gained.
- David Bohm

 

[bhumble]

Thanks appnair. That was very helpful. I now have another question. I am having problems getting pass the firewall to access the data from the database in Java. However, I am able to start a telnet session using "SSH" that bypasses this problem. Is there anyway to do that in Java?

 

[appnair]

there are some examples in the knowledge base showing you how to access a secure livelink server using LAPI.try those psot your query in the lapi discussions in KB and somebody who has done similar kind of work is bound to help you.stictly speaking you do not need native access to the database that is hosting the livelink application.you can still do everything if you hit the lapi server

 

[bhumble]

Thanks, but I don't have a login for KC. Could you post some examples here? Also, please explain and give an example as to how I can do everything by hitting the lapi server, if that's okay. I'm totally uneducated in this arena.

 

[appnair]

simple set up on a test server install
a)Set up a webserver software.The easiest installs would be microsoft II5.0 or Sun One 6.1.I run win2k
b)Locate livelink software and livelink SDK CD.The lapi server is on the SDK-You will need a rudimentary knowledge of a database setup.The easiest would be win/oracle 8.1.7 so you can create a table space for livelink to to its schema.
c)Livelink will walk thru your primary installation assuming you are not doing anything complicated accept the default stuff.LL will take sometime creating the enterpise SOV(System object volume etc.Use common sense when filling out values.Do not put 64 K of memory for indexing if your computer has only 32 K abvailable
c a)Livelink once installed requires you to do some license info email info etc this is done by <livelink url>/livelink.exe?func=admin.index.This take you to administration page the default admin password is 'livelink' put that in and see the options.if you change password write it somewhere where you can access it.
d)Once everything subsides check working of system check whether you can add enterprise workspace,add documents,create folders etc by calling the web server URL that livelink gave you at the last part of installation.

e)Once you have established that the livelink server is intalled and working correctly proceed to install lapi from the 2nd CD.Make a note of the installation path of the lapi files.
f)open your opentext.ini and look at the port of your livelink server.
g)Now your albeit LAPI server is the same livelink server listening on that port.
h)If you are using VB you will have to incorporate all the bas and supporting files in your project
e)If you are using java you should put the path of com.opentext.api in your class path to tell the client where the lapi class files are
f)attempt running a simple example as below



Listing AccessEnterprise.java
//Access Enterprise Workspace

//import classes
import com.opentext.api.*;
//Lapi class files it need to in classpath
import java.net.*;
//socket TCP/IP calls use the above classes

public class AccessEnterprise
{
private static String Server = &quot;127.0.0.1&quot;;//llink host
private static int Port = 2099;//see opentect.ini
private static String DFT = &quot;&quot;;
private static String User = &quot;Admin&quot;;//default
private static String Pass = &quot;livelink&quot;;//default

public static void main (String [] args)
{
try
{
//variables
LLSession session;
LAPI_DOCUMENTS doc;
LLValue value = new LLValue();
int volID, objID;



session = new LLSession (Server, Port, DFT, User, Pass);
doc = new LAPI_DOCUMENTS (session);

//Access the Enterprise
if (doc.AccessEnterpriseWS(value) == 0)
{
System.out.println(&quot;Enterprise Accessed Successfully&quot;

//Extract the Enterprise Volume and Object ID's and display them.
objID = value.toInteger(&quot;ID&quot;
volID = value.toInteger(&quot;VolumeID&quot;
System.out.println(&quot;Enterprise ID: &quot; + objID);
System.out.println(&quot;Enterprise Volume: &quot; + volID);
}
else
System.out.println(&quot;Failed to Access EnterpriseWS&quot;


}
catch (Throwable e)
{
System.err.println(e.getMessage() );
e.printStackTrace (System.err);
}
}

}


if the above java files excute it by java AccessEnterprise and see if you are hitting the exception block of code .If everything is kosher you should either see '2000' or '2001' which is you r enterprise Id
sorry i do not have vb examples

this is from my experience with livelink 8.1.5 and 9.1.0 sp2 I haven't gone past that

You cannot do any https tests unless you have a valid certificate file.i do not have the necessary secure server experience but should be very same.