BPMspace

File Release Notes and Changelog

Release Name: binary_bpmspace-database_1.10

Notes:
I N T R O D U C T I O N

This is the database 'binary' release (SQL dump) for BPMspace, Version 1.10 .

This software is distributed under the terms of the GNU Lesser General Public License. The full text of the LGPL license is in lgpl.license.txt.

Release 1.10 of BPMspace has been tested on MySQL only.


D E P E N D E N C I E S

(A) MySQL Database 5 (we use 5.0.20a-nt)

You need MySQL 5 for BPMspace, because BPMspace is using SQL views.


F R E S H . I N S T A L L A T I O N

This procedure will create a new schema named 'jbpmtest' on your MySQL server. You may change connection information (schema name, user name, password), but then you need to adjust your Datasource in the BPMspace Application Server accordingly.

1. install MySQL with transactional support (InnoDB)
2. exit any command shell

3. extract this relase to a file system folder

4. change to the "bpmspace-application/db/mysql" folder of this release

5. execute 1_create-schema.cmd [your MySQL root password]
6. execute 2b_restore-bpmspace-schema.cmd
7. execute 3_create-bpmspace-views.cmd


U P G R A D E  . F R O M  . V E R S I O N   1 . 0 0

This procedures describes how you setup a new, clean database after you had installed Version 1.00 of BPMspace. If you want to save your process or CMDB data from Version 1.00, please see the "SAVING PROCESS DATA" section below.

1. change to the "bpmspace-application/db/mysql" folder of release 1.00

2. execute 6_drop-schema-only.cmd (THIS WILL DELETE ALL YOUR EXISTING DATA)

3. extract this relase 1.10 to a file system folder

4. change to the "bpmspace-application/db/mysql" folder of this release

5. execute 1b_create-schema-only.cmd
6. execute 2b_restore-bpmspace-schema.cmd
7. execute 3_create-bpmspace-views.cmd

D O N E !

Now you can continue to install the BPMspace Application Server ( http://downloads.sourceforge.net/bpmspace/binary_bpmspace-starters-kit_1.10.zip ).


S A V I N G . P R O C E S S . D A T A 

If you want to save your process data (including CMDB data) before upgrading to a more recent BPMspace Version, then follow this procedure.

A) SAVING

1. Log in to the BPMspace application

2. Execute the "all Objects" Object Report for each process definition of which you want to save data

3. Click on the "Export to Excel" icon

4. Save each resulting excel sheet as ".XLS" format (not .XML) into a separate file

B) UPGRADE

Follow the Installation procedures for BPMspace Database and BPMspace Starters Kit

C) RESTORING

1. Log in to the BPMspace application

2. Enter the System Maintenance page

3. Push the "Choose File" button in "Process Import" section
4. Push the "Import" button
5. Review the preview result

6. Enter the System Maintenance page again
7. Change the "Import preview only" list entry to "No"
8. Push the "Import" button

(Repeat this procedure for each saved excel file)


Changes: