db[table_name][field].retrieve_file_properties(file_name)['path'] I think 'path' will give you relative path...
You can remove ['path'] and see what other properties you can access that could sweet your needs. Good luck Richard On Sat, Jan 14, 2017 at 5:28 AM, Joe <degroupme...@gmail.com> wrote: > 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 <degrou...@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+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.
