Page MenuHomePhabricator

Eileenmcnaughton (eileen)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Sep 15 2015, 12:37 AM (205 w, 11 h)
Availability
Available
LDAP User
Eileen
MediaWiki User
Eileenmcnaughton [ Global Accounts ]

Recent Activity

Fri, Aug 16

Eileenmcnaughton closed T228241: Add new calendar year fields to silverpop export, a subtask of T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop, as Resolved.
Fri, Aug 16, 3:23 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228241: Add new calendar year fields to silverpop export as Resolved.
Fri, Aug 16, 3:23 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Thu, Aug 15

Eileenmcnaughton added a comment to T228712: Finalise & test field mapping for targetsmart import.

@LeanneS I don't see the prospecting fields being missing when I look - cid 601342

Thu, Aug 15, 10:37 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228714: Create batch job wrapping target smart import allowing us to schedule it from Backlog to Doing on the Fundraising Sprint Princess Mongodb board.
Thu, Aug 15, 8:05 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228711: Update our csv import library in drupal from Review to Pending Deployment on the Fundraising Sprint Princess Mongodb board.
Thu, Aug 15, 8:05 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , fundraising-tech-ops, Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228712: Finalise & test field mapping for targetsmart import from Pending Deployment to Deployed on the Fundraising Sprint Princess Mongodb board.
Thu, Aug 15, 8:04 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Aug 14

Eileenmcnaughton added a comment to T228712: Finalise & test field mapping for targetsmart import.

I note that for some contacts their 'old' address is a subset of their new one - maybe having both at the point of import is fine as it gives us a good view on the data but we could look at a script at the end to remove any addresses that are a subset of the primary address

Wed, Aug 14, 11:10 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T228712: Finalise & test field mapping for targetsmart import.

@LeanneS I imported the first 5 rows into this group - civicrm/group/search?force=1&context=smog&gid=669 do you want to check it out?

Wed, Aug 14, 11:08 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T230513: Change in Stripe import file.

@LeanneS how urgent is this (trying to channel David - I think he would say 'when do you need it by')

Wed, Aug 14, 9:00 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T230513: Change in Stripe import file.

sigh

Wed, Aug 14, 8:58 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mon, Aug 12

Eileenmcnaughton added a comment to T228241: Add new calendar year fields to silverpop export.

@CCogdill_WMF the new fields should show up in about 3 hours (I set it going) - I guess you'll be asleep then :-)

Mon, Aug 12, 11:16 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Thu, Aug 8

Eileenmcnaughton moved T228712: Finalise & test field mapping for targetsmart import from Doing to Review on the Fundraising Sprint Princess Mongodb board.
Thu, Aug 8, 12:31 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Aug 7

Eileenmcnaughton moved T228712: Finalise & test field mapping for targetsmart import from Backlog to Doing on the Fundraising Sprint Princess Mongodb board.
Wed, Aug 7, 4:31 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Tue, Aug 6

Eileenmcnaughton added a comment to T229273: Bug: Trigger caused db locks.

@Jgreen we have made a minor update to the triggers but I need you to reload them now - the change is per https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/528594/1/sites/all/modules/wmf_civicrm/scripts/triggers.mysql

Tue, Aug 6, 11:15 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228713: Add missing Prospect fields to our dev environments from Backlog to Doing on the Fundraising Sprint Princess Mongodb board.
Tue, Aug 6, 9:46 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T229273: Bug: Trigger caused db locks from Backlog to Review on the Fundraising Sprint Princess Mongodb board.
Tue, Aug 6, 9:46 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T227363: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data).

from Brian

Tue, Aug 6, 8:13 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T213757: Replace MySQL-python with pymysql in fundraising python scripts.

this is rolled back atm

Tue, Aug 6, 8:10 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
Eileenmcnaughton moved T227500: List all data types in the import from IBM to civi from Doing to Deployed on the Fundraising Sprint Office   board.
Tue, Aug 6, 6:26 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T227500: List all data types in the import from IBM to civi.

OK - written up here https://www.mediawiki.org/wiki/Fundraising_tech/CiviCRM#Data_transfer_between_CiviCRM_and_Watson_Campaign_Automation_(aka_Silverpop,_IBM_)

Tue, Aug 6, 6:26 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228826: Prepare next civi upgrade from Deployed to Backlog on the Fundraising Sprint Office   board.
Tue, Aug 6, 5:22 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228826: Prepare next civi upgrade from Backlog to Deployed on the Fundraising Sprint Office   board.
Tue, Aug 6, 5:22 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T229273: Bug: Trigger caused db locks from Doing to Review on the Fundraising Sprint Office   board.
Tue, Aug 6, 5:21 AM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mon, Aug 5

