How to bulk download (csv) photos/files activity & comments?

Nextcloud version: 24.0.1
Operating system and version: Ubuntu 18.04.4
Apache or nginx version: Apache 2.4.29
PHP version: 7.4.15

The issue you are facing:

Usage Scenario:

  • Myself and friends are part of a maker group (we build stuff)
  • We are currently using NextCloud as our data repo & collaboration space
  • We upload photos of project components to Next Cloud
  • Group members can then add comments e.g. dimensions, materials, colors, etc.

Goal: Export a csv file containing:

  • File Path & Name (mostly image files, should it be relevant)
  • File associated Activity (optional)
  • File Associated Comments (critical to workflow)

Previous Research

  • Searched this forum, GitHub, and apps.
  • found activity app - not a good fit as our implementation requires on demand export

Possible Workaround:
SQL Query of mySQL tables: oc_filecache, oc_comments, etc.