I am able to access our original OJS2 DB via phpMyAdmin and have extracted our author list (article_authors) as an XML file. Our original site is not otherwise accessible.
Wondering how best to add the data to our new install. Is it safe to import an XML file that has been generated in this way?
I would love to retrieve a reviewer list as well, but that is not as straight-forward. We definitely do NOT want to import all users.
But I have just finished manually adding 16 years of back issues and I would hate to break our new site.
I’m not familiar with the OJS2 XML, but I suspect it will not be compatible. @jnugent, are you at all familiar with what might be involved in working with OJS 2 users XML?
If there isn’t a good way to handle this with the OJS 2 XM, this might be another approach. Since you have access to your database and are interested in getting users/reviewers/authors out, one option would be to create new OJS 3 user XML, and import the users that way.
The University of Alberta Library maintains the repository for a tool to convert User CSV data to OJS Import XML (I’ve recently completed work on it that adds in support for reviewers). You can see the current pull request for these changes on their Github.
Whether or not this is a good approach will depend on how large the number of users is and whether the use of a tool like this would take more time than it saves.
Erik, you’re correct in that the XML from OJS2 won’t be compatible since the schemas are different, all of that information is now localized, etc. I’d also recommend either crafting OJS3 XML for import or looking at the CSV tool you suggested.