Bonitasoft x Processmaker

Hi!!

I have recently tested both products (opensource version) Bonitasoft and Processmaker.
In my opinion, Processmaker is easier to learn and is more intuitive. Besides, the opensource version of Processmaker has many more features than Bonitasoft.
So, that's my decision.
If had to decide between the two opensource versions, I would stick with Processmaker.

Há!

ProcessMaker - final considerations

Hi!

I have just performed a full proof of concept on ProcessMaker BPM application, and I found something really difficult to overcome.
No matter where you are in the application, the columns you can visualize are

#, Summary, Case Notes, Case, Process, Task, Current User, Last Modify, Status

Well, let's think that in your process there are informations like subject, areas, products and so on.
If you try to use the search functionality, you're gonna find out that this very search doesn't include the dynaform fields. Why? My guess is that those fields are stored at XML structure and for this reason it becomes impossible to search on them.
Imagine you have a lot of inbox messages but you can't search on the content and you can't see the subject. You'll have to open all your messages, one by one, to find out what you are looking for.
But isn't possible to add columns that transform the view in a more intuitive experience? Yes, there is. But they are only available at the paid version, U$ 9.900,00 .
In my opinion, the opensource version of ProcessMaker has this huge problem, the search.
Conclusion:
In my scenario, I should say NO to opensource version of ProcessMaker

 

 Now I'm gonna try the Bonitasoft.

Using parameters with OledbCommand - Integration Services

In OledbCommand, parameters are indicated by using question marks.

UPDATE PMT_SOLICITACAO
SET APP_STATUS = ?
WHERE APP_UID =  ?

MySQL / Integration Services

How could you use MySQL with Integration Services?

Step1
Download and install a suitable odbc connector to MySQL
http://dev.mysql.com/downloads/connector/odbc/
Be careful with the version.
If your version is 5.1.5, like mine you should download the odbc connector from here http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-5.1&v=5.1.5

Step2
Create a datasource.

Step3
With datasource created, go back do Integration Services and chose DataRead component.

Step4
Drop the DataReader on the Data Flow and chose one of the connections of connection manager.

You're done. You're ready to work with MySQL data.

ProcessMaker - Example of trigger

Hey!

My brand new addiciton is the BPM tool, ProcessMaker.

The definition of the function I'm gonna use:

PMFNewCase()

PMFNewCase() creates a new case starting in the specified task.

variant PMFNewCase(string processId, string userId, string taskId, array variables)

What does this trigger do?

processId = 790924072528a08df8f5a61099702072
userId =  468963623527b95ba2d4f36042887697

Well, my idea was that in the end of a process a new case, of another process would be started for a specific user.
The user will receive in his inbox a case already started with status "to_do". It would be as if he had received an e-mail.

Very simple and very usefull trigger.

$taskId  = '472503662528a09680c7973093755803'; //lookup the starting task's unique ID
$newCaseId = PMFNewCase('790924072528a08df8f5a61099702072', '468963623527b95ba2d4f36042887697', $taskId, array());
//if a new case was created, change its status in the database
if ($newCaseId) {
   executeQuery("UPDATE APPLICATION SET APP_STATUS='TO_DO' WHERE APP_UID='$newCaseId'");
}
else {
   $msg = "Unable to create new case." . isset(@@__ERROR__) ? @@__ERROR__ : '';
   G::SendMessageText($msg, 'ERROR');
}

NuGet - Console - Visual Studio

I always forget how to find packages using NuGet.

Step 1

Step 2
Line command, Get-Package -ListAvailable [Name]

PROCESSMAKER - Webcast - Notifying Users When A Case Is Cancelled, Paused, Deleted or R...

PROCESSMAKER - travellingrequest application through

PROCESSMAKER - Webcast - Setting Permissions To Use Case Notes

How to install OTRS

1 - Install activeperl
Probably like me you don't have activeperl installed on you machine. OTRS uses a specifice version of activeperl : 5.16.3..1603
http://www.activestate.com/activeperl/downloads

2 - Install otrs-3.2.12-win-installer-3.0.2.exe
https://portal.otrs.com/otrs/public.pl?Action=PublicDownloads#
Notice that there's only 32bits version of OTRS, but I installed the solution on a 64bits machine and it worked perfectly.

3 - After finished installation of otrs you'll have to access
http://[your IP]:8080/otrs/install.pl

4 - follow the steps of installation.

Access denied for user 'otrs'@'localhost' (using password: YES) RemoteAddress: ::1 RequestURI: /otrs/index.pl Traceback (10404): Module: Kernel::System::DB::new (OTRS 3.2.12) Line: 225 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.12) Line: 140 Module: PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

Well, I had just finish the installation of OTRS (wich is a software I'l try to use as change management system) when I received this error

Oops! An Error occurred.
 Error Message: Access denied for user 'otrs'@'localhost' (using password: YES)
 Please contact your administrator.
You can Send a bugreport or go back to the previous page.
Error Details
Backend ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: MSWin32 Time: Tue Nov 5 15:30:47 2013 Message: Access denied for user 'otrs'@'localhost' (using password: YES) RemoteAddress: ::1 RequestURI: /otrs/index.pl Traceback (10404): Module: Kernel::System::DB::new (OTRS 3.2.12) Line: 225 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.12) Line: 140 Module: PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

Delightful, isn't it?

Well, how fix it?

1 - Go to command prompt of mysql and give the grant to otrs

mysql> GRANT ALL PRIVILEGES ON *.* TO 'otrs'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

2 - Be sure it worked.

SHOW GRANTS FOR 'otrs'@'localhost';

restart OTRS.