On Sun, Feb 07, 2021 at 11:53:24AM +0000, Phil Thane wrote:
Hello,
Anyone know if this exists or would anyone like to create it? (Not seq command, won't do what I want, I don't think). Read on...
I'm the membership sec of GOBA (Great Ouse Boating Assoc). We've just launched a new website using WP and sundry plugins. Central to things is Paid Memberships Pro which allows new members to join or existing ones to renew online. PMP allows users to specify their own username and password. BUT, under the previous regime and going back to the dark ages (pre internet) GOBA assigned each member a membership number, and just to make life more difficult didn't just use a straightforward sequence. Each 'number' is actually alphanumeric based on initial letter of the member's surname, then the next number available in that sequence. Thus I'm T596 and there is one person after me T597 but in the S list there are over 1200 (too many Smiths).
Two things make this a nuisance. First, we imported data from the previous system into PMP and had to choose a field to be the key ID. PMP would prefer this to be an email address but many members joined long before they had email and have never updated their details to include it. The one field they all did have was a membership number, so for all previous members Username = Membership number. Secondly GOBA is full of people who don't like change, they want us to convert new members with their personalised username into the 'traditional' system.
That's do-able via the WP dashboard but a bit of a pain. Finding the last number issued on a particular sequence involves inspired guesswork and wildcard searching. I believe a previous membership sec had an app on an ancient version of Windows that kept a log of the last issued numbers so he just input an initial letter and got back the number. Obviously I'd have to find 26 last issued numbers manually to get started but subsequently it'd be a lot easier.
So, anyone know of a Linux app that would help? Or is anyone able to script something? It doesn't have to be pretty, just idiot-proof. Or is there anyone with infinite patience who'd like to teach an old dog a new trick? My experience of scripting and programming is very limited and has rarely ended well but I'll give it a go with some advice.
So what do you want the program to actually do? Is the requirement simply a search for a number in a database of some sort, or what?