Export Payouts to CSV

[Adriano Faria]

This resource will allow admins to export completed payouts to a CSV file. You will notice a DOWNLOAD button at the top to export all payouts according to filters:

• Member who requested the payout
• Staff who processed the payout
• Date range

Payout info exported:

• ID
• Status
• Member ID (member who requested the payout)
• Member Name (member who requested the payout)
• Amount
• Requested On (date)
• Completed On (date)
• Currency
• Member ID (staff who processed the payout)
• Member Name (staff who processed the payout)

 

 

[SJ77]

tried it

got error

OutOfRangeException:  (0)
#0 /mysite/forum/applications/nexus/sources/Payout/Payout.php(179): IPS\nexus\_Customer::load(51641)
#1 /mysite/forum/system/Patterns/ActiveRecord.php(307): IPS\nexus\_Payout->get_member()
#2 /mysite/forum/init.php(448) : eval()'d code(99): IPS\Patterns\_ActiveRecord->__get('member')
#3 /mysite/forum/system/Dispatcher/Controller.php(85): IPS\nexus\modules\admin\payments\hook1156->exportToCSV()
#4 /mysite/forum/applications/nexus/modules/admin/payments/payouts.php(34): IPS\Dispatcher\_Controller->execute()
#5 /mysite/forum/system/Dispatcher/Dispatcher.php(146): IPS\nexus\modules\admin\payments\_payouts->execute()
#6 /mysite/forum/admin/index.php(13): IPS\_Dispatcher->run()
#7 {main}

 

[Dean_]

-Edit, ignore lol.

[Adriano Faria]

8 hours ago, superj707 said:

tried it

How you used it? All fields blank? Filled which one?

EDIT: it isn't field; mine works filling no field. It will export all payouts. It is something in a customer record.

EDIT2: I've sent you a PM with a new version to check customer data.

[Adriano Faria]

Compatible with IPS 4.4.

[Adriano Faria]

What's New in Version 1.0.1:

• Fix error when the export list has a deleted member

[SJ77]

Hi @Adriano Faria

Please add one more column to this "po_gateway"

It's in the same table that you're already pulling from.  I really need it.

It matters a lot for me when using this plugin to prepare my taxes.

Can you help?

Thank you so much!!!

[Adriano Faria]

4 hours ago, SJ77 said:

Hi @Adriano Faria

Please add one more column to this "po_gateway"

It's in the same table that you're already pulling from.  I really need it.

It matters a lot for me when using this plugin to prepare my taxes.

Can you help?

Thank you so much!!!

Sorry, this is not a custom job. I can’t add things that will fit only your needs. I already added some columns from Downloads to you. They’re commented in the script.

As you have some dev skills, download the XML, add your column, save and reinstall. I have a ton of things to do due to Black Friday and I really won’t stop to add/change things that really can wait.

[SJ77]

Why wouldn’t this benefit everyone? It’s an important data point to know where/how the payout happened.

Why doesn’t this export everything in the payout table already?