topic Re: How to connect with a ProcessMaker Database in QlikView

How to connect with a ProcessMaker Database

Tue, 18 Feb 2014 22:44:52 GMT

Hi Everybody

At this moment i am working designing a Dashboard for some process in a company, the processes were made in Processmaker that is a popular BPM, the database is MySql and the idea is process that information in Qlikview in order to define some KPI to be measure on real time.

My problem is that the information that i need to process, is included in only one field of the database, in the picture below you can see the information in the APP_DATA field.

Someone knows how can i process that information?

Sorry for my english.

B.R.

Re: How to connect with a ProcessMaker Database

Thu, 20 Feb 2014 13:38:18 GMT

Hi Wilmar,

The information stored in the APP_DATA is an array, you have to obtain the APP_DATA, inside ProcessMaker, for example with a trigger and then unserialized (i.e., converted back into an associative array of associative arrays). Check the defintion of the PHP function PHP: unserialize - Manual, it will help you.

If you have more questions I invite you to register to the official ProcessMaker forum, ProcessMaker.com • Index page, a lot of people will be willing to answer your questions.

Regards,

Re: How to connect with a ProcessMaker Database

Mon, 24 Feb 2014 22:26:17 GMT

Hi Liliana.

Thanks a lot for your answer, was sol helpful, we chevk your example and we applied and Works so Good.

Thanks for your great help.