Welcome to Forums Sign in | Join | Help | Forums
in Search


Importing reciprocal relationships for existing constituents

Last post 07-28-2009 2:12 PM by Kendra Hukill. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 07-24-2009 6:44 PM

    Importing reciprocal relationships for existing constituents

    I have a list of over 1,000 records to add reciprocal relationships for, so obviously being able to import the information would be way easier for me. But, when I try with just two guinea pig records, I get an exception error that the constituent record doesn't exist (for the main constituent). Any ideas on how this can be done?

     I've done everything in Solution Number BB23404.  Here's a copy of the exception report. Any help would be greatly appreciated :)

    Kendra

     

    Page 1
     
    7/24/2009
    Import Control Report
    Importing - individual relationships
    Results
    1
    0
    0
    Exceptions:
    Records Updated:
    Records Imported:
    Records Processed:
    1
    0
    Records Created:
    Output query of records imported:
    Output query of records updated:
    Exception file:
    Criteria
     
    Individual Relationship
    Function:
    File name:
    Type:
    Import new records
    Options:
    Automatically reciprocate relationship records
    ID Used:
    DelimitedFields are separated by a <comma>Text qualifier is a <quotation>
    First line of import file
    Import ID
    Format:
    Header:
    Raiser's Edge field
    Import field name
    CnBio_ID
    Constituent Import ID
    IRLink
    Relationship Link
    Notes
    Notes
    Comment
    Comments
    attribute
    Category
    Description
    Description
    Relationship
    Relationship
    Recipricol
    Reciprocal
    Field mapping
    Exceptions
    Reason
    FieldValue
    Field
    Record No.
    00001-593-00000800003
    Record does not exist
    Constituent
    Import ID
     1

     

    Filed under: ,
  • 07-27-2009 5:57 AM In reply to

    • Anbu
    • Top 50 Contributor
    • User Since: 2006
    • Posts 129
    • Organization: Ataxia UK
    • Products:  The Raiser's Edge

    Re: Importing reciprocal relationships for existing constituents

    Hi there,

    In your import these two are not matched- CnBio_ID Constituent Import I.  You have to pick the right option form the main import page where is say How do you want the system to identify the existing constituents.

    I did similar work recently. Basically, i had to link list of Individual records to an Org record and reciprocate the same relationship.  The import fields i used was just these six fields. If you want to reciprocate you have to tick the option 'Automatically reciprocate relationship' in the import section.

    ConsID ImportID ORLink ORRelat ORRecip ORAutoSoftCredit

     Hope it helps!




































    Regards
    Anbu
  • 07-27-2009 2:36 PM In reply to

    Re: Importing reciprocal relationships for existing constituents

    Oh yes! Thank you, that did the trick. It would only work using the import ID and not the constituent ID for some reason, but once I got them matching up, no problem :)  I'm also wondering if there's a way to set up in the import for any attributes to also be added to the reciprocal relationship, or if I'll have to do that with an updating existing records import. Any idea?

  • 07-28-2009 5:38 AM In reply to

    • Anbu
    • Top 50 Contributor
    • User Since: 2006
    • Posts 129
    • Organization: Ataxia UK
    • Products:  The Raiser's Edge

    Re: Importing reciprocal relationships for existing constituents

     I am not sure if the  import would be the best way of doing it. My sugg is you do it by global change. You can go to Global Change- Individual/Contact/Employee Relationship and then include the query which you created while you imported the reciprocal relationship and then go to 'Indivdual relationship Attributes' header and pick 'Attributes' which should be just next to the header .Here you add your new attributes. Hope it helps.

     

    Good Luck.

    Regards
    Anbu
    Filed under:
  • 07-28-2009 2:12 PM In reply to

    Re: Importing reciprocal relationships for existing constituents

    A global change is the way I would've wanted to do it, but there's also comments and notes that have to be added, all with different entries, so import was really my only option. I did figure it out though. Once I was able to get all the correct fields matched up, worked like a charm :)

Page 1 of 1 (5 items)