Porting Member Info to Other Systems

[silurius]

I'm helping build a membership database for our project, and I'd like to have the vBulletin DB be the system of record for users. Eventually we are going to have to port the numbers and names out to some kind of card system.

I wanted to create a custom field assigning numbers to users in a sequence, but there didn't seem to be a built-in way (or plugin) to accomplish that, so I edited the MEMBERINFO template to add "(Member # $userinfo[userid])".

For exporting member info to another system, has anyone else developed a process, or even a basic script? I know enough SQL to get my self in trouble so I'd love to see feedback from someone who has been down this path before.