Optimal BPM Files

Release notes for Optimal BPM tools 0.9.0
=========================================

Optimal Sync:
  * Expose all the new QAL features mentioned below
  * Improve GUI, frames are now resizing predictably and logically


New QAL 0.4.0-features that are exposed in Optimal Sync
-------------------------------------------------------
  * Add support for importing data without specifying keys
  * Automatically create non-existing destination tables.
  * Add support for writing to new files.
  * Add support for regular expression-transformation
  * Add support for writing to .xls and .xlsx files using openpyxml and xlwt
  * Add post-merge-sql; an SQL that is run in SQL backends after commit.
  * Add support for substitution variables(::identity::, ::uuid::, ::username::, ::curr_datetime::)
  * Columns/fields without a source reference is now allowed

More information and a full list of features at:
http://www.optimalbpm.se/wiki/index.php/Optimal_Sync


Installation instructions.
==========================

Please create tickets for all bugs, lacking documentation or installation issues you encounter.
(Documentation for optimal sync is at http://www.optimalbpm.se/wiki/index.php/Optimal_Sync)


WINDOWS:
--------
To install, first uninstall any earlier versions, then download and run optimalbpm-tools-bundle_0.9.0.exe, which
installs the Optimal BPM Tools package and its proper dependencies(see below).

To install example files, select "custom" installation and choose "Will be installed on local hard drive".
Don't forget to choose and install location, it is recommended to choose a non-readonly location where one can easily
access the files, like the home folder.

Notes:
1. The Oracle and DB2 client libraries has to be installed manually until the legality of redistribution has be researched.
See: http://www.optimalbpm.se/wiki/index.php/QAL.DAL for instructions for some versions.

2. These packages are installed:
# Python 3.4 (into its default directory at C:\Python34).
# prerequisites.0.9.0 - A staging package that install binary lxml and pyodbc* and fixes paths
# Using pip install, it installs QAL, Py-Postgresql, PyMySQL, xlrd, xlwt** and openpyxl

*) The current lxml and pyodbc easy_install packages require visual studio components to be be installed.
**) The xlwt-installation doesn't work for python 3 yet, however the pip-package will soon work.
   Optimal BPM has been tested with the python 3 branch. This means that old-timey .xls can't be written to yet
   without some manual work.

UBUNTU/DEBIAN:
--------------


From launchpad.net PPA in Ubuntu:
.................................

Execute the following commands:

# sudo apt-add-repository ppa:nicklasb/optimalbpm
# sudo apt-get update
# sudo apt-get install optimalbpm-tools


From launchpad.net PPA in Debian(Jessie and onward):
....................................................

Add the following line to /etc/apt/sources.list. The wildcard is there as the there are no matching distro names in
launchpad.net, this way it takes what it gets. It it the same package anyway.

First, using a privileged user, add this to /etc/apt/sources.list

deb http://ppa.launchpad.net/nicklasb/optimalbpm/ubuntu * main

Then execute these commands:

# apt-get update
# apt-get install optimalbpm-tools

Notes for Debian:
1. the root user can be replaced by any other sufficiently privileged user
2. there is a non-standard unicode character in the maintainer's name, this *might* cause problems if you have an old locale.

LANG=C.UTF-8

...might help, read this first though: http://askubuntu.com/questions/393638/unicodedecodeerror-ascii-codec-cant-decode-byte-0x-in-position-ordinal-n

*Without* launchpad.net PPA in either distribution:
...................................................

gdebi is recommended*, to install gdebi, use:
# sudo apt-get install gdebi

Install packages, available above, in the following order:
# sudo gdebi python3-qal_0.4.0_all.deb
# sudo gdebi optimalbpm-tools_0.9.0_all.deb


EXAMPLES:
---------

There are also some example files, use unzip to unpack:
# unzip optimalbpm-tools-examples.zip

Notes:
1. Implicitly, the install requires Ubuntu Trusty or Debian Jessie, or any other distribution with python3-postgresql 1.1.0.
(This because python3-postgresql 1.0.2 is broken: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=724597)
2. gdebi has quite a lot of dependencies, so on a very tight system you might want to use dpgk -i and manually install
dependencies instead.