Using EndNote for Data Entry to Create XML File to Submit Articles to Indexing Services/Online Journal System

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 competing_interests (#PCDATA)>
<!ELEMENT biography (#PCDATA)>
    <!ATTLIST biography
        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||MX||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)

I just realized a problem with what I was doing.

If I keep a field for “corresponding author”, then there may be two or more entries in the Authors term list.

The record might be 

Bugs, Bunny|Disney World|Yes|MX||Cartoon Character, Walt Disney

When Bugs Bunny is the corresponding author


Bugs, Bunny|Disney World|No|MX||Cartoon Character, Walt Disney

when he is not.

What’s the best way to designate corresponding author?