Adding a Birth Year to the Raiser's Edge Birthdate Field via Import

Options
Hi, I would love to add a birth year to the birthdate field via import. Often times, we know the birth year of a constituent, but not the exact day and month. Will RE consider adjusting the import functionality in the future? Thank you.

Comments

  • I'm surprised it won't let you import the year alone via import. Does your instance of RE allow you to enter just the birth year when editing a constituent record manually? Mine handles that with no problem, so I'm wondering if there's a setting somewhere that allows for this. I didn't do the initial setup for RE at my current job, so I'm not sure if that's an option that exists somewhere - I didn't find anything obvious when looking through config.
  • The Birthdate field is a fuzzy date.  Before version 7.93 it could be just the year or month/year.  Since 7.93 it can be month/day.  Because it is a fuzzy date (and different from all other fuzzy dates in RE which are only month/year) you have to be careful about how you format the date when entering or importing data.  Unless you've found a bug you should be able to import just a 4-digit year into the Birthdate field.
  • There is no setting, but this was a field-type change from (I think) 7.92 to 7.93.  The field will now allow month/day, year, month/year, or the full month/day/year.  If Import is not allowing this, could it be a setting in the Import file (i.e. the csv file you are trying to import from)?  Otherwise, it may be something that never got adjusted when that field-type change was made.  In which case, I would suggest that you open a case in Case Central about this, and someone will investigate to determine if this is a problem within RE Import or within your specific database, or something else altogether.  If I have a chance tonight, I will try such an Import and see what happens.
  • Thanks everyone for your suggestions! I was finally able to get the import to work. Yay :-)

Categories