I worked it out. It's great! Working fine! Thanks again. "BTW: what is the best way to include a unique session id for each visit in the 'usage_statistics' table?"
On Wednesday, January 11, 2017 at 2:09:24 AM UTC+8, Richard wrote: > > I guess you need to create the table... For some reason the web2py-slice > site does block in fortigate so, I am not sure of the code... I guess there > is migrate set to False or something or you set migrations to False in your > connection string. > > Richard > > On Sun, Jan 8, 2017 at 8:21 AM, Joe <[email protected] <javascript:>> > wrote: > >> Thanks for the link Richard, >> >> I just copied everything and tried it but I am getting this error: >> OperationalError: no such table: usage_statistics >> >> I think I am missing a step. >> >> Can you please advise. >> >> Thanks. >> >> Cheers, >> >> Joe >> >> >> >> >> >> On Friday, January 6, 2017 at 11:12:36 PM UTC+8, Richard wrote: >>> >>> You can look on the side of piwik : https://piwik.org/ >>> >>> If you only want to log your users activity and don't need that much of >>> analytic you can have look at this slice : >>> >>> >>> http://www.web2pyslices.com/slice/show/1618/basic-usage-statistics-log-what-your-users-do >>> >>> But it has a drawback which is that it makes an insert each time users >>> make request... Plus you don't have any analytics, graph, you have to forge >>> your own query to trend your data. >>> >>> Here there was discussion about improving this contrib by making it less >>> database intensive : >>> https://groups.google.com/d/msg/web2py/659_7_hDiks/947KRwtQDssJ >>> >>> good luck >>> >>> Richard >>> >>> >>> >>> On Fri, Jan 6, 2017 at 8:12 AM, Joe <[email protected]> wrote: >>> >>>> I am interested in using a self-hosted web analytics solutions on >>>> Pythonanywhere for my Web2py apps. >>>> I asked this question on the Pythonanywhere forum, they suggested to >>>> ask here. >>>> Can anyone suggest the best solution for this and let me know the >>>> easiest way to install it on the server? >>>> Thanks. >>>> Cheers, >>>> Joe >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
