Exporting Information to Microsoft SQL automatically

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 48
Joined: Fri Jan 28, 2005 3:00 am

Exporting Information to Microsoft SQL automatically

Postby obeiki » Fri Jan 28, 2005 3:32 am

Hello Dears
We have a database of journal articles and want to install OJS for many journals. Our databse is designed by Dot Net and Microsoft SQL . Can we add journal articles automatically to our database when editors publish a new volume and number? If yes how can we do this?

Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Microsoft SQL automatic dump

Postby ramon » Thu Feb 10, 2005 2:30 pm


First of all, you would have to have an installation of OJS for each journal, as only version 2.0 will be a multiple journal administration. Version 1.1.8 does not manage multiple journals, as you may already know.

What you seem to want is something like what a harvester basically does, which is to use the OAI protocol to collect metadata automatically to its own database.

You may want to look for OAI tools that run on multiple databases and platforms to do what you want. However, most of them implement only OAI-DC or MARC formats. It's been a while, though, so I may be outdated on this matter.

Return to “OJS Editorial Support and Discussion”

Who is online

Users browsing this forum: No registered users and 2 guests