LiveLink Connector

-Djava.security.auth.login.config=etc/livelink_login.conf

# ---------------------------------
# Livelink connection configuration
# ---------------------------------
#connection
protocol=http
hostName=hostname
username=username
password=password
userPrefix=ll1_
folderName=livelink1
port=2099
dbName=
livelinkWS=enterprise
livelinkCGI=/livelink/livelink.exe
#suptype mapping
subtypeConfig={144:Document:b},{0:Folder:k},{131:Category:s},{136:CompoundDocument:k},{140:Url:s},{202:Project:k},{215:Discussion:k},{130:Topic:k},{134:Reply:s},{207:Channel:k},{208:News:s},{206:Task:s},{204:TaskList:k},{205:TaskGroup:k},{212:TaskMilestone:s},{218:Poll:s},{299:Report:s},{132:Query:s},{128:WorkflowMap:s}
#ssl encryption
verifyServer=no
rootCACertsPath=

java -jar crx2livelink-1.3.2.1.jar 
  -testconnect 
  -protocol http 
  -cgipath /livelink/livelink.exe 
  -pw password 
  -host your.host.com 
  -username userid 
  -port 2099

{144:Document:b}

<?xml version="1.0" encoding="UTF-8"?>
<Workspace name="crx.livelink">
   <FileSystem class="com.day.crx.core.fs.local.LocalFileSystem">
      <param name="path" value="${wsp.home}"/>
      <param name="enableHandleMonitor" value="true"/>
   </FileSystem>
   <WorkspaceSecurity>
      <ACLProvider class="com.day.crx.security.LivelinkACLProviderFactory">
         <param name="configPath" 
                value="etc/livelink.properties" />
      </ACLProvider>
      <CompiledACLProvider class="com.day.crx.security.LivelinkCompiledACLProviderFactory" />
   </WorkspaceSecurity>
   <PersistenceManager class="com.day.crx.persistence.livelink.LivelinkPersistenceManager">
      <param name="configPath"
             value="crx/livelink.properties" />
      <param name="enableBinaryData"
             value="true" />
      <param name="livelinkDataUrlHost"
             value="" />
      <param name="binaryLoaderUrl"
           value="http://localhost:7402/crx/livelink" />
      <param name="scopePath"
             value="" />
      <param name="treeDepth"
             value="" />
   </PersistenceManager>
   <SearchIndex class="com.day.crx.core.query.livelink.LivelinkQueryHandler">
      <param name="configPath" 
             value="crx/livelink.properties" />
      <param name="path"
             value="${wsp.home}"/>
   </SearchIndex>
</Workspace>

(...)
          </description>
      </init-param>
   <load-on-startup>6</load-on-startup>
</servlet>
<!-- ======================================= -->
<!-- CRX2LIVELINK OBSERVATION SERVLET        -->
<!-- ======================================= -->
<servlet>
   <servlet-name>CRX2LivelinkObservationServlet</servlet-name>
   <description>The crx2livelink observation servlet</description>
   <servlet-class>
        com.day.crx.persistence.livelink.observation.ObservationServlet
   </servlet-class>
   <init-param>
      <param-name>livelink-config-path</param-name>
      <param-value>etc/livelink.properties</param-value>
   </init-param>
<init-param>
<param-name>livelink-deletereport-id</param-name>
<param-value>7905</param-value>
</init-param>
<init-param>
<param-name>livelink-deleteitemreport-id</param-name>
<param-value>10511</param-value>
</init-param>
<init-param>
<param-name>livelink-modifiedreport-id</param-name>
<param-value>7906</param-value>
</init-param>
<init-param>
<param-name>livelink-renamedreport-id</param-name>
<param-value>10184</param-value>
</init-param>
   <init-param>
      <param-name>scan-interval</param-name>
      <param-value>120</param-value>
   </init-param>
   <init-param>
      <param-name>crx-workspace</param-name>
      <param-value>crx.livelink</param-value>
   </init-param>
   <init-param>
      <param-name>repository-name</param-name>
      <param-value>crx</param-value>
      <description> Repository Name that is used to retrieve it via JNDI
      </description>
   </init-param>
   <init-param>
      <param-name>java.naming.provider.url</param-name>
      <param-value>http://jcr.day.com</param-value>
   </init-param>
   <init-param>
      <param-name>java.naming.factory.initial</param-name>
      <param-value> com.day.util.jndi.provider.MemoryInitialContextFactory
      </param-value>
   </init-param>
   <load-on-startup>10</load-on-startup>
