Hello Richard, This is great! It works like a charm. Thanks for this. Awesome stuff.
Btw: is there a way to request the path to files i.e. when the visitor plays a video file from the static/images folder? The referer_path only gets the URL for the page, not the path to the files. Please let me know your thoughts. Thanks. Cheers, Joe On Thursday, January 12, 2017 at 2:18:20 AM UTC+8, Richard wrote: > > 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 <[email protected] <javascript:>> > 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 <[email protected]> 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]. >>>> 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.
