Great! Thanks for the update.

@Eileenmcnaughton @DStrine
I'll keep this on our radar. The next time we pull emails from civi for a manual upload to IBM is the annual appeal. I'll make sure to ping you with the sheet so you can see an example.

@Eileenmcnaughton It did seem to only happen intermittently. If it happens again I'll add the contact ID here.

yes thank you!

Any sense on how we restore this data? Michael has a phab task in asking that all prospect information be automatically merged which will save the data from this in the future. However, we are starting to put together lists of donors we (Major Gifts & Endowment) want to suppress from fundraising emails by end of next week. We're using the Net Worth data points as criteria for this list.

Okay thanks!

@Eileenmcnaughton I don't know if these spaces exist around the email in civi. We are running into this issue when we export emails. The CSV that we get has spaces at the end of the emails in the cell.

@Eileenmcnaughton Do you have an idea of how many records with the Target Smart data were deleted?

I do not have a yubikey. My server access has only been to Fundraising up to this point. I have the Viscosity VPN set up on my laptop that allows me to connect automatically. Can I continue using this for access?

Yes! As we've been discussing merging processes across teams we've realized that there might be a risk to losing this data. To be safe having it automatically move would be great.

Yes this would be super helpful. We (MG&E) generally use the name data from the most recent donation and save any other name variants in the nickname field.

yes please! I was the one using the data primarily but I'll let the team know it's there.

This is a user issue. Not sure how to delete this! Please disregard

yes! thank you

I've made it to the mapping screen!! I'll let you know if there are any other issues.
You're the best! 🙌

Thanks! I've just created it in Civi

Yes it has been added. However, I have another request to add an additional field here. It would be "WLS Listed as". Should I make a new task?

@spatton RE removing Name - I would not have thought of that but it makes sense to me to try it.

@Eileenmcnaughton Yes please overwrite the existing net worth field. Some of the ones you listed above were created before the Targetsmart data was being imported. They are not being used consistently at the moment and we'd rather have the up to date TS data instead.

@Eileenmcnaughton These look good to me. Danny did request adding change in calendar year between 2017-2018 is that possible?

Thanks! All done on my end.

@DStrine Looks good! Thanks

Hi @Eileenmcnaughton Thanks for this.

@Eileenmcnaughton I've consolidated my last message here and some of the team's new Qs and requests here:

@Eileenmcnaughton So is it possible to have ALL of them? We're just thinking that even if we don't add them to our summary screen view it would be great to be able to search and export these types of calculations when we are reviewing prospect lists.
For example, Danny is really interested in being able to search for donor sets that might have had an increase of $500 between two calendar years.

@Eileenmcnaughton These experimental fields are really interesting. Would you like me to explore interest among the team? And if so how much time do we have to make a decision?

@mepps Not Empty is really slow but thank you for giving me the option!
@DStrine good to close.

Yep! Thanks Eileen

No. There is only a small handful (5 or 6) donations made from non-English speaking countries a year.
As Caitlin said definitely other English speaking countries.

Fantastic! I was able to add the rest of the fields I needed. Thanks!

Thanks Sam! Thoughts in your Qs:

I already used it! Amazing. Thank you!

@jgleeson Moving it there sounds right.
I think the field should read "Employer Name (Optional)".

@mepps It's a great question and I just mentioned this to Caitlin V yesterday. The company we are thinking about working with after testing would integrate their own search box into our donation form. This would be an automatic lookup that would result in an automatic email being sent to the donor after the donation form has been submitted with the matching gift company details and links to start the process.

Oh my goodness! That looks so incredibly different!

Additional notes:

Let's keep it open. I envision a world with lots of dashlets :)
@CaitVirtue I'm adding this point to our action items to think about for the near future.

Thank you all! I just tried it and worked without issue.

@Eileenmcnaughton Leanne and I were trying to figure out some Engage discrepancies and I ran the contribution search for those in the trash. A few online donations came back (one was $2500) and a stock gift I had entered.

@Eileenmcnaughton I have time tomorrow. Or we can wait until fortnightly?

I think we're good. I haven't seen it happen again.

Yeah I think that's a safe bet ;)

Thanks Eileen! Glad the list was small enough to review in one sitting.

I'm not having any issues.

Wow. So it looks like that person never even received a thank you email?
It just went straight to the trash?

Yes I saw the subtask. I think this is closable.

@Eileenmcnaughton Yes! they are gorgeous! Please close

Looks great! thank you

I was able to restore all of the gifts that came from engage but if I run the same search going back to 1/1/2016 there are about 282 contacts in the trash. Not sure how we would go through these to see which ones need to be restored.

@Eileenmcnaughton You ARE the best. It works great. I tested it a few times with different civi records.

@Eileenmcnaughton Yes! I added the contact ID back into the block we originally wanted it to live in. Have been able to edit the other field around it without issue.

@Eileenmcnaughton Yes! I have tested it out on a few profiles (individual and org) and it looks great. I think we can wait for the fix as no one has really caught it besides me.

@Eileenmcnaughton Yes I can confirm those are each individual issues we've encountered

1. I created a separate block for the ID to live with the contact source since these are things that do not change
2. yes - also no biggie but we lost the ability to have color coded tags :(
3. yes - I have also removed the current employer from the custom block we were using and am now relying on the Key relationships block - only issue is that it is not right next to the Job Title field
4. YES

@Eileenmcnaughton I've moved things around a little on the contact screen to accommodate for the time being. I think the most important thing for us was not so much that it was at the top but that the original screen allowed the fields "current employer" to be grouped with "job title"

@Eileenmcnaughton Sorry to tack on more to this task but is there a way to fix this?

@Eileenmcnaughton I spoke too soon. I still can't edit tags. Also, if I enter an employer on the summary screen and save The relationship then appears as both Current and Inactive at the same time.

@Eileenmcnaughton That makes sense! Thanks for figuring that out. It seems to be working for me now. I just added another block that contains only the Contact ID since like you said it's not editable.

Never mind! Cancel this please.

Works great! I removed her from the other group as well. Thank you!