Report of articles sold

Software Support
1

Is there a report somewhere that details the name of an article that was purchased as well as the information of the purchaser? thanks.

2

Hi @radjr,

Could you include the name and version of application you’re using in your posts?

Regards,
Alec Smecher
Public Knowledge Project Team

3

Google Chrome Version 49.0.2623.112 m running on Windows XP. Still the best cleanest UI.

4

Hi @radjr,

I was wondering about which PKP application (I presume OJS), and what version. Including that in your posts will keep the knowledge base usable by others.

Regards,
Alec Smecher
Public Knowledge Project Team

5

Sorry.

OJS 2.4.7.1

Thanks

Richard A. DeVito Jr.
Publisher
Weston Medical Publishing, LLC, 470 Boston Post Road, Suite 301, Weston, MA 02493 USA
radjr@pnpco.com - 781-899-2702 ext. 107 - 781-899-4900 fax
Join us at the 2017 International Conference on Opioids, June 11-13, 2017

6

Hi @radjr,

Try Journal Management > Subscriptions > Payments > Records.

Regards,
Alec Smecher
Public Knowledge Project Team

7

Unfortunately all it does it report gross details and then you have to click to get individual details on each transaction. See below. There needs to be some way to report this out into a CSV file. Thanks.

arspurchase http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/userProfile/1088 Purchase Article 2017-01-17 14:44:46 Details http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/viewPayment/145

litsearchpropha rmagroup http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/userProfile/1096 Purchase Article 2017-01-17 09:38:57 Details http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/viewPayment/144

tridoc http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/userProfile/1133 Purchase Article 2017-01-13 08:58:09 Details http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/viewPayment/143

tridoc http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/userProfile/1133 Purchase Article 2017-01-11 15:35:09 Details http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/viewPayment/142

arspurchase http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/userProfile/1088 Purchase Article 2017-01-09 15:49:47 Details http://www.wmpllc.org/ojs-2.4.2/index.php/jom/manager/viewPayment/141

Richard A. DeVito Jr.
Publisher
Weston Medical Publishing, LLC, 470 Boston Post Road, Suite 301, Weston, MA 02493 USA
radjr@pnpco.com - 781-899-2702 ext. 107 - 781-899-4900 fax
Join us at the 2017 International Conference on Opioids, June 11-13, 2017

8

Hi @radjr,

There’s a subscribers report plugin, but I suspect it won’t be detailed enough – it covers subscribers, but IIRC not payments. Your best bet may be either to extend that to include payments, or to look into the database directly.

Regards,
Alec Smecher
Public Knowledge Project Team

9

Thanks. How would one “extend” that report?

10

This seems to be the path…but the needed fields are not available. “Reach into the database”?

Richard A. DeVito Jr.

11

Hi @radjr,

To extend the plugin, you’d need to modify plugins/reports/subscriptions/SubscriptionReportPlugin.inc.php. The OJSCompletedPaymentDAO provides information about successful payments – see classes/payment/ojs/OJSPaymentAction.inc.php in the viewPayments function to see how that’s used to provide the payments list in the Journal Manager’s interface.

Regards,
Alec Smecher
Public Knowledge Project Team

12

Thanks Alec. Way above my skill level. Something we can contract to OJS to do?

13

Hi @radjr,

Potentially so – feel free to send in a request at https://pkpservices.sfu.ca/content/contact-us. We tend to prioritize things that can be folded back into the application (as open source).

Regards,
Alec Smecher
Public Knowledge Project Team