Here is a fix to another problem in ZuckerReports. The symptom is when a non-admin user is trying to run an on-demand report under ZuckerReports, the page just redirect back to the list of available templates without showing any result. But admin users can run them just fine. It turns out the problem is a conflict between ZuckerReports and CE Teams. CE Teams is another nice module that enable simple team-based management of users. You can read more about it on their page.
I haven’t have time to dig into the codes yet, so the fix is rather primitive and simple, but it works. The problem is that both ZuckerReports and CE Teams have a field called “team_id” in the database but they have totally different meanings. So when CE Teams read the info from “team_id” in Zucker’s database table, it acts weird. Admins are not affected since they are above CE Teams’ rules.
The fix:
- Make sure in CE Teams you keep the team “Everyone” and add all the users to that group.
- Fire up your favorite MySQL management software, most likely phpMyAdmin, and go to your SugarCRM database
- Go to table “team” and record the id for team “Everyone“. (If you didn’t delete the default team, the id is “1″)
- Go to table “zucker_listingtemplates” and update all their id to team “Everyone’s” id.
- In order you don’t have to modify future new templates by hand, change the default value of “team_id” to match “Everyone’s” id.
- Repeat step 4 and 5 for the tables “zucker_querytemplates“, “zucker_reporttemplates“, and “zucker_wordtemplates“.
Now everyone in team “Everyone” should be able to run all the reports.
Subscribe to the RSS feed to receive more useful tips.
Filed under: How-To, Software, Web Design
4 Responses to “Fix ZuckerReports Non-Admin Cannot Run Reports”
October 31st, 2009 at 2:24 AM
The solution worked perfectly. You know we were struggling almost for a week to find out the solution. Suddenly we hit upon this URL which solved the major issue in my roll out. Thanks a tonne!!!
Rgds
Ajay
October 31st, 2009 at 12:12 PM
Yay glas this works for you too!
December 10th, 2009 at 7:47 AM
hi,
thanks you for your solution and i have a question :
so i like to create a boutton in case module to create a report with evry case?.
thanks
December 10th, 2009 at 8:47 AM
bilel, I am not quite sure how to do it, sorry. I would guess you will need to modify the template for “Case”. For each case entry you will have a
added and the form will be submitted to ZuckerReport.