Method Community

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?

Thanks,

Mike

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

Audisho,

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

Thanks again,

Mike