You are viewing the PKP Support Forum | PKP Home Wiki

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
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

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: 48
Joined: Fri Jan 28, 2005 3:00 am

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.
Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest