CiviCRM Community Forums (archive)

High guys, I've had my eye on CiviCRM for a couple of years, and I've scrapped one of my home grown php systems to migrate to it.  Very excited but wanted to get a feel for best practice on this problem.

Our Non Profit has clubs (organizations) and members.  We have a clubID and a MemberID both numbers are very important and how our other software interacts with membership data.  The clubIDs in the past were 1000-2000ish via an identity in that table.

Our membership Data was 1000-12000ish by an identity in that table as well.  My question is can I replicate that in CIVICRM to be automated?  I know CiviCRM has its own Id number that is an identity and I can alter the table to make that seed start at 12012 (our last membership number in my old system) and then I can use that for the ID,  My only problem with that is our memberhsip ID numbers could get huge since organizations, houselholds and everything uses that identity.  The other problem is clubs would be thrown into that, so our current clubid 1000 would be come clubid 12013 and there would be quite a bit of relational integrity lost or further reconciliation in our other system that would have to be performed.  I want a custom field that is an identity so i can have club id and member id be independant and sequential and possibly overlap is how can i accomplish that?

Thanks!

David

Thanks I will just utilize the civicrm contact id for simplicity in development since this is my first project, i see how custom hooks would allow me to acccomplish this though.

Thanks,

David