run Gratipay 172

[chadwhitacre]

171

[chadwhitacre]

What's up with ~user review? Are we flubbing tons of money?

[chadwhitacre]

payday.sql definitely still looks at is_suspicious.

[chadwhitacre]

The user review dashboard looks at balanced_customer_href.

[chadwhitacre]

Wellllllllllllllllllllll 💩. :-)

[chadwhitacre]

Okay! Let's get that dashboard updated and review some users!

[chadwhitacre]

In #3790 I mixed in giving and ngiving_to to get an idea of how much money we've been leaving on the table. Very little! Almost all of these 207 have no payment instructions set up, so I'm not sure what's up. Why do they have a braintree_customer_id? How does braintree_customer_id relate to actually have a card on file?

[chadwhitacre]

For today I plan to review just the ones with giving > 0.

[chadwhitacre]

I reviewed a couple more 1.0-payouts that came in since @mattbk took a pass through earlier today.

[chadwhitacre]

Team Review 6

[chadwhitacre]

Well, 9 on GitHub, 6 on the site.

[chadwhitacre]

I've approved ~10 ~users.

[chadwhitacre]

[gratipay] $ heroku config -s | run_dammit /dev/stdin -c ./env/bin/python ./bin/migrate-tips.py
'byebug' already migrated.
Migrated 0 tip(s) for 'detexify'
Migrated 0 tip(s) for 'hamper'
Migrated 0 tip(s) for 'juice-shop'
'knopproject' already migrated.
'konlpy' already migrated.
'md-for-bootstrap' already migrated.
Migrated 0 tip(s) for 'shields'
'pageres' already migrated.
Migrated 0 tip(s) for 'searx'
'org-mode' already migrated.
'magit' already migrated.
'nim' already migrated.
'tabula' already migrated.
'torque3d' already migrated.
'aegirproject' already migrated.
'catapultpgh' already migrated.
Migrated 0 tip(s) for 'meteor-active-route'
Migrated 0 tip(s) for 'openlp'
'svg-js' already migrated.
'zed' already migrated.
'pylonsproject' already migrated.
Migrated 0 tip(s) for 'rtail'
'trakt-for-plex' already migrated.
'rubocop' already migrated.
'davorg' already migrated.
'esdiscuss' already migrated.
'image-optim' already migrated.
'nanoc' already migrated.
'rhombus-tech' already migrated.
Migrated 0 tip(s) for 'tech-store-club'
'ucoin' already migrated.
'wdrl' already migrated.
'cpan-book' already migrated.
'dreditor' already migrated.
'gammu' already migrated.
Migrated 0 tip(s) for 'libravatar'
'northern-plains-athletics' already migrated.
'the-charis-project' already migrated.
'josd' already migrated.
Migrated 0 tip(s) for 'kriasoft'
'sqlalchemy' already migrated.
'webtorrent' already migrated.
'nuvola-player' already migrated.
'simplytest-me' already migrated.
'sailor' already migrated.
'debian-lts-by-freexian' already migrated.
'mojolicious' already migrated.
'teampopong' already migrated.
Migrated 0 tip(s) for 'jeto'
'cpan-io' already migrated.
'cuberite' already migrated.
'devdocs' already migrated.
'doit' already migrated.
'encommuns' already migrated.
'json-resume' already migrated.
'perlweekly' already migrated.
'sudo-room' already migrated.
'exercism' already migrated.
'perl-maven' already migrated.
'pillow' already migrated.
'sudomesh' already migrated.
'the-mountain-spirit' already migrated.
'weblate' already migrated.
'act' already migrated.
'bevry' already migrated.
Migrated 0 tip(s) for 'coala'
Migrated 0 tip(s) for 'kivy'
'citizens-cooperative' already migrated.
Migrated 8 tip(s) for 'grip'
'cider' already migrated.
Migrated 0 tip(s) for 'concrete-clouds'
'cyberpipe' already migrated.
'duo' already migrated.
'gkz-open-source' already migrated.
'introtopython' already migrated.
'Gratipay' already migrated.
'jshttp' already migrated.
Migrated 0 tip(s) for 'matlab-schemer'
Migrated 0 tip(s) for 'neocities'
'pariskiwi' already migrated.
Migrated 0 tip(s) for 'piloting-postdevelopment'
'sublimelinter' already migrated.
'totalism-hackbase' already migrated.
Migrated 1 tip(s) for 'contribkanban-com'
Migrated 3 tip(s) for 'civicrm-lts'
'jsbin' already migrated.
'endless-parentheses' already migrated.
Done.

[chadwhitacre]

Backup started ...

[mattbk]

Dashboard had three people on it, all absorbed, when I looked at it earlier...

Are they able to give, if not approved there?

[chadwhitacre]

@mattbk Yeah, check now that I've deployed gratipay/gratipay.com#3790. ;-)

[chadwhitacre]

Backup done and verified.

[chadwhitacre]

Script started.

[chadwhitacre]

Script ran for a minute (0:01:15.656938).

[chadwhitacre]

Decline rate is 2% (1 / 45).

[chadwhitacre]

=> select count(due), sum(due) from current_payment_instructions where due > 0;
┌───────┬─────────┐
│ count │   sum   │
├───────┼─────────┤
│   792 │ 3890.18 │
└───────┴─────────┘
(1 row)

[chadwhitacre]

=> update exchange_routes set fee_cap=20 where fee_cap is null and network='paypal';
UPDATE 37

[chadwhitacre]

No whammies! No whammies!

[chadwhitacre]

NOOOOOOOoooooooooo.....................!

[techtonik]

What happened?

[chadwhitacre]

Fee cap errors, about a half dozen of them.

[techtonik]

And what is free cap error?

[chadwhitacre]

Got 'em!

MassPay submitted.

[chadwhitacre]

@techtonik Search the repo and/or browse past paydays. It's a common payday error. :-)

[chadwhitacre]

MassPay was ~$5500 today, taking us down to ~22500. I've added another $10,000 to PayPal.

We'll need to be really careful where our money ends up for the refunds.

[chadwhitacre]

Logs uploaded in https://github.com/gratipay/logs/commit/9bc371b680413e458c9416e07b701288e98cf0fa.

[chadwhitacre]

MassPay posted back for 89 ~users. 2 were unclaimed.