Eileenmcnaughton added a comment to T229681: New Custom Field - Endowment Site Listed as.

you can add it here

Mon, Aug 5, 7:37 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T229681: New Custom Field - Endowment Site Listed as.

@NNichols have you added this yet ? Please do

Mon, Aug 5, 7:35 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228825: Fix CiviCRM import bug whereby it doesn't recognise labels, a subtask of T227513: Investigate: TargetSmart Civi import, as Resolved.
Mon, Aug 5, 10:54 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228825: Fix CiviCRM import bug whereby it doesn't recognise labels as Resolved.
Mon, Aug 5, 10:54 AM · Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Sat, Aug 3

Eileenmcnaughton updated subscribers of T229684: Bug: "Total Bad Data" rows in IBM import should be in the correct format when exported out of Civi.

Also note that @Ejegg has rolled back a different patch that went out this week so we will see what the output from that is

Sat, Aug 3, 12:45 AM · Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T229684: Bug: "Total Bad Data" rows in IBM import should be in the correct format when exported out of Civi.

@MNoorWMF @CCogdill_WMF all the referenced fields are new fields per the deployment earlier this week. They don't seem to be outputting a different format but were they definitely added at the silverpop end?

Sat, Aug 3, 12:44 AM · Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Jul 31

Eileenmcnaughton added a comment to T229148: Extend Civi Deduper access to all Donor Services agents?.

@MBeat33 we pushed out a minor permissions change - see if they can access it now

Wed, Jul 31, 11:54 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton added a comment to T229273: Bug: Trigger caused db locks.

OK - so the number of rows is double there - ie

Wed, Jul 31, 11:53 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T229273: Bug: Trigger caused db locks.

OK I'm getting good results on staging even updating 150k contacts at once - so struggling to explain the hang. Still I have got some explain results to dig into running it on a large batch

Wed, Jul 31, 11:39 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T229148: Extend Civi Deduper access to all Donor Services agents?.

Actually I think I have a patch that would amend them - just pushed it up

Wed, Jul 31, 5:03 AM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton added a comment to T229148: Extend Civi Deduper access to all Donor Services agents?.

@MBeat33 it looks like we need to fix the deduper to work with lower permissions & I should do that. In the meantime I'm OK to give them the Donor Services Management role (which is what you have) until we sort this out if you think that's OK

Wed, Jul 31, 4:59 AM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton moved T228711: Update our csv import library in drupal from Backlog to Doing on the Fundraising Sprint Office   board.
Wed, Jul 31, 2:10 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , fundraising-tech-ops, Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Tue, Jul 30

Eileenmcnaughton moved T213757: Replace MySQL-python with pymysql in fundraising python scripts from Deployed to Doing on the Fundraising Sprint Office   board.
Tue, Jul 30, 10:09 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
Eileenmcnaughton added a comment to T213757: Replace MySQL-python with pymysql in fundraising python scripts.

OK - reversing this out of the deploy -

Tue, Jul 30, 10:09 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
Eileenmcnaughton added a comment to T229273: Bug: Trigger caused db locks.

Back in doing for the backfill script

Tue, Jul 30, 9:41 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T225544: Rename Field in IBM export from Pending Deployment to Deployed on the Fundraising Sprint Office   board.
Tue, Jul 30, 9:41 PM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Fundraising-Backlog
Eileenmcnaughton moved T228241: Add new calendar year fields to silverpop export from Pending Deployment to Deployed on the Fundraising Sprint Office   board.
Tue, Jul 30, 9:41 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T229273: Bug: Trigger caused db locks from Pending Deployment to Doing on the Fundraising Sprint Office   board.
Tue, Jul 30, 9:41 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T213757: Replace MySQL-python with pymysql in fundraising python scripts from Pending Deployment to Deployed on the Fundraising Sprint Office   board.
Tue, Jul 30, 9:41 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
Eileenmcnaughton added a comment to T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop.

Yes, that was included

Tue, Jul 30, 9:39 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T213757: Replace MySQL-python with pymysql in fundraising python scripts.

I included this in the deploy just now - seemed ok from looking & from comment above

Tue, Jul 30, 9:31 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
Eileenmcnaughton added a comment to T229273: Bug: Trigger caused db locks.

OK - we have had one donation come in since they were re-enabled & it worked (short the date_of_largest_donation field which is currently excluded) - I'll work on a backfill now

