coopdevs/timeoverflow

Downloadable organization data

sseerrggii opened this issue · 9 comments

sseerrggii commented

Some organizations want to analyze their data, in past we proposed to extend reports #259

Also in #594 we add some fields to these reports

These reports are commonly used only for printing in order to facilitate participation in TimeBanks for people that have difficulties using the TimeOverflow application (old people, for example)

So maybe in the future we could keep this reports simple (printable version) and add another option for admins like "download organization Data" .zip with all CSV of data of your Organization: Users/Posts/Categories/Tags/Transactions... with all fields in use avoiding those that are only used internally in the app and do not provide data for analysis (such as password, tokens, ...)

PLAN

  • Add the missing reports, like Transfers (👉🏼 #599)
  • Add more and missing data in CSVs
  • Add a new option Download all under the hood we only need to call each CSV Report class and create a ZIP with all generated files (👉🏼 #620)
markets commented

That would be very useful, I agree @sseerrggii. Maybe we can just do it this way (to reuse more parts):

  • Add the missing reports, like Transfers
  • Add missing attributes in CSVs
  • Add a new option Download all, under the hood we only need to call each CSV Report class and create a ZIP with all generated files (using this gem https://github.com/rubyzip/rubyzip)

Something like this:

Captura de pantalla 2021-03-13 a las 1 24 43

  • 👍1
sseerrggii commented

I think @franpb14 wants to take this :)

  • 👍2
franpb14 commented

Yes, I would like to take this issue.
Does the current status of the issue coincide with the pull request #599?

markets commented

Hi @franpb14 👋🏼

In #599 I added the missing Transfer report and in #594 I added some missing relevant attributes. So, to finalize a 1st version of this project we need to implement the latest point in #596 (comment), basically add the Download all option.

  • 👍2
franpb14 commented

Hi, in this commit you can find the feature working, but I have a doubt regarding the require 'zip': I think it shouldn't appear in the file 'reports_controller.rb' but I don't know where else to put it.

markets commented

hi @franpb14 👋🏼 since it's the place from where it is invoked, is fine to have it there.

franpb14 commented

I didn't close this Issue with a magic comment because I discussed with @sseerrggii the possibility of an additional phase (more data in csvs from the Zip). This phase would start when I implement another functionality that I have defined that would bring more value.

markets commented

Ok @franpb14! this is probably the 2 bullet point in the checklist here #596 (comment), right?

  • 👍1
franpb14 commented

Yes, I think so @markets

  • 👍2