</servlet>
<!-- ======================================== -->
<!--     S E R V L E T   M A P P I N G        -->
<!-- ======================================== -->
(...)

(...)
<!-- ======================================= -->
<!-- CRX2LIVELINK OBSERVATION SERVLET        -->
<!-- ======================================= -->
(...)
   <load-on-startup>10</load-on-startup>
</servlet>
<!-- ======================================= -->
<!--        EVENT LOGGER SERVLET             -->
<!-- ======================================= -->
<servlet>
   <servlet-name>EventLoggerServlet</servlet-name>
   <description>The Event Logger Servlet</description>
   <servlet-class>
       com.day.crx.eventlogger.EventLoggerServlet
   </servlet-class>
   <init-param>
      <param-name>userid</param-name>
      <param-value>admin</param-value>
   </init-param>
   <init-param>
      <param-name>password</param-name>
      <param-value>00dac218ba4254da</param-value>
   </init-param>
   <init-param>
      <param-name>workspaces</param-name>
      <param-value>crx.livelink</param-value>
   </init-param>
   <init-param>
      <param-name>storageroot</param-name>
      <param-value>crx.logger/events</param-value>
   </init-param>
   <init-param>
      <param-name>repository-name</param-name>
      <param-value>crx</param-value>
      <description>
          Repository Name that is used to retrieve it via JNDI
      </description>
   </init-param>
   <init-param>
      <param-name>java.naming.provider.url</param-name>
      <param-value>http://jcr.day.com</param-value>
   </init-param>
   <init-param>
      <param-name>java.naming.factory.initial</param-name>
      <param-value> com.day.util.jndi.provider.MemoryInitialContextFactory
      </param-value>
   </init-param>
    <load-on-startup>11</load-on-startup>
</servlet>
<!-- ======================================== -->
<!--     S E R V L E T   M A P P I N G        -->
<!-- ======================================== -->
(...)

(...)
<!-- ======================================= -->
<!--        EVENT LOGGER SERVLET             -->
<!-- ======================================= -->
(...)
   <load-on-startup>10</load-on-startup>
</servlet>
<!-- ======================================= -->
<!--   CRX2LIVELINK BINARY LOADER SERVLET    -->
<!-- ======================================= -->
<servlet>
   <servlet-name>CRX2LivelinkBinaryLoaderServlet</servlet-name>
   <description>The crx2livelink binary loader servlet can be used to get the binary directly from the Livelink instance</description>
   <servlet-class>
      com.day.crx.persistence.livelink.servlet.BinaryLoaderServlet
   </servlet-class>
   <init-param>
      <param-name>livelink-config-path</param-name>
      <param-value>crx/livelink.properties</param-value>
   </init-param>
   <init-param>
      <param-name>pool-size</param-name>
      <param-value>8</param-value>
   </init-param>
   <init-param>
      <param-name>max-retries</param-name>
      <param-value>4</param-value>
   </init-param>
   <load-on-startup>8</load-on-startup>
</servlet>
<!-- ======================================== -->
<!--     S E R V L E T   M A P P I N G        -->
<!-- ======================================== -->
(...)

