Method Community


Importing Contacts Birthdate

Last post 04-07-2015 5:51 PM by techconnect. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-06-2015 9:34 PM

    Importing Contacts Birthdate

    I've been importing Contact data.  I noticed that Birthdate is a field in the Contact table but that it's not available in To Existing Field dropdown when importing or updating Contact records.  Is there a way of getting birthdate data into Method other than the user interface?



  • 04-07-2015 8:51 AM In reply to

    Re: Importing Contacts Birthdate


    Hi techconnect,

    The reason that you can’t import into this field from the Contacts table is because this is a linked field. The field itself comes from the Entity table.


    If you plan on using this field, you should know that because the relationship from Entity to Contacts is one to many, all contacts linked to the same entity would have the same value for the BirthDate field. If this is what you’re looking for, then this should work, however you will need to import the BirthDate into the Entity table instead.

    Based on the fact that you are trying to import this value into the Contacts table, I believe you may want to give each individual contact a birth date. In this case, you will need to create your own custom DateTime field on the Contacts table to use for storing the birth date.

    I hope this helps.


    Audisho Sada
    Product Manager
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 04-07-2015 5:51 PM In reply to

    Re: Importing Contacts Birthdate


    Makes sense - thanks for explaining it.  I created a custom date field in Contacts for the DOB information.

    Thanks again,


Page 1 of 1 (3 items)