Importing deceased constituents with some decesed dates

Options
Troy Estrellado
Troy Estrellado ✭
Seventh Anniversary First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
I am importing a group of about 300 constituents in order to mark them all as deceased. Some of the constituents have a deceased date. When I attempt to validate the data before the official import, I get the following error message. 

"Validation error: The deceased field must be set to true if a deceased date is specified"

Has anyone else gotten this error before?


Thanks!

Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    I haven't imported deceased info but am guessing it's related to the field "Deceased" which would be required. This is one knowledgebase article that might help.

     



  • Troy Estrellado
    Troy Estrellado ✭
    Seventh Anniversary First Reply

    Hi Joann,

     

    Yes, I’m using both the Deceased (yes/no)
    field and the deceased date. Thanks for your input J !

     

    Troy
    Estrellado, Development Associate

    Pronouns:
    he, him, his
    Planned
    Parenthood of the Pacific Southwest
    1075 Camino del Rio
    South | San Diego, CA  92108
    Email:
    testrellado@planned.org
    |
    Office: 619.881.4503 | Fax: 619.291.0255
    Visit:
    planned.org
    | Give:
    planned.org/donate
    |
    Volunteer:     planned.org/volunteer

     

    Care. No matter what.
    Care. No Matter What.
    Care. No Matter What.
    Care. No Matter What.
    Care. No Matter What.


    This electronic transmission contains information from Planned
    Parenthood of the Pacific Southwest, which may be confidential or
    protected by the attorney-client privilege, the work product
    doctrine, or both. If you are not the intended recipient, please do
    not copy, disclose, distribute, rely upon or otherwise use the
    content of this message. If you have erroneously received this
    message, please immediately advise the sender by reply email and
    then delete this message and any attachments.
  • Aaron Rothberg
    Aaron Rothberg ✭
    Eighth Anniversary Facilitator 2 Name Dropper Photogenic
    Hi Troy-


    Can you post a screenshot of your import file that shows the Deceased column and values in that column? I just tested the import file you see below and successfully updated the Deceased checkbox and Deceased Date:

    acf6ff0b86e954799faf3ec02b7ba3e0-huge-de



     
  • Troy Estrellado
    Troy Estrellado ✭
    Seventh Anniversary First Reply
    Hi Aaron,


    Some more background... the reason I was doing this import was to switch the main constituent to the spouse because the main constituent is deceased but the spouse is still living. So the columns there are the constituent spouse deceased and deceased date. I've tried using "yes/no" instead of "True/False" as well. 

  • Melissa S Graves
    Melissa S Graves ✭
    Ninth Anniversary Facilitator 3 Photogenic
    Try doing an import with just one person and see it it works when not in validate mode.


    Validate will give occasional false errors when it is doing things not in the order RE needs to pass all of the verification steps. It happens sometimes with some sub-records (can't add info to a sub record when the initial record does not exist yet, etc.) so I think this may also be your issue. A live test with one record may help determine if this is what is happening.
  • Troy Estrellado
    Troy Estrellado ✭
    Seventh Anniversary First Reply
    Looks like that may have been the issue Melissa. I took out the constituent deceased and the constituent deceased date (I didn't need those anyways because they are all living) and that seemed to do the trick!


    Thanks everyone.

Categories