timeoverflow icon indicating copy to clipboard operation
timeoverflow copied to clipboard

Downloadable organization data

Open sseerrggii opened this issue 3 years ago • 9 comments

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

  • [x] Add the missing reports, like Transfers (👉🏼 #599)
  • [ ] Add more and missing data in CSVs
  • [x] 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)

sseerrggii avatar Mar 09 '21 09:03 sseerrggii

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

markets avatar Mar 12 '21 21:03 markets

I think @franpb14 wants to take this :)

sseerrggii avatar Apr 08 '21 14:04 sseerrggii

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

franpb14 avatar Apr 10 '21 18:04 franpb14

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 https://github.com/coopdevs/timeoverflow/issues/596#issuecomment-797756760, basically add the Download all option.

markets avatar Apr 10 '21 18:04 markets

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.

franpb14 avatar Apr 16 '21 12:04 franpb14

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

markets avatar Apr 17 '21 17:04 markets

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.

franpb14 avatar Apr 20 '21 19:04 franpb14

Ok @franpb14! this is probably the 2 bullet point in the checklist here https://github.com/coopdevs/timeoverflow/issues/596#issuecomment-797756760, right?

markets avatar Apr 20 '21 20:04 markets

Yes, I think so @markets

franpb14 avatar Apr 20 '21 20:04 franpb14