Page MenuHomePhabricator
Create Task
Maniphest T113087

PayPal audit parser is not associating donations with the correct contribution_tracking record
Closed, ResolvedPublic1 Estimated Story Points
Actions

Description

Looks like the contribution tracking ID is correct in the audit file, so:

  • Fix the code so it imports correctly.
  • Delete contributions which failed to associate.
  • Reparse affected audit files.

Details

SubjectRepoBranchLines +/-
One-off script to repair payment audit importwikimedia/fundraising/crmmaster+19 -0
Parse and send the contribution tracking ID, if availablewikimedia/fundraising/toolsmaster+6 -1
Customize query in gerrit

Related Objects
Search...

Event Timeline

awight created this task.Sep 18 2015, 7:25 PM
awight claimed this task.
awight raised the priority of this task from to High.
awight updated the task description. (Show Details)
awight added projects: Fundraising Sprint Tom Waits, Unplanned-Sprint-Work, Fundraising-Backlog.
awight added subscribers: Pcoombe, • jrobell, awight, Aklapper.
gerritbot subscribed.Sep 18 2015, 9:51 PM

Change 239507 had a related patch set uploaded (by Awight):
Parse and send the contribution tracking ID, if available

https://gerrit.wikimedia.org/r/239507

gerritbot added a project: Patch-For-Review.Sep 18 2015, 9:51 PM
awight moved this task from Backlog to Review on the Fundraising Sprint Tom Waits board.Sep 18 2015, 9:55 PM
gerritbot added a comment.Sep 18 2015, 10:20 PM

Change 239507 merged by Cdentinger:
Parse and send the contribution tracking ID, if available

https://gerrit.wikimedia.org/r/239507

gerritbot added a comment.Sep 18 2015, 11:10 PM

Change 239516 had a related patch set uploaded (by Awight):
One-off script to repair payment audit import

https://gerrit.wikimedia.org/r/239516

awight added a comment.Sep 18 2015, 11:23 PM

Fix to the audit parser is deployed.

The one off script isn't complete yet, we have to build the list of records to repair using tools:sandbox/adamw/201509_paypal_audit over TRR files from 20150828 through 20150918.

awight mentioned this in rWFTOe8013da4caa1: Parse and send the contribution tracking ID, if available.Sep 19 2015, 2:18 AM
awight moved this task from Review to Doing on the Fundraising Sprint Tom Waits board.Sep 19 2015, 5:03 AM
• DStrine moved this task from Triage to Closed Sprint Work Q1 1516 on the Fundraising-Backlog board.Sep 21 2015, 7:00 PM
awight moved this task from Doing to Done on the Fundraising Sprint Tom Waits board.Sep 22 2015, 1:46 AM
awight added a comment.Sep 23 2015, 12:44 AM

Oops, still need to backfill the broken associations with contribution_tracking.

awight moved this task from Done to Doing on the Fundraising Sprint Tom Waits board.Sep 23 2015, 12:45 AM
awight set Security to None.Sep 23 2015, 6:12 PM
awight edited a custom field.
awight moved this task from Doing to Done on the Fundraising Sprint Tom Waits board.Sep 23 2015, 11:46 PM
Pcoombe closed subtask T113503: Backfill missing associations between PayPal audited donations and contribution_tracking as Resolved.Sep 24 2015, 2:54 PM
gerritbot added a comment.Sep 26 2015, 12:21 AM

Change 239516 abandoned by Awight:
One-off script to repair payment audit import

Reason:
ran it by hand.

https://gerrit.wikimedia.org/r/239516

MeganHernandez_WMF subscribed.Sep 28 2015, 2:11 AM

PayPal donations from 9/16 are showing up for me. Thanks!

awight closed this task as Resolved.Sep 28 2015, 5:46 AM

Thank you for the help with this!

• mmodell removed a subscriber: awight.Jun 22 2017, 9:37 PM
• DStrine edited projects, added Fr-tech-archived-from-FY-2015/16; removed Fundraising-Backlog.Jan 11 2018, 9:39 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL