White Screen on DHTMLX Scheduler & Bonita Studio integration

Suite and Optimus Suite 5
#1

Hi, I’m working on Bonita Studio-community edition Version 5.9.1.and DHTMLX Scheduler Integration with DHTMLX Connector (php)
I tried to integrate the component DHTMLX Scheduler in Bonita Studio without success: white screen appears and only the scrool bar.
See example of successfully integration in joomla site in case (a) integration with the specific extension for joomla component and
in case (b) of stark code HTML + Javascript + PhpCode → MySQL Database, HTML + Javascript code for client-side and server-side PHP code).
Here is the link:
luisamadonnatwo.altervista.org/j … 2/homepage login with mrossi, mrossi1, then “Consultazione/Browse” menù → item “Agenda”

Similarly, I wanted to achieve integration for Bonita using a user task and a html widget but I got, after several attempts,always the same result as indicated above.

Where can you go wrong? I kindly help.

Note: In Jooma and in bonita Envirounment I have integrated other two components DHTMLX Calendar and DHTMLX Grid successfully, using javascript code and XML files for the data
(such as Grid and Calendar in joomla site: luisamadonnatwo.altervista.org/j … 2/homepage,
login with mrossi, mrossi1, then “Consultazione/Browse” menù → item “Books/Libri”).

The Scheduler’s problem does not seem to depend on the data integration, seems to depend on the graphical representation of the component before
it is executed the php code that retrieves data from the database (using DHTMLX Connector).

In the meantime, I enclose (in Dropbox shared directory dropbox.com/home/LuisaDropBox/For_Bonita):

1)the software code client side and server side + sql scripts for DB, used for Joomla integration that I would like to integrate in bonita
and that’s already working in Joomla site (Example_Scheduler_Connector21032013.txt), my DB connection in Php code is
$res=mysql_connect(“localhost”,“root”,“”);
mysql_select_db(“install”);
2)Joomla integration’s images on localhost in case (a) and in case (b) (SchedulerOK_Joomla_Component.jpg and SchedulerOK_Joomla_Code.jpg);
3)All useful data of Bonita’s project to repeat the test (Scheduler–1.0.bar)

I already posted a similar message on Bonita soft forum bonitasoft.org/forum/viewtop … 439#p45439

I thank and salute Sincerely, Luisa Madonna

#2

Just checked the above page and scheduler works there correctly ?
Do you have solved the problem ? or problem occurs in some specific browser only ?

Page with scheduler has few js error messages (only in debug console), but none of them is related to the scheduler.

#3

I made a few more test and now works part of the display, I found the solution and I try to explain, if I can …!! Still does not work the server side that takes the data from the DB and do not work the icons to go back and forth in the calendar Scheduler, I go back and forth knowing these icons are placed next to the label “today” in the upper left.

DHTMLX scheduler works in joomla site, I use both Mozilla Firefox and Google Chrome. The website link I sent you an example of the case that it works properly. It did not work, however, if the integration was done in Bonita Studio. When you deploy the process, the process and therefore the form of the user task is performed in Bonita User Experience by default in the default web browser (configured in Preferences of Bonita Studio) . In my case, Mozilla Firefox or Google Chrome web Browsers that are used.
I give you an example, if you connect to this address now you can see the process just deployed from my Bonita Studio on my PC (I have a dynamic IP, then change from time to time …). Log in (admin, bmp) if you get the login screen, you will see the scheduler as it appears to me. Try Mozilla Firefox or Google Chrome 19 (Version 25.0.1364.172 m).
The URL is :
95.245.207.142:9090/Scheduler–1 … duler–1.0

Now I noticed that the display part works because I made a change, I changed the name of HTML files that had embedded as a resource in Bonita. But it still does not work the server-side that takes the data from the DB through the connector.php.
I export the new project Bonita (Vers.2.0) and put it on the shared directory on dropbox link.

#4

New Dynamic IP for my PC (to make the test on Bonita process deployed yesterday, with Scheduler): 87.13.199.130 with probmlemi still present and reported last reply

#5

87.13.199.130:9090/Scheduler–2. … duler–2.0 (url completa) , then login with (admin, bpm)

#6

87.13.199.130:9090/Scheduler–3.0/application/BonitaApplication.html?locale=it#form=Scheduler–3.0–Scheduler$entry&task=Scheduler–3.0–1--Scheduler–it1–mainActivityInstance–noLoop&theme=Scheduler–3.0

#7

