Re: [xwiki-users] Stats module configuration
On Apr 30, 2009, at 4:14 AM, Dilipkumar Jadhav wrote: Hello folks, I am sorry to revive an old question I had asked in this forum but I wanted to share this with everyone. My statistics were not working on XWiki 1.7.2 originally. Finally, I figured this out. The database was MySql ver 4.x.x. I got this legacy database to work on since XWiki was on testing mode for my organization back then. I really did not have any option in the choice of the MySql version at that point of time. I had almost given up on getting the stats to work. But in the process of setting up a test XWiki I installed MySql 5.4. And the stats module worked !!! Guess, I missed something in the XWiki install guides or maybe the version compatibility (for database app servers) is not mentioned in the install guides. It is, see the database section at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation and click on MySQL. Thanks for posting back! -Vincent My most sincere thanks to Sergiu Thomas who took the time to answer my questions when this thread was active. Thank you everyone... On Mon, Mar 9, 2009 at 4:56 AM, Dilipkumar Jadhav jadhav.dilipku...@gmail.com wrote: Dear all, Thank you so much for your prompt response. I've tried to check all the things you have suggested. This is where i stand now: 1. Debug each line of the stats panel I printed out the values at the end of each #set line in the most edited pages panel. This is what i got as a result: com.xpn.xwiki.criteria.impl.sc...@19fd285 com.xpn.xwiki.criteria.impl.per...@11ff313 com.xpn.xwiki.criteria.impl.ra...@4348c6 [] The final [] in the fourth line above is the value for $stats 2. The Joda time plugin might be disabled I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in my xwiki.cfg properties Also, joda-time-1.4.jar is available in WEB_INF lib folder 3. Maybe you have a statistics field set to 0 in XWiki.XWikiPreferences (edit in object mode to check) I went to the XWiki.XwikiPreferences page and checked it in the object mode. Unfortunately, i do not see any statistics field in there. Could you please provide me with some exact example that i should look for in this page. I see info about panels skins et al. But nothing about the statistics field. 4. I read the line in the user guide that says - When statistics are globally enabled, storage can be enabled/disabled by wiki using the XWikiPreference property statistics Is this the same statistics field that we are talking about in point 3 above...If so, i really need some more clarity on looking up XWikipreferences in the object mode. 5. I have disabled the module and enabled it again. But there is still no data being displayed on the panels. All it says is - No statistics recorded Please help...thank you friends. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
Hello folks, I am sorry to revive an old question I had asked in this forum but I wanted to share this with everyone. My statistics were not working on XWiki 1.7.2 originally. Finally, I figured this out. The database was MySql ver 4.x.x. I got this legacy database to work on since XWiki was on testing mode for my organization back then. I really did not have any option in the choice of the MySql version at that point of time. I had almost given up on getting the stats to work. But in the process of setting up a test XWiki I installed MySql 5.4. And the stats module worked !!! Guess, I missed something in the XWiki install guides or maybe the version compatibility (for database app servers) is not mentioned in the install guides. My most sincere thanks to Sergiu Thomas who took the time to answer my questions when this thread was active. Thank you everyone... On Mon, Mar 9, 2009 at 4:56 AM, Dilipkumar Jadhav jadhav.dilipku...@gmail.com wrote: Dear all, Thank you so much for your prompt response. I've tried to check all the things you have suggested. This is where i stand now: 1. Debug each line of the stats panel I printed out the values at the end of each #set line in the most edited pages panel. This is what i got as a result: com.xpn.xwiki.criteria.impl.sc...@19fd285 com.xpn.xwiki.criteria.impl.per...@11ff313 com.xpn.xwiki.criteria.impl.ra...@4348c6 [] The final [] in the fourth line above is the value for $stats 2. The Joda time plugin might be disabled I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in my xwiki.cfg properties Also, joda-time-1.4.jar is available in WEB_INF lib folder 3. Maybe you have a statistics field set to 0 in XWiki.XWikiPreferences (edit in object mode to check) I went to the XWiki.XwikiPreferences page and checked it in the object mode. Unfortunately, i do not see any statistics field in there. Could you please provide me with some exact example that i should look for in this page. I see info about panels skins et al. But nothing about the statistics field. 4. I read the line in the user guide that says - When statistics are globally enabled, storage can be enabled/disabled by wiki using the XWikiPreference property statistics Is this the same statistics field that we are talking about in point 3 above...If so, i really need some more clarity on looking up XWikipreferences in the object mode. 5. I have disabled the module and enabled it again. But there is still no data being displayed on the panels. All it says is - No statistics recorded Please help...thank you friends. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
In the ActivityData page i put this code and now i'm able to have statistics. I know it's temporary (poor database performances), but i hope it helps people having the same problem (sorry for the code quality, i'm sure it can be improved) : #set($pattern='.MM.dd') #set($step=8640) #set($scope=$xwiki.criteriaService.scopeFactory.ALL_PAGES) #set($dtf = $xwiki.jodatime.getDateTimeFormatterForPattern($pattern)) #set($interval=$xwiki.criteriaService.rangeFactory.createAllRange()) 1 Current week activity #set($currentPeriod=$xwiki.criteriaService.periodFactory.currentWeek) #set($periodStart=$xwiki.jodatime.getDateTime($currentPeriod.start)) #set($periodEnd=$xwiki.jodatime.getDateTime($currentPeriod.end)) #set($datejour=$periodStart.getMillis()) #set($nbElt = ($periodEnd.getMillis() - $periodStart.getMillis()) / $step) {table} Date | Views | Edit #foreach($i in [1..7]) #set($datefinjour=$datejour + $step) #set($period=$xwiki.criteriaService.periodFactory.createPeriod($datejour,$datefinjour)) #set($stats=$xwiki.statsService.getDocumentStatistics(view,$scope,$period,$interval)) #set($totalViews=0) #if($stats.size() 0) #foreach($item in $stats) #set($docStats = $xwiki.getDocument($item.name)) #if ($docStats) #set($totalViews=$totalViews+$item.pageViews) #end #end #end #set($stats=$xwiki.statsService.getDocumentStatistics(save,$scope,$period,$interval)) #set($totalSave=0) #if($stats.size() 0) #foreach($item in $stats) #set($docStats = $xwiki.getDocument($item.name)) #if ($docStats) #set($totalSave=$totalSave+$item.pageViews) #end #end #end $dtf.print($datejour) | $totalViews | $totalSave #set($datejour=$datefinjour) #end {table} -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Dilipkumar Jadhav Envoyé : mardi 10 mars 2009 12:43 À : users@xwiki.org Objet : Re: [xwiki-users] Stats module configuration Hello friends, I've tried placing the new xwiki-plugin-jodatime-1.3.jar. Restarted tomcat and still no statistics. The result set like another friend said is still : NULL There is definitely valid data in the stats tables (when i query it through Sqlyog). Thank you ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
Dilipkumar, Can you check the page ActivityData in the space Stats please ? I have a red message table : null for each stats and Iwould like to know if you have the same than me. I also have data in the table and when i display info before the weekly stats table i have this : $scope = com.xpn.xwiki.criteria.impl.sc...@1faf07e $period = com.xpn.xwiki.criteria.impl.per...@1a146f7 $step = com.xpn.xwiki.criteria.impl.durat...@15e53cd $myviews = {2009-03-10T00:00:00.000+01:00=0, 2009-03-11T00:00:00.000+01:00=0, 2009-03-13T00:00:00.000+01:00=0, 2009-03-15T00:00:00.000+01:00=0, 2009-03-12T00:00:00.000+01:00=0, 2009-03-09T00:00:00.000+01:00=0, 2009-03-14T00:00:00.000+01:00=0} $myviews.size = 7 $myedits = {2009-03-10T00:00:00.000+01:00=0, 2009-03-11T00:00:00.000+01:00=0, 2009-03-13T00:00:00.000+01:00=0, 2009-03-15T00:00:00.000+01:00=0, 2009-03-12T00:00:00.000+01:00=0, 2009-03-09T00:00:00.000+01:00=0, 2009-03-14T00:00:00.000+01:00=0} $dtf = org.joda.time.format.datetimeformat...@1a36dc7 table: null Thanks -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Dilipkumar Jadhav Envoyé : mardi 10 mars 2009 12:43 À : users@xwiki.org Objet : Re: [xwiki-users] Stats module configuration Hello friends, I've tried placing the new xwiki-plugin-jodatime-1.3.jar. Restarted tomcat and still no statistics. The result set like another friend said is still : NULL There is definitely valid data in the stats tables (when i query it through Sqlyog). Thank you ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
Hello friends, I've tried placing the new xwiki-plugin-jodatime-1.3.jar. Restarted tomcat and still no statistics. The result set like another friend said is still : NULL There is definitely valid data in the stats tables (when i query it through Sqlyog). Thank you ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
Dilipkumar Jadhav wrote: Hello friends, I've tried placing the new xwiki-plugin-jodatime-1.3.jar. Restarted tomcat and still no statistics. The result set like another friend said is still : NULL There is definitely valid data in the stats tables (when i query it through Sqlyog). Thank you What database are you using? -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
Hi, On Sat, Mar 7, 2009 at 16:59, Dilipkumar Jadhav jadhav.dilipku...@gmail.com wrote: Hello friends, My wiki has grown considerably now and we are at a phase where we would like to measure and analyze contributors and their contributions. I am using XWiki 1.7.2. I followed the instructions at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and set the following in the xwiki.cfg file. xwiki.stats=1 xwiki.stats.default=1 Now, I can see that the stats are being recorded in the database (mysql) tables. However, when i visit the stats home in my wiki all i see is No statistics have been recorded for all statistics panels. All the graphs show no activity. Also, i have enabled the stats module about 2 weeks back during which course there has been a lot of activity on the wiki. Also, the stats seems to work on the XWiki installed on my home pc. However, at my office instance of XWiki the stats module does not work. Could it have something to do with the proxy server that we have setup in office. No statistics have been recorded is printed when statistics are disabled so I doubt it has anything to do with proxy (it does not really check if there is something recorded or not, even if nothing was in the database it should generate en empty graph). Maybe you have a statistics field set to 0 in XWiki.XWikiPreferences (edit in object mode to check) Did i miss out on some crucial steps... Any help will be greatly appreciated. Thank you... ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Thomas Mortagne ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
Thomas Mortagne wrote: Hi, On Sat, Mar 7, 2009 at 16:59, Dilipkumar Jadhav jadhav.dilipku...@gmail.com wrote: Hello friends, My wiki has grown considerably now and we are at a phase where we would like to measure and analyze contributors and their contributions. I am using XWiki 1.7.2. I followed the instructions at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and set the following in the xwiki.cfg file. xwiki.stats=1 xwiki.stats.default=1 Now, I can see that the stats are being recorded in the database (mysql) tables. However, when i visit the stats home in my wiki all i see is No statistics have been recorded for all statistics panels. All the graphs show no activity. Also, i have enabled the stats module about 2 weeks back during which course there has been a lot of activity on the wiki. Also, the stats seems to work on the XWiki installed on my home pc. However, at my office instance of XWiki the stats module does not work. Could it have something to do with the proxy server that we have setup in office. No statistics have been recorded is printed when statistics are disabled so I doubt it has anything to do with proxy (it does not really check if there is something recorded or not, even if nothing was in the database it should generate en empty graph). Maybe you have a statistics field set to 0 in XWiki.XWikiPreferences (edit in object mode to check) No Thomas, the message when statistics are disabled is The statistics module is disabled by default for improved performance. For more details, see ... This message means that nothing was retrieved from the database. There might be a problem with another component, the best thing to do is to debug each statement in one of the panels. Take for example the Stats.CurrentMonthActivity document, edit the panel, and after each #set line print the newly set variable, and see which one is wrong. A possible problem is that the jodatime plugin is disabled. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Stats module configuration
what about logging out and then back in. Or even shift-reloading a page you've previously visited. Sometimes there's caching issues (also sometimes there's caching in xwiki too... how do changes like this propagate through the cache, or is there a way of forcing the xwiki cache to clear?) Niels http://nielsmayer.com ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Stats module configuration
Hello friends, My wiki has grown considerably now and we are at a phase where we would like to measure and analyze contributors and their contributions. I am using XWiki 1.7.2. I followed the instructions at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and set the following in the xwiki.cfg file. xwiki.stats=1 xwiki.stats.default=1 Now, I can see that the stats are being recorded in the database (mysql) tables. However, when i visit the stats home in my wiki all i see is No statistics have been recorded for all statistics panels. All the graphs show no activity. Also, i have enabled the stats module about 2 weeks back during which course there has been a lot of activity on the wiki. Also, the stats seems to work on the XWiki installed on my home pc. However, at my office instance of XWiki the stats module does not work. Could it have something to do with the proxy server that we have setup in office. Did i miss out on some crucial steps... Any help will be greatly appreciated. Thank you... ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users