Export logging of downloaded files

Phoca Download - download manager
robytotem
Phoca Member
Phoca Member
Posts: 10
Joined: 02 Nov 2022, 15:48

Export logging of downloaded files

Post by robytotem »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47887
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Export logging of downloaded files

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
robytotem
Phoca Member
Phoca Member
Posts: 10
Joined: 02 Nov 2022, 15:48

Re: Export logging of downloaded files

Post by robytotem »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47887
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Export logging of downloaded files

Post by Jan »

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
If you find Phoca extensions useful, please support the project
robytotem
Phoca Member
Phoca Member
Posts: 10
Joined: 02 Nov 2022, 15:48

Re: Export logging of downloaded files

Post by robytotem »

Thank you
Post Reply