I am in a situation where I imported some sponsoring pledges but forgot to attach the solicitor to those pledges.
I have an output file from the first import containing the
1. Donor import ID
2. Pledge import ID
3. Participant import ID alias the solicitor import ID
Now I am trying to instruct IOM to go to the pledge and add back the solicitor that I missed.
In IOM I will import
Column: A, Field Name:Gift ImportID, Record Type: Gift Field, Value Type: Gift ID
Column: T, Participant_import_id, Record Type: Gift Field, Value Type: Solicitor Import ID
I will then get exception error from the import:
Line 1: Required Field Missing: Surname [Object: 'CRecord', PK: '-1', Import ID: '', Desc: '', Field: 'Surname', Value: ''] -->BBREAPI.CRecordClass.Save()-->#=quphQTLtZ_orNYNFJA6usk_jNOC_XCwm_wwJKVG$fa1I=.#=qUJltwS5Q2_OCDkmKcksBPA==()
It seems like here that IOM is trying to add a new record instead of updating one.
My question is, is there a method to update a gift given that I have the Gift ID that I want to update? For example I might want to change the Fund, appeal or solicitors for each of these gifts.
Any sugguestion will be greatly appreciated.