Tue, Jul 30, 9:03 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228349: Make sure silverpop export does not include endowment donations (except in explicit endowment fields) from Backlog to Review on the Fundraising Sprint Office   board.
Tue, Jul 30, 4:51 AM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Fundraising-Backlog
Eileenmcnaughton moved T228825: Fix CiviCRM import bug whereby it doesn't recognise labels from Backlog to Deployed on the Fundraising Sprint Office   board.
Tue, Jul 30, 4:51 AM · Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228241: Add new calendar year fields to silverpop export from Backlog to Pending Deployment on the Fundraising Sprint Office   board.
Tue, Jul 30, 4:50 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T229273: Bug: Trigger caused db locks from Doing to Pending Deployment on the Fundraising Sprint Office   board.
Tue, Jul 30, 4:50 AM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T229273: Bug: Trigger caused db locks.

@Jgreen on live there is now a trigger file sites/all/modules/wmf_civicrm/scripts/contribution_triggers.mysql which has the triggers minus the ones I think most likely to be problematic - if you can reload that

Tue, Jul 30, 4:47 AM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop.

@CCogdill_WMF we are now ready to deploy the addition of

Tue, Jul 30, 3:48 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T229273: Bug: Trigger caused db locks from Backlog to Doing on the Fundraising Sprint Office   board.
Tue, Jul 30, 12:36 AM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mon, Jul 29

Eileenmcnaughton added projects to T229273: Bug: Trigger caused db locks: Unplanned-Sprint-Work, Fundraising Sprint Office  .
Mon, Jul 29, 9:04 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T229273: Bug: Trigger caused db locks.
Mon, Jul 29, 8:28 PM · Fundraising Sprint Princess Mongodb, Patch-For-Review, Fundraising Sprint Office  , Unplanned-Sprint-Work, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Fri, Jul 26

Eileenmcnaughton added a comment to T229076: Disable new wmf_donor triggers while we make them not lock the db.

The most likely problem point would be the date of latest largest field - perhaps a contact with many donations of the same amount caused the issue ? I didn't hit it in my testing but that felt like the least robust piece in the puzzle

Fri, Jul 26, 3:52 AM · fundraising-tech-ops

Thu, Jul 25

Eileenmcnaughton added a comment to T228712: Finalise & test field mapping for targetsmart import.

@LeanneS sigh - the options for the values have changed again

Thu, Jul 25, 2:34 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Jul 24

Eileenmcnaughton added a comment to T228712: Finalise & test field mapping for targetsmart import.

@LeanneS the 'full_address' is just street_address+supplemental_address+ supplemental_address_2+city + etc isn't it?

Wed, Jul 24, 11:32 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T222958: New total fields needed for MG prospecting, a subtask of T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop, as Resolved.
Wed, Jul 24, 8:38 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T222958: New total fields needed for MG prospecting as Resolved.
Wed, Jul 24, 8:37 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Patch-For-Review, Wikimedia-Fundraising-CiviCRM, FR-Civi-Planned-Giving, FR-Civi-Prospect, Fundraising-Backlog
Eileenmcnaughton moved T222958: New total fields needed for MG prospecting from Backlog to Deployed on the Fundraising Sprint Office   board.
Wed, Jul 24, 8:37 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Patch-For-Review, Wikimedia-Fundraising-CiviCRM, FR-Civi-Planned-Giving, FR-Civi-Prospect, Fundraising-Backlog
Eileenmcnaughton moved T227363: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) from Backlog to Doing on the Fundraising Sprint Office   board.
Wed, Jul 24, 8:37 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T227500: List all data types in the import from IBM to civi from Backlog to Doing on the Fundraising Sprint Office   board.
Wed, Jul 24, 8:36 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T227513: Investigate: TargetSmart Civi import.

Do we want this investigation task still - I feel like we have sub-tasks now

Wed, Jul 24, 4:24 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T227513: Investigate: TargetSmart Civi import from Backlog to Deployed on the Fundraising Sprint Office   board.
Wed, Jul 24, 4:23 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T228715: Nurse love & iterate on our targetsmart batch job.

@DStrine should we bump this out of the sprint - it's really the phab I created to track things once we've started off the background task so I would not expect to start it until next sprint

Wed, Jul 24, 4:10 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T228826: Prepare next civi upgrade.
Wed, Jul 24, 4:09 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228825: Fix CiviCRM import bug whereby it doesn't recognise labels to 2.
Wed, Jul 24, 4:03 AM · Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T228825: Fix CiviCRM import bug whereby it doesn't recognise labels.
Wed, Jul 24, 4:03 AM · Fundraising Sprint Office  , Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T228712: Finalise & test field mapping for targetsmart import.

