Skip to content
This repository has been archived by the owner on Mar 1, 2021. It is now read-only.

Acquire old PayPal logs #45

Closed
chadwhitacre opened this issue Apr 27, 2017 · 9 comments
Closed

Acquire old PayPal logs #45

chadwhitacre opened this issue Apr 27, 2017 · 9 comments

Comments

@chadwhitacre
Copy link
Contributor

@kaguillera and I contacted PayPal a week or two ago to ask for an export of our old account data. I just called back and it turns out they dropped the ball! They escalated me and I now have an export from the web interface (I had been getting an error previously) that goes back to 2014-04-27, and the L2 rep filed a request for an export from there back through 2012-05-01. That should give us what we need to reconcile PayPal. Supposedly we should see a mail from them inside of 24 hours with a link for an encrypted download of the old data. 👍

@chadwhitacre
Copy link
Contributor Author

Handing off to @kaguillera to split this 3 MB CSV file into one per month:

logs/statements/YYYY/MM/paypal.csv

It has a header row so let's preserve that per-file, and it's sorted by date ascending so let's preserve that as well.

@chadwhitacre
Copy link
Contributor Author

chadwhitacre commented Apr 27, 2017

@kaguillera is thinking that splitting up the file might be a good project for @dmk246. ☺️

@chadwhitacre
Copy link
Contributor Author

Download docs updated in gratipay/inside.gratipay.com#1047 & gratipay/inside.gratipay.com#1048.

@chadwhitacre
Copy link
Contributor Author

@kaguillera
Copy link
Contributor

Was originally waiting do @dmk246 to help me with this but she did not come so I did it. The paypal statements for 2014-04 to 2017-03. The transactions before 2014-04 are still to be delivered by paypal. I should have them tomorrow and I will process them then.

@chadwhitacre
Copy link
Contributor Author

Need to clean up history in the logs repo, see https://github.com/gratipay/logs/commit/794a3556b153b5e1e4aa092c1d448a27a10abdef (we also don't need the noisy merge commits). Revisit gratipay/inside.gratipay.com#1046 following.

@chadwhitacre
Copy link
Contributor Author

We've received the old log and I've handed it off to @kaguillera for processing.

@kaguillera
Copy link
Contributor

I finished splitting up all of the paypal.csv files so we are up to date with our paypal transaction records. We will need to download the paypal.csv for this month next month.
Should I wait to close this when we clean up the little snafoo?

@chadwhitacre
Copy link
Contributor Author

I've rebased the log repo onto https://github.com/gratipay/logs/commit/4b8af978427c02f6b4f74b9924aa1f8f03ba707b to remove merge commits as well as the large files in https://github.com/gratipay/logs/commit/44746abca1786b0f9d5112f12015ebc99ee8524e. Previous head was https://github.com/gratipay/logs/commit/0292ea44cc46126286445f4d74ddf335aeefef66.

cc: @clone1018 @rohitpaulk You will need to refetch before working with logs during your next payday run.

This issue was closed.
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants