I’m the assistant editor of an organizational medical journal which has been in print for 30+ years. Recently, the journal has adopted an open access format through Simon Fraser University’s Public Knowledge Project’s Open Journals System software. One of my tasks is to get these thirty years of articles into the system. I wanted to find an easy to use interface to give to a data entry worker (or myself) who would actually update a database from which I would write a program to create the XML file needed to import articles into the Open Journals System (OJS) system.
I had been using Procite since I was a grad student, so I thought that a PC-based bibliographic database program would be useful. Because Procite does not export to XML, I am playing around with EndNote.
The main problem I’m running into is with regards to authors. This is the section of OJS DTD native article format for import regarding author information. I’ve highlighted the fields and attributes that I must have.
<!ELEMENT author (firstname, middlename?, lastname, affiliation?, country?, email, url?, competing_interests*, biography*)>
<!-- One author should be designated as the primary contact for this article. If no author is designated, the first author with an
email address will be used; if multiple authors are designated, the last designated author will be used. The designated author should have a valid email address if possible. →
<!ATTLIST author primary_contact (true|false)“false”>
<!ELEMENT firstname (#PCDATA)>
<!ELEMENT middlename (#PCDATA)>
<!ELEMENT lastname (#PCDATA)>
<!ELEMENT affiliation (#PCDATA)>
<!ELEMENT country (#PCDATA)>
<!ELEMENT email (#PCDATA)>
<!ELEMENT url (#PCDATA)>
<!ELEMENT competing_interests (#PCDATA)>
<!ELEMENT biography (#PCDATA)>
locale CDATA #IMPLIED>
Aside from author,is it possible in EndNote to create a reference type which would create country, e-mail and biography fields which would be optional, repeat one to many times and correspond to the number of authors entered in the author field?
The other idea I had was to add these fields to the actual author line, such as the following:
Bugs, Bunny|Disney World||MXfirstname.lastname@example.org|Cartoon Character, Walt Disney
In this case, I’m using the Unix pipe symbol “|” as a field delimiter.
So the format is
Author Name|Affiliation|corresponding author(Y/N)|country code|e-mail address|Biography
I’ve got some ideas, and writing this helped me think about it. If you have any solutions for me, please post them. I plan to update this thread as I progress.
native.txt (5.15 KB)