Installation 1.x

Steps to install and configure the Invoice Capture application in OpenKM v7.1: 

CREATE USER 'invoice'@'%' IDENTIFIED BY 'openkm';
CREATE DATABASE invoice DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
GRANT ALL ON invoice.* TO 'invoice'@'%' WITH GRANT OPTION;

• Register the English and Spanish translations in the OpenKM.
• Stop Tomcat
• Download the application from OpenKM download center
• Place the invoice.war file into $TOMCAT_HOME/webapps
• Place the invoice-plugins.jar file into $TOMCAT_HOME/plugins
• This application need to share the database with OpenKM, so you don't need to create a new one
• Create the configuration file $TOMCAT_HOME/invoice-capture.properties (this is a sample configuration which need to be adapted to the target environment)

# Database
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/okmdb?useUnicode=true&characterEncoding=UTF8&serverTimezone=CET
spring.datasource.username=openkm
spring.datasource.password=openkm
spring.jpa.hibernate.ddl-auto=create
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL57InnoDBDialect

# OpenKM
openkm.url=http://localhost:8080/openkm
openkm.url.preview=http://server.ip:8080/openkm

# OpenKM admin user
admin.user=invoice
admin.password=s3cr3t0

# Preview
preview.download.url=http://server.ip:8080/invoice/download

# OpenKM folder
standard.import.node=bb381ac2-f3f6-42b4-8df6-fbd0e87054ce
advanced.import.node=76d1c3c7-d085-47ec-a153-c146e63ee9d9
root.destination.folder.path=/okm:root/invoice

# Available languages
languages=en-GB,es-ES
default.language=es-ES

# Logos
app.logo=http://server.ip:8080/openkm/logo/login
app.logo.login=http://server.ip:8080/openkm/logo/login

# Filter companies list in the search view based in documents of the companies previously uploaded by the user
filter.companies.by.user.upload.documents=false

The openkm.url configuration property family is also important because Invoice Capture will use this user to interact with you OpenKM instance. So, configure an user with enought permissions. This user should already exists in OpenKM. 

The standard.import.node and advanced.import.node properties need to be valid uuids of existing folders on your OpenKM. These folders are used to upload the invoice documents.

The folder defined in root.destination.folder is created automatically in the root of your OpenKM's Taxonomy on the first invoice catalogued.

• Start Tomcat
• Edit the configuration file $TOMCAT_HOME/invoice-capture.properties and modify the value of this property to "update", this property should looks like this:

spring.jpa.hibernate.ddl-auto=update

• Log into OpenKM and follow the user guide documentation of Invoice Capture.

• Once the application is configured you can log to http://server.ip:8080/invoice with the default administrator:
  • User: admin
  • Password: admin
• Remember to change this default password!!