A PPA was recently created to drastically simplify installation on Ubuntu platform.
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):
....................................................... read more
After a period of proofs of concept and prototypes the development of Optimal BPM is now picking up the pace significantly, hopefully the world will see something really interesting happen this spring.
Put in that context, a release of Optimal BPM Tools and QAL is kind of inevitable.
There is a whole bunch of features being added around the system and Optimal Sync is a really convenient way of testing them.... read more
The 0.8.4 version is now out and has some quite important fixes.
It is recommended to uninstall and then run the new windows installation.
The QAL API documentation is now online for your browsing pleasure!
Python3-Sphinx was used, a small article on that subject may develop over time as well.
After somewhat more work than expected, a windows installer bundle has seen the light.
It is available for download at the files section.
I talk about light quite literally as the WiX installer tools used are called candle, light and paraffin. I did not use heat for a number of reasons.
One thing that resulted from this was a guide on how to use WiX. Or more a primer before reading the official tutorial at http://www.optimalbpm.se/wiki/index.php/WiX.
Optimal Sync 0.8.3:
* Fix GUI resizing
* Fix successive errors on reload(as in stop flogging a non-existing server)
* Fix handling of relative paths
* Fix everything Windows, like paths, line-terminators and some other things
* Fix helpful error when modules are missing
* Fix bad relative path handling for spreadsheets
Optimal Sync 0.8.2
* Fix annoying error message from non-working MySQL database selector (TODO: Fix that thing)
Keys could become unordered in earlier versions, 0.3.2 remaps keys properly.
Please use QAL 0.3.2 instead of 0.3.1.
Fix handling with empty destination
Fix bug: Offset should include header
Fix bug: Explicitly convert offsets to int from resource
Fix helpful module import error
Important Optimal Sync-fixes:
Fix so that direct call to merge succeeds
What? Sales department saving their contacts in an excel sheet? You want their edits maintained in the CRM database? Do you regularly want to download a data set from a table in a web page? And transform the data a little before you insert it?
Optimal Sync is a small and simple multi-platform(well soon) BPM utility that is able to move and affect data between different many sources and destinations. ... read more
This project will within a few weeks release its first actual tool, the Optimal Sync - application.
It is a very versatile, scriptable and simple-to-use tool that can transfer and transform data between PostgreSQL, MySQL, SQL Server, IBM DB2, Oracle, Flat file, XML, HTML and Spreadsheets.
To make things easier, it has a graphical interface that can simulate the diff and merging process.
And it really is easier. Tools like these are usually highly complex, this is not, while still being able to be very useful.... read more