Custom Word Macro available to recover Zotero references from footnotes

stephenhbyoung

A colleague lost her zotero database for her PhD due to a hard drive crash, but had zotero rererences in footnotes in number of chapters already written. I wrote a Word add in to generate a RIS file from the field codes in the footnotes. I am happy to share this if anyone wants it. email me stephenhbyoung@gmail.com

Rintze

How did you generate the RIS? By parsing the JSON in the embedded metadata?

(I recently wrote a web tool to extract CSL JSON from .docx Word documents with embedded Zotero and/or Mendeley citations, which can then be reimported into Zotero: http://rintze.zelle.me/ref-extractor/ )

stephenhbyoung

Yes I parsed the metadata embedded in the field code tagged as ItemData e.g. "itemData":{"id":83,"type":"article-newspaper","title":"Fears of lasting harm to body ended hunger strike","container-title":"Sydney Morning Herald","URL":"http://www.smh.com.au","shortTitle":"Fears of lasting harm to body ended hunger strike","author":[{"family":"Arup","given":"Tom"},{"family":"Reilly","given":"Tom"}],"issued":{"date-parts":[["2010",1,15]]}}}

And then wrote a text file formatted according to RIS.

(this is in VBA hosted from MS Word)