@Eileenmcnaughton did you need the list of appeal codes we use in MGFE per fiscal year?

@DBautista-WMF - looping you in on this task as I know we've discussed it previously and its related to our $10k gift tracker process.

@MDemosWMF - yes agree that it should work both ways.

Hi Lars,

@Lars - see my answers below:

@MDemosWMF and @krobinson - I think for now send them my way but maybe we can reassess if volume gets to much for me. I think its mainly a case of civi clean up (merging records, linking DAFs, snoozing).

@Lars - we can close, thank you.

@Lars - i think we can close this now.

@AFowler-WMF and @Lars - I think we use pledges now to track the multi year gifts.

sounds good to me

@Lars and @DBautista-WMF - thanks for working on this. I think it would be good to distinguish between workplace giving and restricted funds if we can. I think those tags should be clear enough, we would just have to let fr-ops know for the benevity import.

@Lars - thanks for the ping on this. I don't think i've run into this issue recently and so I think its all fixed.

@MDemosWMF - thanks for checking on this, i have the donors with the DA data we needed in a group so we should be all good.

@MDemosWMF let me know if you need anything else.

@Ejegg - this works now, thank you so much,

@Ejegg thanks for the ping on this, I still can't add relationships via this way due to the solicitor field issue. I think making it 'not required' field is a good idea for now and I can check if the field is still used. I know we switched over to Relationship Manager instead.

@Ejegg - thanks for the information. Do we know why it might have been disabled and who the best person/people are to discuss enabling this feature again? Thanks for help with all this.

@MDemosWMF - also do you have any information/field the Faircom data will include?

@MDemosWMF - we were going to use some of these fields to help screen donors for inclusion on our MGFE appeals for FY25-26. For FY24-25, we used them and the upgrade asks we did for this cohort worked well so we were going to look at this again for this year. I'm due to pull this data next week for our MGFE suppression lists which is before the deadline you mentioned.

@Ejegg - are you able to confirm what happens when a donor fills in their details in the employer form when they make a gift? Is the email still being sent to the donor to confirm that their company has a matching gift program?

@MDemosWMF and @Ejegg - thanks both for looking into this, I think it is likely donor error where there are a few options maybe for certain companies.

@Eileenmcnaughton I wanted to check in on this, we would want the donor segment to reflect the gift amount they are soft credited for right? Is this something we can do?

@Eileenmcnaughton - I went through and reviewed all the ones on the $1k list, a few I'm unsure of so maybe we restore to be on the safe side, a few I restored and merged and then there were a few that were needed to be deleted. I left notes in the doc so you can see.

@Eileenmcnaughton Sandra and I chatted and I agree with this, it would save a lot of manually deduping time. I also wondered if we could also have the script automatically merge records where first name, last name, mailing address are a match but the email address is different. Is there scope for these to also dedupe, where the new email tis o be recorded as the primary email and we keep the old email as an old non primary email address?

@Eileenmcnaughton - would it help if I shared some CIDs with contributions that should flow into the Major Gifts Alternative and Other Category so you can see what I mean?

@Dwisehaupt Lisa's approval is attached and I will get Erica setup on the contact list today.

@AKanji-WMF - I need to think of the fields we need for the Major Gifts Engagement activity type.. I'll hopefully get to this, this week.

@Eileenmcnaughton @MDemosWMF @MRitch-WMF @JMando - hi all I think just to confirm for any gifts that come in that DO NOT have an appeal related activity or DO NOT have the major gifts related activity and its coded as white mail, the revenue should still flow to Major Gifts as it makes up our Alternative and Other Category.

Hi Eileen,

@MDemosWMF and @Ejegg thanks for checking on this, I don't see a need to move historical gifts over. The records are linked by a relationship so we can always see the older donations on the previous CID.

@Ejegg - looping in @KHaggard as she will know more about the Acoustic side of things.

@Ejegg - i think it was the Organization rule and email is enough maybe?

@Ejegg - I was trying to look for duplicate Organization Contact types within a certain group in Civi to dedupe, rather than individuals who are the contact people for organizations. e.g. cid 1040052 and 14868337

@Ejegg and @SHust oh yikes, really sorry, I was going a batch merge for some duplicate org contacts in Civi. Should I not use that rule going forward? I stopped the merge now. Let me know if there's anything else I can do to help.

