Talk:Medlemsdatabase

From Programvareverkstedet

Suggestion for english translation (not proofread):

Member Database

PVVs new member database, MDB OH (it's called MDB OH because the previous one was called MDB NG), is currently being adopted. To see what the database contains about you, you can run the program mdboh on login.pvv.ntnu.no. It is also possible to say kontingent to get a shorter message that just says whent it's time to pay the membership fee again.

The specification for the databes was adopted on the half-year meeting the fall of 2010. At the same time a set of fee rules were adopted.

To administer the database (adding users, collecting payment information from accountig, looking at iformation ordinary users don't have access to, etc.), begin with the following:

$ ssh postgres.pvv.ntnu.no
$ su -
# su pvv
$mdboh hjelp

To register a member payment:

$ ssh postgres.pvv.ntnu.no
$ su -
# su pvv
$ mdboh registrer_betalinger yyyy.gnucash
username yyyy-mm-dd amount

"yyyy.gnucash" is the filename of the accounts. This should be on the form "20yy.gucash" in the forseable future, but it is not guaranteed. Potentially check [boards changes] to check the filename of the current years accounts. "username" must be replaced with the relevant username, "yyyy-mm-dd" with the date of the payment on the give form, and "amount" by a number that denotes the amount in Korwegian kroner. (e.g. "50" for a ordinary membership fee.) You can add several payments at oce by writig several lines with individual payments to stdin.

It may also be usefull to look at a user to check that one don't enter a paymet twice:

$ ssh postgres.pvv.ntnu.no
$ su -
# su pvv
$ mdboh vis username