Princeton-CDH / mep-django

Shakespeare and Company Project - Python/Django web application
https://shakespeareandco.princeton.edu
Apache License 2.0
5 stars 1 forks source link

Generate CSV of a filtered list of members #741

Closed kmcelwee closed 2 years ago

kmcelwee commented 2 years ago

Request from @jkotin

Would it be possible to generate a list of accounts with reimbursements without subscriptions? (It would also be helpful to have lists of accounts with reimbursements before the first subscription, and accounts with more reimbursements than subscriptions.) I’m going through the address book and find a lot of weird things, most of which can be fixed. If the address book is to be believed, Beach was very inconsistent about recording reimbursements in the logbooks. I expect most of the reimbursements were recorded using returned library cards (the wallet ones).

please include renewals. I don’t think Beach or her clerks were consistent about differentiating renewals and subscriptions. I apologize about not being clearer about this: reimbursements without either renewal or subscription events. I hope the resulting list is shorter!... No not include supplements or book other events.

Code tracked here: https://colab.research.google.com/drive/1NbL6Mk2WF3NEuznf2CAdk3CRZbRgOhC6?usp=sharing

kmcelwee commented 2 years ago

Notebook is finished: https://colab.research.google.com/drive/1NbL6Mk2WF3NEuznf2CAdk3CRZbRgOhC6?usp=sharing CSV are available here: 741-sco.zip