<servlet-mapping>
   <servlet-name>CRX2LivelinkBinaryLoaderServlet</servlet-name>
   <url-pattern>/livelink/*</url-pattern>
</servlet-mapping>

com.day.crx {
  com.day.crx.security.authentication.CRXLoginModule sufficient;
  com.day.crx.security.LivelinkLoginModule optional
        principal_provider.class=" com.day.crx.security.LivelinkPrincipalProvider "
        principal_provider.name="livelink"
        sync_interval="180"
        configPath="etc/livelink.properties";
  com.day.crx.security.LivelinkLoginModule optional
        principal_provider.class="com.day.crx.security.LivelinkPrincipalProvider"
        principal_provider.name="livelink2"
        sync_interval="180"
        configPath="etc/livelink2.properties"; 
  com.day.crx.security.LivelinkLoginModule optional
        principal_provider.class="com.day.crx.security.LivelinkPrincipalProvider"
        principal_provider.name="livelink3" 
        sync_interval="180"
        configPath="etc/livelink3.properties";
};

com.day.crx {
   com.day.crx.security.CRXLoginModule sufficient;
   com.day.crx.security.LivelinkLoginModule required
   principal_provider.class="com.day.crx.security.LivelinkPrincipalProvider"
   principal_provider.name="livelink"
   sync_interval="3600"
   configPath="crx/livelink.properties";
};

com.day.crx {
  com.day.crx.security.authentication.CRXLoginModule sufficient;
  com.day.crx.security.LivelinkLoginModule optional
   principal_provider.class="com.day.crx.security.LivelinkPrincipalProvider"
   principal_provider.name="livelink"
   sync_interval="3600"
   configPath="crx/livelink.properties";
   com.day.crx.security.LivelinkLoginModule optional
   principal_provider.class="com.day.crx.security.LivelinkPrincipalProvider"
   principal_provider.name="livelink2"
   sync_interval="3600"
   configPath="crx/livelink2.properties";
};

//element(*,ll:Document)

public Session getSession() {
Session session = null;
try {
Hashtable env = new Hashtable();
env.put("java.naming.provider.url", "http://jcr.day.com");
env.put("java.naming.factory.initial", "com.day.util.jndi.provider.MemoryInitialContextFactory");
InitialContext ctx = new InitialContext(env);
Repository r = (Repository) ctx.lookup(“crx”);
Credentials creds = new SimpleCredentials(“admin”, “admin”.toCharArray());   
Session session = r.login(creds,”crx.livelink”);
} catch (NamingException e) {
log.error(e.getMessage(),e);
}
return session;
}

public Session getSession() {
Session session = null;
try {
String rmiURI = “rmi://localhost:1234/crx”;
ClientRepositoryFactory factory = new ClientRepositoryFactory();
Repository r = factory.getRepository(rmiURI);
Credentials creds = new SimpleCredentials(“admin”, “admin”.toCharArray());   
Session session = r.login(creds,”crx.livelink”);
} catch (NamingException e) {
log.error(e.getMessage(),e);
}
return session;
}

getSession().getWorkspace().getObservationManager().addEventListener(…)

QueryManager qm = getSession().getWorkspace().getQueryManager();
Query query = qm.createQuery(q , Query.XPATH);
QueryResult res = query.execute();
RowIterator rIter = res.getRows();
while (rIter.hasNext()) {
Row r = rIter.nextRow();
Value[] vals = r.getValues();
for (int i=0;i<vals.length;i++) {
…DO ANYTHING WITH THE RESULT…
}
}

//*
//element(*,nt:file)
//element(*,nt:folder)
//element(*,nt:hierarchyNode)
/jcr:root//element(*,nt:hierarchyNode)
/jcr:root//element(*,nt:base)
/jcr:root//element(*,nt:folder)
/jcr:root//element(*,nt:file)
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created < xs:dateTime("2007-03-12T00:00:00.000Z") or @jcr:created > xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created < xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created = xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created >= xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created > xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[jcr:contains(@jcr:data, "google")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-03-12T00:00:00.000Z")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-02-15T00:00:00.000Z") and jcr:like(@jcr:mimeType,"application/%")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-03-14T00:00:00.000Z") and jcr:like(@jcr:mimeType,"application/%")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-03-14T00:00:00.000Z") and jcr:like(@jcr:mimeType,"ext")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-03-14T00:00:00.000Z") and jcr:like(@jcr:mimeType,"text")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created != xs:dateTime("2007-03-14T00:00:00.000Z") and jcr:like(fn:lower-case(ojcr:local-name(.)),"%/vnd.ms-powerpoint")]
/jcr:root//element(*,nt:hierarchyNode)[@jcr:created = xs:dateTime("2007-02-26T00:00:00.000Z") and jcr:like(@ll:FILENAME,"%.ppt")]
/jcr:root//element(*,nt:hierarchyNode)[jcr:like(@ll:FILENAME,"%.txt")]
/jcr:root//element(*,nt:hierarchyNode)[jcr:contains(*,"google")]
/jcr:root//element(*,nt:hierarchyNode)[jcr:contains(ll:FILENAME,"http://www.google.com")]
/jcr:root//element(*,nt:hierarchyNode)[jcr:contains(ll:MIMETYPE,"application/vnd.ms-powerpoint")]
/jcr:root//element(*,ll:Url)
/jcr:root//element(*,ll:Url) order by @ll:CREATEDATE
/jcr:root//element(*,ll:Document) order by @ll:CREATEDATE descending
/jcr:root//element(*,nt:folder) order by @ll:CREATEDATE descending
/jcr:root//element(*,nt:folder)[@jcr:created < xs:dateTime('2007-03-12T00:00:00.000Z')] order by @ll:CREATEDATE descending
/jcr:root//element(*,nt:folder)[@jcr:created < xs:dateTime('2007-03-12T00:00:00.000Z')] order by @ll:MIMETYPE descending
/jcr:root//element(*,nt:base) order by @ll:FILENAME descending
/jcr:root//element(*,nt:base) order by @ll:FILENAME ascending

java -jar crx2livelink-1.3.2.1.jar 
  -testconnect 
  -protocol http 
  -cgipath /livelink/livelink.exe 
  -pw password 
  -host your.host.com 
  -username userid 
  -port 2099

CRX Content Repository Extreme (r) Connector for OpenText Livelink ("the 
Software"). By installing the Software you agree to the following terms and 
conditions.

This Software is protected by copyright law and international treaties. This
Software is licensed (not sold), and its use is subject to a separate license
agreement between you and Day or Day's authorized resellers. By installing the
Software you confirm to be an authorized user of the software in accordance
with such license agreement. The unauthorized use, copying or distribution of
this Software may result in severe criminal or civil penalties, and will be
prosecuted to the maximum extent allowed by law.

Remote Verification. You acknowledge and agree that the Software may contain
verification and reporting functionality that allows the remote reporting of
your usage of the Software for the purpose of verifying your compliance with
these terms and conditions. If remote verification reveals that you are using
the Software in violation of these terms and conditions, you agree to cease
such unauthorized use and to pay Day's reasonable expenses and a penalty fee
associated with such remote verification and your unauthorized use.

DAY, the DAY logo, Communique, ContentBus and CRX Content Repository Extreme
are registered trademarks and service marks, or are trademarks and service
marks, of Day Management AG, Switzerland, in various countries around the world.

All other product names and company logos mentioned in the information,
documents or other items provided or available herein may be the trademarks of
their respective owners.

     Copyright (C) 2000-2002 Brett McLaughlin & Jason Hunter.
     All rights reserved.
     
     Redistribution and use in source and binary forms, with or without
     modification, are permitted provided that the following conditions
     are met:
     
     1. Redistributions of source code must retain the above copyright
        notice, this list of conditions, and the following disclaimer.
     
     2. Redistributions in binary form must reproduce the above copyright
        notice, this list of conditions, and the disclaimer that follows 
        these conditions in the documentation and/or other materials 
        provided with the distribution.
    
     3. The name "JDOM" must not be used to endorse or promote products
        derived from this software without prior written permission.  For
        written permission, please contact license@jdom.org.
     
     4. Products derived from this software may not be called "JDOM", nor
        may "JDOM" appear in their name, without prior written permission
        from the JDOM Project Management (pm@jdom.org).
     
     In addition, we request (but do not require) that you include in the 
     end-user documentation provided with the redistribution and/or in the 
     software itself an acknowledgement equivalent to the following:
         "This product includes software developed by the
          JDOM Project (http://www.jdom.org/)."
     Alternatively, the acknowledgment may be graphical using the logos 
     available at http://www.jdom.org/images/logos.
     
     THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED
     WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
     OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
     DISCLAIMED.  IN NO EVENT SHALL THE JDOM AUTHORS OR THE PROJECT
     CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
     SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
     LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
     USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
     ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
     OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
     OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
     SUCH DAMAGE.
     
     This software consists of voluntary contributions made by many 
     individuals on behalf of the JDOM Project and was originally 
     created by Brett McLaughlin <brett@jdom.org> and 
     Jason Hunter <jhunter@jdom.org>.  For more information on the 
     JDOM Project, please see <http://www.jdom.org/>.