HOW-TO: import an issue to OJS.

[pedrocruz]

This is a solution that requires no knowledge of xml based on some posts of OJS Support.

1. Build an import file "issue.xml" like the attachment:

For each article:

* write title
* ignore abstract
* write pages
* write only first author
* write email of first author
* put the filename of pdf file


LIMITATION 1: it's important to use only standard ascii, Otherwise the "importer"
of OJS will stop working without saying exactly why!
If there's a mistake in a xml file it's very difficult to find the location.

LIMITATION 2: filenames must have no spaces or non ascii letters.


2. On "User Home" on OJS system,
choose "import/export",
then "Articles & Issues XML Plugin : Import and export articles and issues"


3. After a sucessful import, one must edit each article "metadata" using OJS
directly.

* as Editor "Future issues" and choose the apropriate issue.

4. Edit information on each article by choosing "EDIT METADATA":

* add authors
* put the abstract: eliminate line feeds, and adapt math notion.
please note that sometimes it's necessary to edit
the abstract in a text editor first!
* put Subject classification
* put language


5. Edit "Issue Data"
and change "title only" and give title.

6. Publish the issue as section editor.


------------sample.xml------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE issue PUBLIC "-//PKP//OJS Articles and Issues XML//EN" "http://pkp.sfu.ca/ojs/dtds/native.dtd">

<issue published="false" current="false">
<title>August 2008, Volume 3, Number A08</title>
<volume>3</volume>
<number>A08</number>
<year>2008</year>

<section>
<title locale="en_US">Articles</title>
<abbrev locale="en_US">ART</abbrev>


<article>
<title>Approximating Counterparts</title>
<abstract>Abstract text...</abstract>
<pages>1-11</pages>
<date_published>2008-08-01</date_published>
<author primary_contact="true">
<firstname>FISTNAME</firstname>
<middlename><![CDATA[ ]]></middlename>
<lastname>LASTNAME</lastname>
<email>email@email</email>
</author>
<galley>
<label>PDF</label>
<file><href mime_type="application/pdf" src="http://...../issue/some.pdf"/></file>
</galley>
</article>


</section>
</issue>

[jmacgreg]

Thanks, Pedrocruz! We'll be starting to collect user-contributed how-tos in the OJS Discussion forum for further discussion, so I've moved this one there.

There are also further instructions on various import/export functions, found in the OJS docs folder:

docs/IMPORTEXPORT

Cheers,
James

[fedrozazueta]

Pedro,

Have you seen http://pkp.sfu.ca/files/ImportingData.pdf?

I have a large number of files to import so I'm interested in some type of DB app that will generate the necessary XML files. Do you know if anything like that is available?

Regards,

Fedro.

[pedrocruz]

Fredo,
my note could help those who don't have XML experience (like me at that time).
During the process I used copy/paste to produce the XML file.
Later I've edit Metada of each article by hand.
Pedro

[svillanueva]

Hello,

i've installed the OJS in our web server. I've tried to import a xml file with the Articles & Issues XML Plugin. With this file, it worked with the testdrive but now, in our own server, it doesn't seem to work, since a blank page appears once I've pushed the button to throw the import process.

The example I've tried is very simple and it's saved in UTF-8:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE issue PUBLIC "-//PKP//OJS Articles and Issues XML//EN" "http://pkp.sfu.ca/ojs/dtds/native.dtd">

<issue published="false" current="false">
<title>August 2008, Volume 3, Number A08</title>
<volume>3</volume>
<number>A08</number>
<year>2008</year>

<section>
<title locale="en_US">Articles</title>
<abbrev locale="en_US">ART</abbrev>


<article>
<title>Approximating Counterparts</title>
<abstract>Abstract text...</abstract>
<pages>1-11</pages>
<date_published>2008-08-01</date_published>
<author primary_contact="true">
<firstname>FISTNAME</firstname>
<middlename><![CDATA[ ]]></middlename>
<lastname>LASTNAME</lastname>
<email>email@email</email>
</author>
<galley>
<label>PDF</label>
<file><href mime_type="application/pdf" src="http://pkp.sfu.ca/files/ImportingData.pdf"/></file>
</galley>
</article>


</section>
</issue>


Do I have to check any server configuration?

Thanks a lot,

Sergi Villanueva.

[jmacgreg]

Hi Sergi,

First, check the FAQ for what do to if you hit a blank page:

viewtopic.php?f=8&t=2481

Please let me know if you're receiving an error, and if you can't find anything to help you on the forums.

Cheers,
James

[svillanueva]

Hi,

Thanks, it was obviously a permissions error, I was sure I had cheched that, but I was wrong

Sorry for the inconvenience.





Regards,

Sergi Villanueva.

[Edemar]

Hi,
We have been importing a lot of the issues from 1991 on.
How can we write the scientific names of animals and plants in italics in the Title box? And how can we can write equations in the abstract box?

Thanks.

Edemar
Co-Editor

[jmacgreg]

Hi Edemar,

You can use limited HTML in the title and abstract boxes, and can also link to images for complex equations in the abstract box if you can't capture a complex equation in HTML. You can control the kinds of HTML that are allowed in these boxes by editing the allowed_html parameter in your config.inc.php file.

Cheers,
James

[vizlipuzli]

How to import multilingual issue to OJS ?
Can I import old articles without authors e-mails ?

[jmacgreg]

Hi Vizilpuzil,

The import process supports multilingual galleys, so you shouldn't have a problem importing in multiple languages. Also, there's a trick to importing old articles where authors don't have email addresses -- just add a space, or possibly <![CDATA[ ]]> within the author email element. You should find more information here:
http://pkp.sfu.ca/wiki/index.php/Import ... XML_Plugin.

Cheers,
James

[vizlipuzli]

Is it possible to indicate author's affiliation (as well as multiple affiliation) in issue XML file?

Code: Select all

<author primary_contact="true">
   <firstname>Jane</firstname>
   <lastname>Doe</lastname>
   <email>JaneDoe@sample.test</email>
   <biography locale="en_US">Jane Doe's  Bio statement...</biography>
   <affiliation>European Molecular Biology Laboratory</affiliation>
   <affiliation>University of Cambridge</affiliation>
</author>

[jmacgreg]

Hi Vizilpuzil,

You can include an author's affiliation, but you can't include multiple affiliation elements -- so if you want to include two affiliations, for example, you would have to do something like:

Code: Select all

<affiliation>affiliation one
affiliation two</affiliation>

Note that any space or line breaks included between the <affiliation> tags will be preserved in the user's affiliation field in their profile. So if you wanted to add a distinct line between each affiliation, you would write the lines like so:

Code: Select all

<affiliation>affiliation one

affiliation two</affiliation>

Cheers,
James