@Eileenmcnaughton @MDemosWMF - I think the Trilogy import was used for email sends years ago and nobody on MGFE team uses this import so I think we're good to remove, but just to double check @JSimmons we don't use this for any events do we?

@AKanji-WMF - i think it would be good to still increase this limit to tide us over as we head into appeal season.

@Eileenmcnaughton - all looks ok to me and the revenue looks like what it was in Civi for this DMA. Thank you!

@MDemosWMF - I can see the drop down option in Civi when searching.

@AKanji-WMF I'm adding @MDemosWMF as well as she needs to add this DMA to gifts coming in still that need this DMA

@Eileenmcnaughton - I actually have run into this issue, this week. I exported some Endowment gifts from Civi for a mailing and the Addressee and Postal fields are blank. Here's some CIDs
54887980
56756196
But there are up to 65 in my export that were blank. They might all be Financial type = Endowment Gift, not sure if that helps.

thanks @Dwisehaupt this works great.

@Dwisehaupt since its the Annual Report, its a different campaign so we'd want to track it differently, could https://fundraising.wikimedia.org/AnnualReport2122 work instead? With the URL I added in this task.

@Eileenmcnaughton - let me take a look as it's been ages since I did an import. @MDemosWMF - do you know if this still happens? I think the DAF import might be a good import to check this for.

I think you can close this task.

thanks Eileen, will do!

@Eileenmcnaughton yes, ty!

@Eileenmcnaughton - think we did a bit of this manually maybe

@Eileenmcnaughton - I think this is still happening, is it not? @JSimmons is this still an issue when updating Activities?

@Eileenmcnaughton thanks for the update, feel free to close

@Eileenmcnaughton yes i managed to export a large file with the preferred language field with no error this time.

@Eileenmcnaughton amazing, thanks for the update Eileen. This will save a lot of manual clean up for future major gift mailings.

@Ejegg - I think that sounds like a good plan, since Desiree has done a lot of manual clean up for our current major gift email campaign we wouldn't want to over ride the work she's done to ensure this field is filled. Would it make sense to do the script going forward for any new gifts that come in of $250+ and DAF related? Then we should be in better shape for future major gift email campaigns and little manual clean up would be needed on our end.

@Ejegg thank you. I'm going do a bulk import for these Activities next week and we'll likely be searching using these new custom Activities in the following week, will this work ok?

@Ejegg thanks for looking into this, we don't need records backfilled. We only really need it for donors who fall within the major donor audience (donors who make a gift of $250+ or donor advised donors) which is probably around 30k donors. We have been updating the field when we see it is blank ourselves manually. The main reason we wanted to use the email greeting field over first name is because we have a higher number of Organizations who have been long time donors who we email and it doesn't feel right to address them as Dear Wikimedia Supporter. We also have a number of donors who donate as a couple and customizing this field allows us to address donors as a couple in our emails as well.

I think its the preferred language field that might be causing the issue for the export, but I need this field in the export.

@Jgreen hey Jeff,

@Cstone thanks, confirming this error is fixed.

@Dwisehaupt and @Eileenmcnaughton I wasn't sure who to bump this up to, but we're looking to automate more of the thank you letters we send in major gifts and since we have a lot of organizations that make large gifts, this needs to be fixed before we can do that. Is this an easy fix in the donor thank you template?

Thank you so much for the update and work on this @KHaggard and @Eileenmcnaughton

I think we assumed the email_greeting was the field used for the salutation in the automatic email? That would likely be our preference but if not I think "Dear Friends of Organization Name" would be preferred?

@JSimmons - can you take a look at the imports Eileen has mentioned for Jerry as I think they might all be event related?

Thanks David and yes @KHaggard is looped in on the task and the request.

@Eileenmcnaughton - thanks that's good to know and will do.

@Eileenmcnaughton - I using an export mapping that was already saved but added a few additional fields from the prospect tab, unless I somehow selected all fields but that wasn't my intention.

@Ejegg thank you so much, I tested this and it works. I was getting myself confused on how to select the whole list and then unselect Endowment, so thank you for the tip.

@Ejegg thanks, I think it would work but I'm having trouble trying to the Endowment financial type. I can select a bunch of different financial types but then I can't seem to exclude the Endowment financial type. Ideally I'd to have all other financial types excluding and have Endowment as the only one.

thanks @Ejegg when I tried to add in a new threshold level and save the configuration i then get this message

@Eileenmcnaughton thanks so much that worked!