Migrating from legacy database to OJS

Software Support
1

I am currently in process of migrating old database to use OJS and there are few question regarding it.
I am doing the migration by dumping the old database to xml and then using xslt to transform it to importexport plugins schema.
There are few odd things in the schema:

  • File size and type seems to be required for the file. Why are they? Shouldn’t they be easily calculated by the plugin?
  • user_group_ref seems to be also required. Why is it required? What value I should give it?

There is also problem in that some of the published dates are missing in the old database and only the year of publication is known. Is it okay to have those as year-00-00?
It also seems that you cannot use that schema to add DOIs or keywords, right?

2

I tried to import articles with my current XML, but it seems importexport plugin is completely busted (at least in current master):
Element 'articles': No matching global declaration available for the validation root.
I wont include the xml converted from database here as it’s 1,23 MB.

I also tried to export test article with the plugin and the import it with no avail:

Namespace prefix xsi for schemaLocation on article is not defined
Namespace prefix xsi for schemaLocation on authors is not defined
Namespace prefix xsi for schemaLocation on submission_file is not defined
Namespace prefix xsi for schemaLocation on submission_file is not defined
Element 'article': No matching global declaration available for the validation root.

The output of the test article export was:
<article locale="en_US" date_submitted="2016-08-29" stage="production" date_published="2016-08-29" section_ref="ART" seq="1" access_status="0" xsi:schemaLocation="http://pkp.sfu.ca/native.xsd"> <id type="internal" advice="ignore">1</id> <title locale="en_US">asdasd</title> <prefix locale="en_US">asd</prefix> <subtitle locale="en_US">sadasdas</subtitle> <abstract locale="en_US"> <p>asasdasd</p> </abstract> <type locale="en_US">sadasd</type> <comments_to_editor> <p>Lol</p> </comments_to_editor> <authors xsi:schemaLocation="http://pkp.sfu.ca native.xsd"> <author primary_contact="true" include_in_browse="true" user_group_ref="Journal manager"> <firstname>minad</firstname> <lastname/> <email>ad@mi.nasd</email> </author> </authors> <submission_file stage="submission" id="1" xsi:schemaLocation="http://pkp.sfu.ca native.xsd"> <revision number="1" genre="Article Text" filename="test.txt" viewable="true" date_uploaded="2016-08-29" date_modified="2016-08-29" filesize="0" filetype="text/plain" user_group_ref="Journal manager" uploader="minad"> <name locale="en_US">minad, Journal manager, test.txt</name> <embed encoding="base64"></embed> </revision> </submission_file> <submission_file stage="final" id="2" xsi:schemaLocation="http://pkp.sfu.ca native.xsd"> <revision number="1" source="1-1" genre="Article Text" filename="test.txt" viewable="true" date_uploaded="2016-08-29" date_modified="2016-08-29" filesize="0" filetype="text/plain" user_group_ref="Journal manager" uploader="minad"> <name locale="en_US">minad, Journal manager, test.txt</name> <embed encoding="base64"></embed> </revision> </submission_file> </article>

3

Hi @WaDelma,

Is this the same issue you’ve been tracking in a Git issue? If so, could you drop a link here?

Thanks,
Alec Smecher
Public Knowledge Project Team

4

Relevant issues:

1 Like