search

luethi / Discharge_Optical_Measurement

1 stars 0 forks source link

Automated reporting for (sub-)organisations #43

Open timoherberz opened 7 years ago

timoherberz commented 7 years ago

Dear all, this idea comes from staff of RBWO. They find it unhandy to click on each and every site everytime they want to check if people are sending data. The idea arose of an automated weekly report for all the sites in the organisation. This report would include one excel sheet with all the data of the week.

Robert and Tobi found that this might be interesting for all the users of discharge.ch. They suggested an option for every organisation to have a weekly or monthly report sent to certain email-addresses.

Kind regards, Timo

salpeha commented 7 years ago

Dear @timoherberz I think that is a very good idea. We already have talked about it, and also has been reported here #27. I think this should be included into the payment plans.

timoherberz commented 7 years ago

Hi Salvador, sorry I didn't know that this had been already mentioned! This could be an example for such a regular report:

iMoMo Summary 20.-26.03.17.xlsx

timoherberz commented 7 years ago

Here is a python script that does the summarizing job for me. Please note, that it's the first script I ever wrote.

all_sites.csv is the output file. crowd_sender_info.csv needs to be in the working folder.

python script for reporting.zip