Version 1.4.0.0 supports the schema for OJS 3.3. (tested with OJS 3.3.0-14, Aug 2023)
The tool was created for "in-house use" at the Federation of Finnish Learned Societies (https://tsv.fi). It is not pretty. It has not been thoroughly tested, but has been used to import the archives of around 20 journals since 2017. Feel free to use and develop further.
Download and unzip the tsvConverter.
Make sure you can run php from command line.
Go to the tsvConverter folder and install or update dependencies via Composer (https://getcomposer.org/). The conversion tool uses https://github.com/PHPOffice/PhpSpreadsheet for reading sheets.
composer install
Before importing the created data to your production server, you should try to import the data to a test environment to ensure that the created XML files work as expected.
Usage:
php convert.php sheetFilename filesFolderName [-v]
Convert:
php convert.php sheetFilename filesFolderName
Only validate by adding -v:
php convert.php sheetFilename filesFolderName -v
Field | Description | Required | Multilingual Support | |
---|---|---|---|---|
prefix | "The", "A" | x | ||
title | Article title | x | x | |
subTitle | Article subtitle | x | ||
abstract | Article abstract | x | ||
articleSeq | Article sequence inside an issue, first article '1' | x | ||
pages | For example "23-45" | |||
language | Article language "en", "fi", "sv", "de", "fr" | x | ||
keywords | Word 1; Word 2; Word3 | x | ||
disciplines | History; Political science; Astronomy | x | ||
articleCopyrightYear | 2005 | |||
articleCopyrightHolder | "John Doe" | |||
articleLicenseUrl | http://creativecommons.org/licenses/by/4.0 | |||
doi | "10.1234/art.182" |
Field | Description | Required | Multilingual Support |
---|---|---|---|
issueDatepublished | Issue publication date, yyyy-mm-dd. Note! has to be unique for each individual issue. | x | |
issueVolume | Issue volume | ||
issueNumber | Issue number | ||
issueYear | Issue year | x | |
issueTitle | Issue title | x | |
sectionTitle | Section title, eg. "Articles" | x | x |
sectionAbbrev | Section abbreviation, eg. "ART" | x |
An article can have multiple authors or full text files. Every article has to have at least one author and one file.
If an article has for example three authors, the excel file should include columns for each author with the number behind the column name changing. The first name of the third author will be saved to a field called authorFirstname3.
Field | Description | Required | Multilingual Support |
---|---|---|---|
authorFirstname1 | Given name | x | x |
authorMiddlename1 | Middle name | ||
authorLastname1 | Family name | x | |
authorEmail1 | |||
authorAffiliation1 | Affiliation | x | |
country1 | "FI", "SE", "DK", "CA", "US" | ||
orcid1 | Orcid ID, should include "https://". Note that adding Orcid ID's this way is not recommended by Orcid. | ||
authorBio1 | Biography | x |
Field | Description | Required | Multilingual Support |
---|---|---|---|
file1 | Name of the file, "article1.pdf" or url for remote galley | x | |
fileLabel1 | Usually "PDF" | x | x |
fileGenre1 | Usually "Article Text" | x | |
fileLocale1 | "en", "fi" etc. | x |
The new version of the converter supports three different ways of handling locales:
fi - Finnish en - English sv - Swedish fr - French de - German ru - Russian no - Norwegian da - Danish es - Spanish
The conversion tool is distributed under the GNU GPL v3.