XSL to XML : a script for non-XML "speakers"?

Content Registration XML Deposit
,
1

Hello, We deposit our DOIs with CrossRef in two different ways:

  • either via OJS
  • or via the web deposit form.

Filing the deposit form takes time. I would like to save some using XML files in order to avoid completing the DOI several times (if we want a complete DOI that goes beyond simple information on title, author, etc.). But I don’t “speak” XML.

I wonder if there is a script or scripts available to format an excel / calc table into an xml file for CrossRef. Basically: there would be one doi per line in the excel file, with all the information needed for the doi (title, author, orcid, abstract, references, etc.) and a script would generate an xml file from this table. I have already obtained such a script from colleagues, but it doesn’t harvest all the metadata (e.g. abstracts are missing). In short, I wonder if a complete script exists in the crossref community.

Thanks for your help!

2

Hello, and thanks for your question.

That’s not something Crossref has available, because our metadata schema is too large and complex to readily support a conversion from a tabular format. (xml is nested/hierarchical - that makes it very hard to represent with just the two dimensions available in a table)

If it happens that the metadata you’re supplying for your content items is relatively minimal and extremely consistent, it wouldn’t be impossible. And, I believe that there have been some members who have manage to write their own custom conversions from csv to xml. So, I look forward to seeing if anyone can demonstrate that working.

Best,
Shayn