OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Subscription management

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Subscription management

Postby pkpsupport » Fri May 18, 2007 3:32 am

Subscription setup is incredibly laborious when you have 30 or more users/institutions and 250 journals

For each and every journal –

An entry in the users table is required

An entry in the roles table marking the user as a reader is required

An entry in the subscriptions table is required

Does anyone have a suggestion to streamline the process, for example by adding data directly into the mysql database.

Thanx
Jacobien
pkpsupport
 
Posts: 16
Joined: Thu Sep 07, 2006 2:26 am
Location: Pretoria

Postby asmecher » Fri May 18, 2007 7:33 am

Hi Jacobien,

We'd like to add an import/export plugin to bring subscription data in from something like an XML sometime in the future; in the meantime, however, you if you have a large number of subscriptions, going to the database is probably the best way.

The database column mappings are fairly direct; is there anything in particular that you'd like clarification with?

Regards,
Alec Smecher
Open Journal Systems Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 8833
Joined: Wed Aug 10, 2005 12:56 pm

Subscription management

Postby pkpsupport » Tue May 22, 2007 6:34 am

Alec

We are going to add the users directly in the database, as you suggested. I see in the users table, that the password is encrypted eg: a4af092a28c7ee841e2cae6ec75229fc. Can the password be added as normal text, eg. northernstar?

Regards,
Jacobien
pkpsupport
 
Posts: 16
Joined: Thu Sep 07, 2006 2:26 am
Location: Pretoria

Postby asmecher » Tue May 22, 2007 9:38 am

Hi Jacobien,

For better security, the password is always stored as a hash -- but you can generate that hash easily in MySQL. For example, to change a username and password:
Code: Select all
UPDATE users SET username='new_username_here', password=MD5(CONCAT('new_username_here', 'new_password_here')) WHERE username='old_username_here';
In this example I'm using MD5 hashing, which is the default -- if you're using SHA1 (check config.inc.php), you can simply use the "SHA1" function instead of "MD5".

The hashed password is an MD5 or SHA1 hash of the concatenation of the username and password.

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 8833
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 8 guests