CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Define Starting member ID?
Pages: [1]

Author Topic: Define Starting member ID?  (Read 1535 times)

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Define Starting member ID?
March 21, 2012, 03:03:31 pm
We are moving a client over to CiviCRM and they want to continue to use the Membership Number format that is currently in use. Is there a way to define the MemberID starting number?

Joomla 1.7.3
CiviCRM 4.0.8

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Define Starting member ID?
March 22, 2012, 09:47:48 am
I have not seen a way since it is a primary key in the db.  I used the external identifier to get around this issue with individuals/companies and membership.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Define Starting member ID?
March 22, 2012, 10:32:22 am
You can also create a custom data of type membership and use that field for Membership id etc.

Kurund
Found this reply helpful? Support CiviCRM

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Define Starting member ID?
March 22, 2012, 10:53:09 am
With a custom field or using the ExternalID field, how do I get the number to auto-increment & fill the field?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Define Starting member ID?
March 22, 2012, 10:56:24 am
If you are using custom field, you auto-populate it using hook ( post hook ). So when membership is created update this custom data with membership id. Then you can use buildForm hook to disallow editing of this field via UI

HTh
Kurund
Found this reply helpful? Support CiviCRM

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Define Starting member ID?
March 22, 2012, 11:06:29 am
Thanks Kurund - I'll pass this on to our dev guy, as this just officially went outside my pay grade, lol.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Define Starting member ID?
March 22, 2012, 11:11:30 am
:)
Found this reply helpful? Support CiviCRM

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Define Starting member ID?
March 22, 2012, 01:56:43 pm
Actually - there is also a function in mysql to affect the next autoincrement number that will be selected.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Define Starting member ID?

This forum was archived on 2017-11-26.