run Gratipay 192

[clone1018]

191

[clone1018]

Not admin enough to view https://gratipay.com/dashboard/ going to see if I can set my own flag

[clone1018]

Ran update participants set is_admin=true where username = 'clone1018' on production

[clone1018]

A big list, I'm going to check mostly people with amounts

[clone1018]

Approved 6 accounts

[clone1018]

Approved 2 on https://gratipay.com/dashboard/1.0-payouts

[clone1018]

Violations ticket at https://github.com/gratipay/violations/issues/25

[rohitpaulk]

Someone's early...

[clone1018]

Starting the review early :), just now setting up gratipay locally

[clone1018]

Let's do this!

[clone1018]

$ cat migrate-tips.log
Done.

[clone1018]

I'm assuming run bin/snapper.py locally? Doing that.

[clone1018]

Backup completed and verified.

[clone1018]

I can't tell if I run payday locally or on heroku?

On latest master: ./payday.sh NNN for_real_please. Answer yes at the prompts. It wants to log into a ../logs/paydays directory.

[clone1018]

@rohitpaulk ^

[rohitpaulk]

I can't tell if I run payday locally or on heroku?

Locally. It should pull config from heroku on its own and use the remote db

[clone1018]

ok it looks like locally

[clone1018]

Awesome thanks @rohitpaulk

[clone1018]

Here we go! Payday is off and running.

[clone1018]

Script ran for three minutes (0:03:30.678415).

[rohitpaulk]

🍻

[clone1018]

just got this error running masspay.sh

Traceback (most recent call last):
  File "./bin/masspay.py", line 286, in <module>
    main()
  File "./bin/masspay.py", line 279, in main
    compute_output_csvs()
  File "./bin/masspay.py", line 152, in compute_output_csvs
    payees = [Payee(rec) for rec in csv.reader(open(INPUT_CSV))]
  File "./bin/masspay.py", line 65, in __init__
    self.fee_cap = D(fee_cap)
  File "/usr/lib64/python2.7/decimal.py", line 547, in __new__
    "Invalid literal for Decimal: %r" % value)
  File "/usr/lib64/python2.7/decimal.py", line 3873, in _raise_error
    raise error(explanation)
decimal.InvalidOperation: Invalid literal for Decimal: ''

[rohitpaulk]

#485 (comment)

[clone1018]

you manually updated the input file @rohitpaulk ?

[clone1018]

also I dont have any null, just None

[rohitpaulk]

I updated the values in the DB directly, and then regenerated the input file

[rohitpaulk]

I think python reads NULL from the DB and spits out None when asked for a string representation

[clone1018]

So am I doing something like update exchange_routes set fee_cap = 20.00 where fee_cap is null and network = 'paypal' and address = 'address from output'; @rohitpaulk

[rohitpaulk]

Yep, that should work..

[rohitpaulk]

All good, @clone1018?

[rohitpaulk]

Yep, I think that'd work

[clone1018]

I don't understand what I'm doing here anymore, so I isolated those three users I updated and uploaded their csv to get the fee, but where do I get Gratipay's fee now? Should I be uploading each user manually to calculate the fee and then updating some field? Also paticipants.paypal_fee_cap doesn't exist anymore?

[rohitpaulk]

but where do I get Gratipay's fee now?

One of those csv files should have a column for fees, I'm not sure which. Use the sum of that column for the estimated fees.

Should I be uploading each user manually to calculate the fee and then updating some field?

That is one way to do it :P What I think we should do is eliminate those users one by one, until Gratipay and Paypal fees match.

Also paticipants.paypal_fee_cap doesn't exist anymore?

No, it is now set on exchange_routes. You did an update on that column like an hour ago 😛

[rohitpaulk]

@clone1018 - It's pretty late here, I've gotta crash. I'll check back in the morning :)

[clone1018]

Sure, thanks @rohitpaulk.

[chadwhitacre]

/me steps in as copilot? ✈️

[clone1018]

Sure, juggling work and this right now I'll be free in a bit

[chadwhitacre]

!m @clone1018 @rohitpaulk

[clone1018]

Whew found the user off 97 cents. I'm assuming I update their feecap to the correct amount? This doesn't make sense to me so I'm going to play with it until masspay gives me the correct answer :)

[clone1018]

Ran update exchange_routes set fee_cap = 1.00 where address = 'THEUSER';

[clone1018]

Got correct values in masspay!

[chadwhitacre]

!m @clone1018

[clone1018]

MassPay done and posted back for 48 users.

[clone1018]

Can't find logins for Braintree either?

[clone1018]

MassPay https://github.com/gratipay/logs/commit/aa88e7f046d137bb653945efeb5ca5b0376d425b
Payday https://github.com/gratipay/logs/commit/dfc486287918efc4af5b0e9243443acd3e41f554

[clone1018]

I have to finish the following after I get some help with Braintree access:

1. Shuffle escrow.
2. Review the card decline rate in the Braintree dashboard. If it's 15% or greater, find a reason and report it to [email protected].
3. Review and edit these documents.
4. Close the ticket from step 2.

[rohitpaulk]

!m @clone1018

[chadwhitacre]

/me goes back to barely paying attention. :-)

[clone1018]

[clone1018]

Decline rate = 8.824%

[clone1018]

1396 * 5 = 6980, current balance in Paypal is 6939, so no topping up necessary?

[clone1018]

Done!

[chadwhitacre]

!m @clone1018 @rohitpaulk

So exciting! 😻

[chadwhitacre]

Any explanation for the stronger-than-usual volume this week? Did we have a rash of dues come due?

[rohitpaulk]

@clone1018's magic touch 😛

[chadwhitacre]

💃