Wed, Jul 11
Jun 12 2018
Jun 5 2018
Jun 4 2018
May 30 2018
May 29 2018
May 25 2018
Cancellations and refunds have been done, everything ran as expected.
@MBeat33 Looks like about 641 donors in this round.
Works for me.
May 24 2018
Tomorrow would technically violate our No Friday Deploy policy, but it's such a tiny and safe deploy that I'm happy to do it anyway. Tuesday would be fine as well if that works better for folks. Tomorrow after 10:30ish Pacific or anytime on Tuesday would work for me.
May 23 2018
May 22 2018
I've added B1718_120218_en6C_ipd_p1_lg_frm_cnt.no-LP.rcc to the current batch and rerun the queries for GC. Updated files are on frdev.
May 14 2018
The email lists and transaction lists for both GC and PayPal have been generated and are in the tmp folder on frdev.
May 11 2018
May 10 2018
Apr 26 2018
Apr 25 2018
@mepps @MBeat33 Ok, it looks like cid=23929416 didn't make it into the refund batch because it doesn't appear to be a recurring type, but rather a one-time GC donation. I reran the queries I used to generate the email lists and that donor doesn't come up in those either, so I'm not sure how he snuck into the email list.
Apr 24 2018
@MBeat33 Can you write up a new ticket for that batch? We've got a lot of balls in the air in the current sprint, and it'll get more attention as its own ticket.
@mepps The logs weren't that specific that I could see, the refund function just reported a failure, then later in the logs there were successful attempts. I suspect timeouts or hiccups Ingenico side, but that's just a guess.
@mepps Actually that one weirdly doesn't turn up in the logs anywhere outside of the initial transaction. That said, in my searches I did come across a handful of other failures from the script, but they all eventually had successful refunds one way or another. There might be more phantoms out there, but there'd be no way to track them down that I can think of.
Apr 19 2018
Apr 18 2018
Everything I can find looks resolved. I'll go ahead and close.
10-4 I'll see what I can find out.
Apr 6 2018
@MBeat33 I'll poke around and see what I can find, but I think @mepps was the one who actually ran the PayPal side of things. She probably knows more than I do. We can check with her Monday morning if I don't find anything.
This was in the batch, and the email was included in the list of subscriptions to cancel. Maybe PayPal didn't get them all?
Apr 3 2018
@CCogdill_WMF @MBeat33 I'm not online quite that early tomorrow and it's a slightly manual process. I think @Ejegg and @mepps will be due to favorable time zones, but I don't want to speak for them. If you want to ping them in the morning that might work.
@CCogdill_WMF Yea, we should be able to fire off the script at or about a certain time. I seem to recall it took a while finish last time, but not more than a couple of hours I don't think.
PayPal transaction list is fixed, new file is on frdev.
Apr 2 2018
GC side is complete. Subscriptions have been canceled and transactions refunded.
@CCogdill_WMF We should have the GlobalCollect side ready to refund in the next hour or so. The PayPal side is going to take a little bit more adjustment due to the long time range covered this time, but I'll keep you posted on that.
Mar 29 2018
Although now that I think about it, with the holiday tomorrow, it's functionally Friday today so we might not want to push the refunds today anyway. We're not quite in danger of any of them falling off the six-month edge quite yet.
@Ejegg I've just addressed the issue you noticed before with some of the early recurrences being missing. The new file is on frdev if you get a chance to work your magic on it, else I'll try to do that myself today.
Mar 28 2018
GC subscriptions have been canceled. We won't see any more recurrences. Working on getting the refund list ready to run.
@CCogdill_WMF GC cancellations will probably happen today, but that process is invisible to donors. Looks like @Ejegg found an issue with the refund list so that'll take some work before it's ready. I'll know more once I dig in a little deeper.
Mar 27 2018
That patch is the one to run the query that cancels the GC subscriptions.
Files with the affected emails and transactions to be refunded are on frdev now. @Ejegg will need to work his magic on the GC transactions before we can run the refund script.
I'll start generating the list of emails and transactions.
Since this round seems complete, I'm going to go ahead and mark this task done. If we end up wanting to do another round, we can track that under a new ticket.
Mar 22 2018
@MBeat33 With the new banner list, looks like we get 2109 donors with active recurring subscriptions from that time range and those banners. 1074 of them are from Ingenico, the rest would be PayPal.
Mar 20 2018
Mar 16 2018
Mentioned in IRC but posting here for completeness: The transactions were missing from the refund list due to the subscriptions being canceled shortly before the query was run. I've fixed the query to account for that, and a new refund list is ready to be run.
Mar 15 2018
@MBeat33 Statuses on the GC cancellations should be updated now.
@MBeat33 I'll take a look at that today and let you know. I'm 95% sure everything is canceled, but I'll double check to be certain.
Mar 13 2018
GC subscriptions have been canceled. Still planning on issuing the refunds tomorrow as discussed.
Mar 6 2018
Mar 5 2018
Our current Adyen integration is currently only set up to handle credit card donations, so there would be some work necessary to expand it to handle bank transfers like iDEAL. On the Adyen side, it looks like iDEAL is necessarily a multi-page flow, so there would be significant CSS work and iframe configuration necessary to get things to match our style.
Mar 2 2018
@mepps fields should be order_id, gateway_txn_id, subscr_id, then currency and now amount, but let me know if any of those don't look like what you were expecting or aren't working.
Mar 1 2018
Feb 28 2018
Feb 27 2018
Feb 22 2018
I have a query that will generate the spreadsheet for PayPal batch refund and subscription cancellation.
Feb 16 2018
@mepps As discussed in standup, yea my intent is to pull transactions in need of refund.
Feb 15 2018
Feb 14 2018
@MBeat33 Yep, it's a database query, so it'll be easy enough to re-pull the list just before we fire off any batch processes and avoid unnecessary emails to donors.
Feb 12 2018
@MBeat33 I've got a list of what I believe to be affected email addresses who's recurring subscriptions are non-canceled. If you'd like to check that against what you have on the situation, let me know what the best way to get that list to you is.
Feb 7 2018
Looks like Ejegg got to this last sprint, but looks good to me as well.