I think you can have it with : response.session_id So you will have to add a column to the model and set default=response.session_id...
Richard On Tue, Jan 10, 2017 at 7:23 PM, Joe <degroupme...@gmail.com> wrote: > 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 <degrou...@gmail.com> 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-stat >>>> istics-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 <degrou...@gmail.com> 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 web2py+un...@googlegroups.com. >>>>> 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 web2py+un...@googlegroups.com. >>> 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 web2py+unsubscr...@googlegroups.com. > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