@LeanneS there are a couple of columns that I don't see mapped in your image

Wed, Jul 24, 4:01 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Tue, Jul 23

Eileenmcnaughton changed the point value for T228712: Finalise & test field mapping for targetsmart import from 1 to 2.
Tue, Jul 23, 8:59 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228712: Finalise & test field mapping for targetsmart import from Backlog to Doing on the Fundraising Sprint Office   board.
Tue, Jul 23, 8:50 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228713: Add missing Prospect fields to our dev environments from Backlog to Review on the Fundraising Sprint Office   board.
Tue, Jul 23, 8:50 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T227363: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) from Backlog to Doing on the Fundraising Sprint Never Ending Query board.
Tue, Jul 23, 8:06 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228242: Backfill new calculated fields, a subtask of T228241: Add new calendar year fields to silverpop export, as Resolved.
Tue, Jul 23, 8:00 PM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228242: Backfill new calculated fields as Resolved.
Tue, Jul 23, 8:00 PM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T228242: Backfill new calculated fields.

the script finished

Tue, Jul 23, 8:00 PM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228242: Backfill new calculated fields from Doing to Deployed on the Fundraising Sprint Never Ending Query board.
Tue, Jul 23, 7:59 PM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T227513: Investigate: TargetSmart Civi import from Review to Deployed on the Fundraising Sprint Never Ending Query board.
Tue, Jul 23, 5:42 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T227363: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) from Doing to Deployed on the Fundraising Sprint Never Ending Query board.
Tue, Jul 23, 5:42 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228106: Add index on civicrm_activity.location, a subtask of T226560: Adding fields to Activity Search page, as Resolved.
Tue, Jul 23, 5:41 AM · Fundraising Sprint Men In Slack, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T228106: Add index on civicrm_activity.location as Resolved.
Tue, Jul 23, 5:41 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T228713: Add missing Prospect fields to our dev environments from Backlog to Review on the Fundraising Sprint Never Ending Query board.
Tue, Jul 23, 4:33 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T228713: Add missing Prospect fields to our dev environments.

So far I've found locally I'm missing

  • option values for PG Stage
  • University Affiliation
  • Family Composition
  • Occupation
Tue, Jul 23, 1:44 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T227513: Investigate: TargetSmart Civi import from Doing to Review on the Fundraising Sprint Never Ending Query board.
Tue, Jul 23, 1:26 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228715: Nurse love & iterate on our targetsmart batch job to 4.
Tue, Jul 23, 1:26 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton updated the task description for T228715: Nurse love & iterate on our targetsmart batch job.
Tue, Jul 23, 1:25 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T228715: Nurse love & iterate on our targetsmart batch job.
Tue, Jul 23, 1:25 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T228714: Create batch job wrapping target smart import allowing us to schedule it.

I'm thinking here to use an extension for this & to convert our 'pre-checks' (ie. our throttle logic) to a hook. Undecided as yet whether just to track through settings like in other places or to investigate Civi's batch mechanism - will have a discussion with Tim

Tue, Jul 23, 1:24 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228714: Create batch job wrapping target smart import allowing us to schedule it to 4.
Tue, Jul 23, 1:23 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T228714: Create batch job wrapping target smart import allowing us to schedule it.
Tue, Jul 23, 1:23 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228713: Add missing Prospect fields to our dev environments to 1.
Tue, Jul 23, 1:22 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T228713: Add missing Prospect fields to our dev environments.
Tue, Jul 23, 1:22 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228712: Finalise & test field mapping for targetsmart import to 1.
Tue, Jul 23, 1:21 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton created T228712: Finalise & test field mapping for targetsmart import.
Tue, Jul 23, 1:21 AM · Fundraising Sprint Princess Mongodb, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228242: Backfill new calculated fields to 2.
Tue, Jul 23, 1:05 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T224742: Civi: fredge query yielding '502 bad gateway' error to 1.
Tue, Jul 23, 1:04 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228480: Civi: Upgrade permissions level for Payments Specialist to 1.
Tue, Jul 23, 1:04 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T222958: New total fields needed for MG prospecting to 8.
Tue, Jul 23, 1:03 AM · Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Patch-For-Review, Wikimedia-Fundraising-CiviCRM, FR-Civi-Planned-Giving, FR-Civi-Prospect, Fundraising-Backlog
Eileenmcnaughton set the point value for T228710: Update data on staging to 1.
Tue, Jul 23, 1:03 AM · Fundraising Sprint Office  , fundraising-tech-ops, Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton set the point value for T228106: Add index on civicrm_activity.location to 1.
Tue, Jul 23, 1:00 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog