Dev {Tricks}

You are here: Home / Archives for OJS

by

Crossref Reference Linking and Deposit

As of OJS 3.1.2, it is possible to enable a reference linking plugin for Crossref. This plugin will automatically add the extracted article references to the DOI registration with Crossref. Crossref will then automatically check if any DOIs can be found for the submitted references. Shortly after that, using the scheduled task, the plugin will check for the found references DOIs.

https://github.com/pkp/crossrefReferenceLinking

Installing and Enabling the Plugin

  • Navigate to the user dashboard.
  • Click settings.
  • Click plugins.
  • Click the submenu item plugin gallery.
  • Find the plugin labelled “Crossref Reference Linking Plugin” and click the title.
    If not, upload it by downloading it from GIT.
  • Install the plugin by clicking “install”.
  • Once installed, enable it.

Then

  • Open the submission
  • Go to the Publication tab and References
  • Click Check Crossref DOIs
  • Some DOIs will now be added to the references

For more information on Reference linking, please visit the Crossref website

by

ORCID Public API

ORCID offers a public API that allows organizations (not ORCID members) to connect their systems (website) and applications to the ORCID registry with machine-to-machine communications.

The public API can be used for the following functions:

  • Sign into your system with ORCID
  • Get a user’s verified ORCID iD
  • Retrieve public data from a user’s ORCID record
  • Search public ORCID registry data

Register for a Public API client?

  • Sign into your ORCID record:
    Production server: https://orcid.org/signin
    Sandbox testing server: https://sandbox.orcid.org/signin (recommended to test the API)
  • Click on your name in the top right hand corner
  • Click Developer Tools from the menu option
    Note: In order to access Developer Tools, you must verify your email address. If you have not already verified your email address, you will be prompted to do so at this point.
  • Click the “Register for the free ORCID public API” button
  • Register an application
    • Name: Name of your organization or service (e.g. a journal name).
    • Website: The website the user can visit to learn more about your application.
    • Description: This will be displayed to users on the OAuth screen.
    • Redirect URIs: For testing, you can automatically add Google OAuth Playground URI by clicking “+Google OAuth2 Playground” under Test redirect URIs, or the ORCID Public API Swagger by clicking “+ORCID public swagger interface”. (see About redirect URIs.)
    • Click the Save icon at the bottom of the form to generate your API credentials.
  • To view your API credentials, click Show Details.

Your API credentials – Client ID and Client Secret – are shown just beneath your redirect URIs. Below your credentials are sample URLs and API calls with your credentials pre-filled.

Now that you have your credentials, it’s time to start using the ORCID Public API!

by

DOI (Digital Object Identifier) submission on OJS

DOIs allow URL to be defined for each article. It is a mapping between the DOI and ojs URL.

  • Create Crossref xml file at OJS DOI plugin and save it to your computer.
  • Upload xml from your computer
    https://www.crossref.org/02publishers/parser.html
  • Test uploads login to Crossref (Crossref Login)
    https://test.crossref.org/servlet/useragent

by

How to backup and restore an installation with softaculous; and delete the backups

  • How to Backup an Installation?
  • View backups.
  • Download backups.
  • How to Restore a Backup?
  • How to Delete a Backup?
  • You currently have 2 backups in your account. Your maximum backups limit is 2.

Backup an Installation

  • Go to Softaculous app installer.
  • Click on the app you want to backup. For example, WordPress, Joomla etc.
  • Click on the “Backup Icon” under options of current Installations.

 

Download, Restore, Delete Backups

  • Go to Softaculous app installer.
  • On the top right, you will find “Backups and Restore” icon. Click on it.
  • Now you will get list of backups done earlier.
  • Here you will get Download, Restore and Delete icons.

 

 

 

 

 

by

How to find spam users?

Query to find list of email domains

SELECT substring_index(email, '@', -1) domain, COUNT(*) email_count FROM users GROUP BY substring_index(email, '@', -1) -- If you want to sort as well: ORDER BY email_count DESC, domain;

Query to describe user activity in order to identify suspect users:

select
	u.user_id,
	u.username,
	u.email,
	u.first_name,
	u.middle_name,
	u.last_name,
	u.url,
	u.disabled,
	u.date_registered,
	u.date_validated,
	bit_or(r.role_id) roles,
	count(distinct a.article_id) articles,
	count(distinct e.article_id) editing,
	count(distinct v.review_id) reviews,
	group_concat(b.setting_value ORDER BY b.setting_value separator ' ') biography,
	group_concat(c.body ORDER BY c.body separator ' ') comments,
    group_concat(s.setting_value ORDER BY s.setting_value separator ' ') signature,
	count(distinct c.comment_id) comment_count
from
	users u
	left outer join user_settings b on (u.user_id = b.user_id and b.setting_name = 'biography')
	left outer join user_settings s on (u.user_id = s.user_id and s.setting_name = 'signature')
	left outer join comments c on (u.user_id = c.user_id)
	left outer join roles r on (u.user_id = r.user_id)
	left outer join articles a on (u.user_id = a.user_id and a.status in (1, 3))
	left outer join review_assignments v on (u.user_id = v.reviewer_id)
	left outer join edit_assignments e on (u.user_id = e.editor_id)
group by
	u.user_id,
	u.username,
	u.email,
	u.first_name,
	u.middle_name,
	u.last_name,
	u.url,
	u.disabled,
	u.date_registered,
	u.date_validated;