| awight | |
| Sep 23 2015, 6:12 PM |
| F2629154: disassociate_bad_paypal_contribution_tracking_20150923.sql | |
| Sep 23 2015, 9:15 PM |
| F2628896: reassociate_paypal_contribution_tracking_20150923.sql | |
| Sep 23 2015, 7:55 PM |
Reassociate donations that came in through the PayPal audit parser with their contribution_tracking entry.
The contribution tracking ID is available in the TRR files. Reprocess donations since Aug 28, when the IPN listener was turned off, cos that's the biggest data hole.
Compile the list of records to repair using tools:sandbox/adamw/201509_paypal_audit, over TRR files from 20150828 through 20150918.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | awight | T112920 Backfill from Aug 25-Sept 17 PayPal audit outage | |||
| Resolved | awight | T113087 PayPal audit parser is not associating donations with the correct contribution_tracking record | |||
| Resolved | awight | T113503 Backfill missing associations between PayPal audited donations and contribution_tracking |
Need one more script--this one removes the ct_id records which were created by the non-associating import.
Should be done now. @MeganHernandez_WMF, can you verify that the 9/16 PayPal results are showing up?
Looks good, they're showing up for me. Thanks Adam!
@MeganHernandez_WMF - I'm updating the data in the Google Docs now, but it doesn't look like there's any big changes in the results.