http://87.16.35.72:9090/Scheduler–3.0/application/login.jsp?redirectUrl=%2FScheduler–3.0%2Fapplication%2FBonitaApplication.html%23form%3DScheduler–3.0–Scheduler%24entry%26task%3DScheduler–3.0–1--Scheduler–it1–mainActivityInstance–noLoop%26theme%3DScheduler–3.0

#8

Was able to login and look at scheduler

a) you have problem with scheduler images, by default it locates them in imgs/ subfolder, related to css file, but it seems there is no images in your case.
Be sure that you have file located as

[fle] dhtmlxscheduler.css [folder] imgs [file] all image files

b) Similar with saving connector, it uses parth from dataprocessor init and attempts to submit data for connector_bonita2.php which doesn’t exists. Be sure that there is such file and it is in correct location ( move file , or change path in scheduler.load(path) , new Dataprocessor(path) commands )

#9

I’m doing tests moving files and redefinition of paths but still nothing … I’ll let you know as soon as possibile.In Bonita, code divided into 3 parts, one part is the html file, one part is the javascript code and the last part is a php file. Each part is placed in an area. Each part requires the correct paths … The part that is not very clear to me is where you expect it to be placed in the server side php code in joomla … I have not had any problems, the paths are well interpreted and code php is placed on a directory under the root of the website, accessed and executed … I get the impression that, in Bonita, the php code is not achieved gradually eseguito.Non there are errors in the log file of Bonita. You have done an integration test environment in Bonita? I’ll send you the pictures of the configuration that I’m trying in Bonita (project Vers.5.0). I tried to put everything under root to simplify paths, under css I put the css file and copied under the root directory for images, as well as supplied by dhtmlsuite (imgs_glossy).Thank’s you, by , luisa

vers5_3.jpg1259×754 112 KB


vers5_2.jpg954×443 47.6 KB


vers5_1.jpg960×434 50.4 KB

#10

at the moment:

  • ok for a), now it’s possible to see icons (J used no glossy version css file and path in html file), see attached image;
  • still does not work the point b)… :cry:

I also updated the post on bonita forum:

bonitasoft.org/forum/viewtopic.php?id=10620.
Thank’s for your support

ok_icons.jpg1238×640 55.5 KB

#11

For point a) Data from the database still are not loaded in the scheduler.
I enabled the debug mode of dataProcessor that returns, when I try to insert a new event in the scheduler:

DataProcessor
Current state
ID:1365600204155 Status: inserted, valid
Current mode: cell
Log:
row 1365600204155 marked [inserted,valid]
Initiating data sending for 1365600204155
Sending in one-by-one mode, current ID = 1365600204155
Server url: connector.php parameters
null
Server response received details

<?php header('content-type text/xml'); require_once("dhtmlxSuite/dhtmlxScheduler/codebase/connector/scheduler_connector.php"); sleep(100); $res=mysql_connect("localhost","root",""); mysql_select_db("install"); sleep(100); $conn = new SchedulerConnector($res); sleep(100); $conn->enable_log("tempbonita.log"); sleep(100); $conn->render_table("vcdxr_events_rec","event_id,start_date,end_date,text"); sleep(100); echo date('h:i:s') . "\n"; ?>

Not an XML, probably incorrect content type specified ( must be text/xml ), or some text output was started before XML data
***
What can I do?
See you attached images : The first image when I click on “Server url: connector.php parameters” and the second when I click on “Server response received details”

DebugMode2.jpg1204×650 81.6 KB


DebugMode1.jpg1194×607 73.3 KB

#12

[code]Server response received details

<?php header('content-type text/xml'); [/code] This means that server side code doesn't really process php file, but just returns its content. To save changes back to DB you need to run php file against PHP capable server ( in your case, PHP file just server as static file )
#13

I’m sorry, I’m no expert. If I gave you all three pieces of code that must run under Bonita, may you try to tell me exactly where I can intervene in the code? thank you very much

#14

I may have found the information about yourself as recommended. Bonita Soft Studio is based on Jetty Web server … The link is : docs.codehaus.org/display/JETTY/Jetty+and+PHP
Do you mean this?
Thank you very much

#15

Sorry but I hardly can help here :frowning:
I have not any experience with Bonita Studia, and don’t know how this integration can be achieved.
Scheduler can work with in any html environment, but it seems that in your case server side do not process php file as expected, which causes above issue.

#16

thank you very much anyway for your support, now I have more clear the problem :wink: , I will try to investigate in the Bonita/jetty’s environment . By, Luisa Madonna