We are setting up a new journal using OJS3, and have >50 issues and >800+ articles from the past 10+ years to upload.
I am seeking help to define the correct process for 1) creating a CSV structure that contains the right metadata, 2) how to convert this to an XML file ready for upload 3) how to upload these in bulk to the new journal so that the articles also are allocated a DOI and have appropriately mapped metadata.
I can see the general guidance in OJS documentation for import/export however I’m new to this system and so am looking to consult an expert for further assistance. Thanks all!
We’ve found it can be quite difficult depending on where they are coming from and have to employ a few strategies to get it right including custom scripts etc. Depending if you’re comfortable with scripting, you may be able to also script something to transform what you have into a workable format.
CSVs can be quite hard especially if you need galleys, and other related metadata whereas XML can express these within the format easier.
Note if you use the built-in XML importer you have to make sure everything is in the correct order, and the correct amount. We struggled, and so have other third parties we worked with.
You may find it useful to get roughly the XML right, and in a test copy of OJS, try it with the official importer and if you get stuck we build our own importer using OJS’s XML format that’s a lot more lax with requirements (not as well coded but it works for our purposes) GitHub - oiccpress/simplexml: [wip] OJS plugin to provide a simpler XML import from external sources · GitHub
Thank you for your message, and link to your GitHub. I’m keen to explore and troubleshoot but I don’t have the time or knowledge needed to be efficient I’m afraid. Does InvisibleDragon offer service for hire or can you recommend someone we can potentially engage with aw a contractor to help us with this project?
You may have a look at GitHub - ajnyga/tsvConverter: Excel to OJS3 XML conversion tool · GitHub which does exactly what you need.
With some adaptions, I had imported more than 6000 articles and more than 400 issues.
Thank you for your help - this looks like a great tool I appreciate the share.