Aqui dejo el post que me ha salvado la vida ;D
Hi all,
I struggled a bit getting sugar, zucker reports and iReport to work correctly, so after I eventually got it working I thought I’d post on here what I done. Hopefully this may help other people out there.
Ok, lets get started….
Please note this is for the windows installation. Something that I found useful is that if you pre-install mysql then you will be able to use all the administration and monitoring software for your sugar installation and you wont have to configure a thing.
Please ensure that your system has the latest java installed (I used version 6.0.70.6).
Download the file ’sugarcrm-CE-5.1.0a-windows-installer.exe’ and run the installation.
Once the installation is complete locate the php.ini file, e.g. sugarcrm-5.1.0a/php
Edit this file and:
Change post_max_size to 40M
Change upload_tmp_dir to a directory folder without spaces, e.g. C:\tmp
Change upload_max_filesize to 40M
Restart Sugar.
Download ZuckerReports (I used version 1.10).
Login to SugarCrm as administrator, head to the Admin page and select Module Loader.
Upload a new module and select the Zucker zip file. Once uploaded then install the package.
Hopefully at this point all is well.
Navigate to the folder ‘htdocs\sugarcrm\modules\ZuckerReports’
Edit the file config.php and:
Find the line that is commented out for Windows Environment and replace with the following line -
“java_cmdline” => “C:\ZuckerJava\javaw %ARGS% 2>&1″
Note: The javaw.exe has been copied to a folder that does not contain any spaces as this may cause problems.
If the installation of SugarCRM used a different SQL port, e.g. it was not the default of 3306 then the following needs to be changed.
Navigate to: ‘htdocs\sugarcrm\modules\ZuckerReportTemplate’
Change the file ReportTemplate.php, scan for 3306 and change to the appropriate port number.
The Zucker images may also be in the wrong place, check if they appear when in the ZuckerReports module whilst you are in Sugar. If no images appear then copy the files within ‘htdocs\sugarcrm\custom\themes\Awesome80s\images’ put them in ‘htdocs\sugarcrm\themes\default\images’.
We are getting there!!
Next up is to install iReport, if you don’t know what this is then it will allow you to create some cool reports and upload them into sugar. Download the latest version (I used version 3.1.1) from here and install.
Find the file ‘jasperreports-3.1.0.jar’ within the iReport installation folder and copy it to ‘htdocs\sugarcrm\modules\ZuckerReports\jasper’. I also removed any older version of the same jar file but I am not sure if it is required or not!
At this point restart Sugar and all should be working nicely.
You could start up iReport, add a database and point it to sugar - the driver will be mysql and the connection url will be something like ‘jdbc:mysql://localhost:3306/sugarcrm’. You will need to put in the user id of ‘root’ and the appropriate password. Once you see your database create yourself a basic report click preview to see if it works. If it does then save and login to sugar. Go to the ZuckerReports module and select ‘Report and Query Templates’. Select ‘New JasperReport Template’ and then browse to the report you just created.
Here is the moment of truth, click on Save and fingers crossed it will import ok. Then select run report and hey presto you should see your report! 
Just to keep things complete I will include how to setup the scheduler, there are articles out there on how to do this, but I will include it here so at least you don’t have to dig around!
Edit the file ‘_AddJobsHere.php’ within the folder ‘htdocs\sugarcrm\modules\Schedulers’ and add the following line to the “$job_strings”-array, you put this above option 9 which is for updateTrackerSessions:
8 => ‘ZuckerReportsScheduler’,
Further down you should see a load of functions, right near the bottom and above ‘Job 9′ to keep it in order add the following function:
function ZuckerReportsScheduler() {
require_once(”modules/ZuckerRunnableReport/RunnableReport.php”);
RunnableReport::scheduler_run_all();
return true;
}
Restart sugar and login as admin. Go to the admin page and then select ‘Scheduler’. Click on ‘Create Scheduler’ and fill in the details, the job will be ‘ZuckerReportsScheduler’. You can put in whatever you want for the interval.
Phew, the last bit is to create a batch job otherwise nothing will happen!
Create a batch file, e.g. ‘SugarScheduler.bat’ and add the following:
cd \sugarcrm-5.1.0a\htdocs\sugarcrm\SugarCE-Full-5.1.0a
C:\SUGARC~1.0A\php\php-cgi.exe -c C:\SUGARC~1.0A\php\php.ini -f cron.php
You will probably need to change the path to where your installation lives. Note: you will need to use the directory short names for the actual command otherwise it will not work!
Now add this batch file to the windows scheduler or at a command line type the following:
schtasks /create /sc minute /tn “Sugar Cron” /tr c:\SugarScheduler.bat
This will create the schedule job to run every minute….hurahh!!
I hope this has helped some people out as I’ve spent a while myself getting this working.
Good luck everyone.
Frizza
Debes tener correctamente configurado el scheduler de sugar e instalado el php5-cli (en mi caso por tener php5)
