Phoca Forum

Hi everyone, I've activated logging to understand which users download the files I've posted on the site. I needed help figuring out how to export (perhaps in csv or other) the logging of users who have downloaded a particular file.
Thank you

Hi, there is no such option in Phoca Download to export statistics

Jan

Jan wrote: ↑30 Mar 2023, 15:20 Hi, there is no such option in Phoca Download to export statistics :idea:

Jan

What a shame. It would be an interesting feature if you decide to implement it in the future.
I ask you for information: do you happen to know which table is in the database from which I can query and export this data?

Thank you

Hi, it depends on which data you need exactly, if you need only hits of file then this is stored in main phoca download table. If this should be combination of users/downloads then the table:

jos_phocadownload_user_stat

Jan

Thank you