Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Looking for Client ID Generating Software

Jun 8, 2014 6:45PM PDT

Hello and apologies if this is the wrong place for a discussion.

I am in need of software which can create unique ID numbers for a range of clients.

Ideally, it would use certain known variables such as a Date of Birth, Initials and scramble it to create a unique number/code.

Usually I can find what I need through a search engine but not this time - all I get is results relating to GUID!

Can anybody advise or direct me to appropriate solutions?

Kind regards,
Henry

Discussion is locked

- Collapse -
Answer
Why not 1, then 2, then 3, etc?
Jun 8, 2014 6:49PM PDT

Each one would be unique.
Bob

- Collapse -
Client Characteristics
Jun 8, 2014 7:16PM PDT

Thanks for replying,

Because it relates to clients and the purpose is to know whether the client has already presented.
Therefore the code would need to relate to individual client characteristics so that the same code would be generated on a different occasion.

Thanks,

- Collapse -
That's what a database does.
Jun 8, 2014 7:34PM PDT

They supply their code or some details and you get their code. A long time ago I wrote a membership app for a gym. This worked for over a decade just fine. I wonder, is this for some school assignment? Sometimes folk can't use simple solutions for the homework.
Bob

- Collapse -
Pretty much, yes
Jun 8, 2014 8:22PM PDT

Exactly.
Thanks for your reply

That's why we would only be using fixed characteristics: Birthdate, Name, Ethnicity short-codes, gender shortcodes etc.

I've just come across MD5 Hash which is sort of what I was after.

Thanks

- Collapse -
When I test the student's solution it's always fun.
Jun 9, 2014 2:44AM PDT

I'll input John Smith. OK, all good. Now I'll input JOHN SMITH and see if they were smart enough.
Bob

- Collapse -
Answer deleted
Jun 8, 2014 8:23PM PDT

Sorry, by accident I deleted the reply from the OP saying that it wasn't a school assignment, but for work needing to recognise clients they already had in the database, so they could link to earlier reports about him.

Kees

- Collapse -
Re: identification
Jun 8, 2014 8:21PM PDT

So you want a certain John Doe with a certain birthdate living on a certain address (or having a certain email-address) to be recognised as an existing customer if he already is in the database. Then you just search the database (using an index preferably) on name, address and birthdate to see if he happens to be present already before inserting him as a new customer.
This won't get him if he moved in the meantime or got a new e-mailaddess, but in the other side, if you only search on name and birthdate different John Doe's with the same birthdate would be found to be the same customer even if they aren't, which is much worse.

Using a unique number (like the SSN) would be the best. Then some other entity is responsible for the identification.

Kees