Modification to Fredge Report
Closed, ResolvedPublic
Actions

Description

Hello FR Tech team,
Each day we are pulling the Fredge report out of Civi which gives us the fraud scoring data. It would be helpful to include any available email address associated with the stopped transactions in the Fredge report. Can an email address field be added to this report? This would help us reduce the level of investigation around stopped fraud if we could see the email characteristics within the report at this stage in the fraud review.

As an example the email associated with 50970354: CID, Merchant Ref # 102228681.3, 102228523.4 would easily detected a fraud string of transactions which would not have to be investigated individually.

Details

Related Changes in Gerrit:

Subject	Repo	Branch	Lines +/-
Update fredge report to show additional information where civicrm reached	wikimedia/fundraising/crm	master	+492 -439
New fix for 5.41 fails on render template	wikimedia/fundraising/crm	master	+3 -1
Update where join fields in apiv4 call	wikimedia/fundraising/crm	master	+8 -8
Do not call getLanguage if not available	wikimedia/fundraising/crm	master	+1 -0

Customize query in gerrit

Related Objects

Mentioned Here: T287994: Fredge report only lets you export <200 rows

Event Timeline

EMartin created this task.Jun 22 2021, 3:11 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 22 2021, 3:11 PM

• DStrine added a project: Wikimedia-Fundraising-CiviCRM.Jun 22 2021, 4:22 PM

• DStrine moved this task from Triage to Current Sprint on the Fundraising-Backlog board.Jun 22 2021, 7:32 PM

• DStrine added a project: Fundraising Sprint Mandatory corn dogs.Jun 22 2021, 7:42 PM

• DStrine triaged this task as Medium priority.Jun 22 2021, 9:18 PM

@EMartin which is the report you are using - I thought at first it was https://civicrm.wikimedia.org/civicrm/report/instance/110 - but perhaps you are using https://civicrm.wikimedia.org/civicrm/report/wmffraud/fredge?reset=1 with a payment attempt date range?

Hi Eileen,

I'm using
https://civicrm.wikimedia.org/civicrm/report/wmffraud/fredge?reset=1

@EMartin We don't actually store the email for attempted payments - we can include it for successful ones - I'm not sure how far that gets you?

@Eileenmcnaughton we'll take that. It would be good to see emails for successful ones. Thanks

Change 703637 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Update fredge report to show additional information where civicrm reached

https://gerrit.wikimedia.org/r/703637

gerritbot added a project: Patch-For-Review.Jul 8 2021, 5:32 AM

Eileenmcnaughton claimed this task.Jul 12 2021, 7:57 PM

Eileenmcnaughton moved this task from Backlog to Review on the Fundraising Sprint Mandatory corn dogs board.

The above patch is in review - I also put up a PR against master to fix the weird formatting on the filter tab - https://github.com/civicrm/civicrm-core/pull/20784 - but I think we can be relaxed about what happens on that one getting merged. The filter formatting is not a huge issue

• DStrine added a project: fundraising Sprint NULL calorie food cart.Jul 20 2021, 8:22 PM

Eileenmcnaughton moved this task from Backlog to Review on the fundraising Sprint NULL calorie food cart board.Jul 20 2021, 9:57 PM

• DStrine added a project: fundraising sprint onion pit.Aug 3 2021, 8:41 PM

Eileenmcnaughton moved this task from Backlog to Review on the fundraising sprint onion pit board.Aug 4 2021, 12:59 AM

Hi Rakhi, can you get Eileen a file to work with?

Forwarded message ---------

From: Eileenmcnaughton <no-reply@phabricator.wikimedia.org>
Date: Tue, Aug 3, 2021 at 3:59 PM
Subject: [Maniphest] [Commented On] T287994: Fredge report only lets you
export <200 rows
To: Phabricator <no-reply@phabricator.wikimedia.org>
Cc: <emartin@wikimedia.org>

Eileenmcnaughton added a comment. View Task
https://phabricator.wikimedia.org/T287994

@EMartin https://phabricator.wikimedia.org/p/EMartin/ @RKumar_WMF
https://phabricator.wikimedia.org/p/RKumar_WMF/ - I need a file to test
this with so that I can generate the report with more than 200 rows.
Usually Major gifts uploads to the WMF file server & lets me know the path
(it's pretty time consuming for me to get the file but...) - atlhough in
this case it might be fine to share with me using google docs as I expect
it will be a list of ids rather than donor information

*TASK DETAIL*
https://phabricator.wikimedia.org/T287994

*EMAIL PREFERENCES*
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

*To: *Eileenmcnaughton
*Cc: *Eileenmcnaughton, RKumar_WMF, EMartin, DStrine, Aklapper, EBjune

• DStrine added a project: fundraising sprint Parallel processing roller coaster.Aug 17 2021, 8:46 PM

Eileenmcnaughton moved this task from Backlog to Doing on the fundraising sprint Parallel processing roller coaster board.Aug 17 2021, 11:58 PM

Change 713562 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Do not call getLanguage if not available

https://gerrit.wikimedia.org/r/713562

Change 713562 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Do not call getLanguage if not available

https://gerrit.wikimedia.org/r/713562

Change 713573 had a related patch set uploaded (by Eileen; author: Eileen):