Members list

karolds commented

2026-02-16 18:29:30 +01:00

Owner

We can benefit from having a members list containing aktive members. It should have the following features:

Get personalia info (name, username/email, etc) From ntnus registry.
Have info if they are a member or life time member
Have info on when the members fee was last paid.
Send a notification if it is more than one year since the members fee have been paid, (propably nice if it checks all members once a year/semester and not continually.)
Student status (Student, student outside ntnu or not a student)

We can benefit from having a members list containing aktive members. It should have the following features: - Get personalia info (name, username/email, etc) From ntnus registry. - Have info if they are a member or life time member - Have info on when the members fee was last paid. - Send a notification if it is more than one year since the members fee have been paid, (propably nice if it checks all members once a year/semester and not continually.) - Student status (Student, student outside ntnu or not a student)

karolds added this to the Authentication Next Gen milestone 2026-02-16 18:29:30 +01:00

karolds added the question good first issue security salt new stuff services software exploration labels 2026-02-16 18:29:30 +01:00

karolds added this to the Kanban project 2026-02-16 18:29:30 +01:00

karolds moved this to High priority in Kanban on 2026-02-16 18:30:09 +01:00

felixalb commented

2026-02-16 23:13:14 +01:00

Owner

There have been

take a look at the past attempts to see if they can be reused/revived, or if anything can be learned from them.

I have not found any of the versions used before mdboh (it is apparently a successor to mdbng, which implies a yet older mdb), but mdboh (both the cli tool and the database) was stored on knakelibrak, and probably exists in principal:/backupz/knakelibrak somewhere.

From my POV, the most important and most difficult part is getting a reliable and up-to-date stream of payments, that probably requires someone (kasserer, probably) to register all paid membership fees in a structured and predictable way in their bookkeeping software in a format that can be imported into the database (username, years paid, payment date, and possibly paid amount (e.g. for old people auto-paying 42NOK/y)). Once this is done, the remaining parts are mostly a user interface and some archaeology into data that is older than the current books, before the endless task of getting people to use the system.

Other comments:

"Get personalia info from ntnus registry" is probably not very useful or predictable, and all of this information already exists in PVVs own passwd file.

What should we do when people do not pay their membership fees? Actually start closing accounts, or just appreciate our paying members and enjoy our new statistics?

There have been - [some](https://wiki.pvv.ntnu.no/wiki/Medlemsdatabase) - [previous](https://git.pvv.ntnu.no/Drift/issues/issues/27) - [attempts](https://git.pvv.ntnu.no/Projects/pvvmdb/src/branch/main) take a look at the past attempts to see if they can be reused/revived, or if anything can be learned from them. I have not found any of the versions used before mdboh (it is apparently a successor to mdbng, which implies a yet older mdb), but mdboh (both the cli tool and the database) was stored on knakelibrak, and probably exists in principal:/backupz/knakelibrak somewhere. From my POV, the most important _and_ most difficult part is getting a reliable and up-to-date stream of payments, that probably requires someone (kasserer, probably) to register all paid membership fees in a structured and predictable way in their bookkeeping software in a format that can be imported into the database (username, years paid, payment date, and possibly paid amount (e.g. for old people auto-paying 42NOK/y)). Once this is done, the remaining parts are mostly a user interface and some archaeology into data that is older than the current books, before the endless task of getting people to use the system. --- Other comments: "Get personalia info from ntnus registry" is probably not very useful or predictable, and all of this information already exists in PVVs own passwd file. What should we do when people do not pay their membership fees? _Actually_ start closing accounts, or just appreciate our paying members and enjoy our new statistics?