search

rmzelle / ref-extractor

Reference Extractor - Extract Zotero/Mendeley references from Microsoft Word files
https://rintze.zelle.me/ref-extractor/
MIT License
318 stars 18 forks source link

Mendeley Cite (new Word plugin) compatibility #39

Open psobolewskiPhD opened 3 years ago

psobolewskiPhD commented 3 years ago

References inserted in the new MS Word (365) using the new Mendeley Cite plugin do not appear to be extractable. Here's a test file made on Mac OS 11.5.2, Word 16.52, Mendeley Cite 1.33.2 test_ref.docx

rmzelle commented 3 years ago

@psobolewskiPhD, thanks! It looks like this program stores the citation metadata in a different way. I have little time for open source nowadays, so I can't offer a quick fix.

In case somebody else wishes to work on this:

It looks like Mendeley Cite (a separate tool from Mendeley Desktop; see https://www.mendeley.com/reference-management/mendeley-cite) still stores item metadata in CSL JSON, but not in Mendeley Desktop's typical fashion. The embedded item metadata for Mendeley Cite Word documents can be found by extracting the .docx file above, and reading the word/webextensions/webextension1.xml file (here the contents after reindenting with https://www.freeformatter.com/xml-formatter.html and unescaping with https://www.freeformatter.com/html-escape.html):

<?xml version="1.0" encoding="UTF-8"?>
<we:webextension xmlns:we="http://schemas.microsoft.com/office/webextensions/webextension/2010/11" id="{1629F4A7-E299-1746-8737-A7C8EE395DE0}">
   <we:reference id="f78a3046-9e99-4300-aa2b-5814002b01a2" version="1.28.0.0" store="EXCatalog" storeType="EXCatalog" />
   <we:alternateReferences>
      <we:reference id="WA104382081" version="1.28.0.0" store="pl-PL" storeType="OMEX" />
   </we:alternateReferences>
   <we:properties>
      <we:property name="MENDELEY_CITATIONS" value="[{"citationID":"MENDELEY_CITATION_ad45ebab-9586-43de-afcb-d61c125265eb","citationItems":[{"id":"f2b99245-f06e-3336-94ac-63beadc04d1c","itemData":{"type":"article-journal","id":"f2b99245-f06e-3336-94ac-63beadc04d1c","title":"A Convenient and Efficient Centrifugation Assay for Comparing Cell Adhesion Strength on Uncharted Surfaces","author":[{"family":"Zhou","given":"Xuan","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"Zhou","given":"Xin","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"Du","given":"Yichen","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"Shi","given":"Xiaohua","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"You","given":"Pan","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"Chen","given":"Tao","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"Fan","given":"Dongli","parse-names":false,"dropping-particle":"","non-dropping-particle":""},{"family":"Zhang","given":"Yiming","parse-names":false,"dropping-particle":"","non-dropping-particle":""}],"container-title":"Journal of Biomaterials and Tissue Engineering","DOI":"10.1166/jbt.2020.2285","ISSN":"2157-9083","URL":"https://www.ingentaconnect.com/content/10.1166/jbt.2020.2285","issued":{"date-parts":[[2020,4,1]]},"page":"462-468","abstract":"Regulating cell-substrate adhesion is of fundamental importance in biomaterial design and development. While an increasing number of approaches are being developed to quantify cell adhesion strength, only a fraction of these techniques provide measurements that are simple and sensitive at the living cell population level. In our previous study, the expression of adhesion-associated proteins in fibroblasts was found to change on ion-implanted silicone rubber; however, the actual effects of the modified surfaces on cellular mechanical properties remain to be probed. Here, we proposed a convenient method to compare the cell adhesion strength on various surfaces, for multiple adhesion periods and with different cell types. This method requires only common laboratory equipment. In addition, we introduced a new parameter, ECS 50 , which is appropriate for screening optimum centrifugal conditions when the cell affinity of the surface as a control is initially unknown. This parameter is helpful for further exploration of cell affinity on all the biomaterials of interest. The results demonstrate that this centrifugation assay is simple, efficient and adaptable in investigating the overall adhesion strength of living cells under various conditions, and therefore, it is a valid way to develop adhesion-controlled biointerface materials in the future.","issue":"4","volume":"10"},"isTemporary":false}],"properties":{"noteIndex":0},"isEdited":false,"manualOverride":{"isManuallyOverridden":false,"citeprocText":"(1)","manualOverrideText":""},"citationTag":"MENDELEY_CITATION_v3_eyJjaXRhdGlvbklEIjoiTUVOREVMRVlfQ0lUQVRJT05fYWQ0NWViYWItOTU4Ni00M2RlLWFmY2ItZDYxYzEyNTI2NWViIiwiY2l0YXRpb25JdGVtcyI6W3siaWQiOiJmMmI5OTI0NS1mMDZlLTMzMzYtOTRhYy02M2JlYWRjMDRkMWMiLCJpdGVtRGF0YSI6eyJ0eXBlIjoiYXJ0aWNsZS1qb3VybmFsIiwiaWQiOiJmMmI5OTI0NS1mMDZlLTMzMzYtOTRhYy02M2JlYWRjMDRkMWMiLCJ0aXRsZSI6IkEgQ29udmVuaWVudCBhbmQgRWZmaWNpZW50IENlbnRyaWZ1Z2F0aW9uIEFzc2F5IGZvciBDb21wYXJpbmcgQ2VsbCBBZGhlc2lvbiBTdHJlbmd0aCBvbiBVbmNoYXJ0ZWQgU3VyZmFjZXMiLCJhdXRob3IiOlt7ImZhbWlseSI6Ilpob3UiLCJnaXZlbiI6Ilh1YW4iLCJwYXJzZS1uYW1lcyI6ZmFsc2UsImRyb3BwaW5nLXBhcnRpY2xlIjoiIiwibm9uLWRyb3BwaW5nLXBhcnRpY2xlIjoiIn0seyJmYW1pbHkiOiJaaG91IiwiZ2l2ZW4iOiJYaW4iLCJwYXJzZS1uYW1lcyI6ZmFsc2UsImRyb3BwaW5nLXBhcnRpY2xlIjoiIiwibm9uLWRyb3BwaW5nLXBhcnRpY2xlIjoiIn0seyJmYW1pbHkiOiJEdSIsImdpdmVuIjoiWWljaGVuIiwicGFyc2UtbmFtZXMiOmZhbHNlLCJkcm9wcGluZy1wYXJ0aWNsZSI6IiIsIm5vbi1kcm9wcGluZy1wYXJ0aWNsZSI6IiJ9LHsiZmFtaWx5IjoiU2hpIiwiZ2l2ZW4iOiJYaWFvaHVhIiwicGFyc2UtbmFtZXMiOmZhbHNlLCJkcm9wcGluZy1wYXJ0aWNsZSI6IiIsIm5vbi1kcm9wcGluZy1wYXJ0aWNsZSI6IiJ9LHsiZmFtaWx5IjoiWW91IiwiZ2l2ZW4iOiJQYW4iLCJwYXJzZS1uYW1lcyI6ZmFsc2UsImRyb3BwaW5nLXBhcnRpY2xlIjoiIiwibm9uLWRyb3BwaW5nLXBhcnRpY2xlIjoiIn0seyJmYW1pbHkiOiJDaGVuIiwiZ2l2ZW4iOiJUYW8iLCJwYXJzZS1uYW1lcyI6ZmFsc2UsImRyb3BwaW5nLXBhcnRpY2xlIjoiIiwibm9uLWRyb3BwaW5nLXBhcnRpY2xlIjoiIn0seyJmYW1pbHkiOiJGYW4iLCJnaXZlbiI6IkRvbmdsaSIsInBhcnNlLW5hbWVzIjpmYWxzZSwiZHJvcHBpbmctcGFydGljbGUiOiIiLCJub24tZHJvcHBpbmctcGFydGljbGUiOiIifSx7ImZhbWlseSI6IlpoYW5nIiwiZ2l2ZW4iOiJZaW1pbmciLCJwYXJzZS1uYW1lcyI6ZmFsc2UsImRyb3BwaW5nLXBhcnRpY2xlIjoiIiwibm9uLWRyb3BwaW5nLXBhcnRpY2xlIjoiIn1dLCJjb250YWluZXItdGl0bGUiOiJKb3VybmFsIG9mIEJpb21hdGVyaWFscyBhbmQgVGlzc3VlIEVuZ2luZWVyaW5nIiwiRE9JIjoiMTAuMTE2Ni9qYnQuMjAyMC4yMjg1IiwiSVNTTiI6IjIxNTctOTA4MyIsIlVSTCI6Imh0dHBzOi8vd3d3LmluZ2VudGFjb25uZWN0LmNvbS9jb250ZW50LzEwLjExNjYvamJ0LjIwMjAuMjI4NSIsImlzc3VlZCI6eyJkYXRlLXBhcnRzIjpbWzIwMjAsNCwxXV19LCJwYWdlIjoiNDYyLTQ2OCIsImFic3RyYWN0IjoiUmVndWxhdGluZyBjZWxsLXN1YnN0cmF0ZSBhZGhlc2lvbiBpcyBvZiBmdW5kYW1lbnRhbCBpbXBvcnRhbmNlIGluIGJpb21hdGVyaWFsIGRlc2lnbiBhbmQgZGV2ZWxvcG1lbnQuIFdoaWxlIGFuIGluY3JlYXNpbmcgbnVtYmVyIG9mIGFwcHJvYWNoZXMgYXJlIGJlaW5nIGRldmVsb3BlZCB0byBxdWFudGlmeSBjZWxsIGFkaGVzaW9uIHN0cmVuZ3RoLCBvbmx5IGEgZnJhY3Rpb24gb2YgdGhlc2UgdGVjaG5pcXVlcyBwcm92aWRlIG1lYXN1cmVtZW50cyB0aGF0IGFyZSBzaW1wbGUgYW5kIHNlbnNpdGl2ZSBhdCB0aGUgbGl2aW5nIGNlbGwgcG9wdWxhdGlvbiBsZXZlbC4gSW4gb3VyIHByZXZpb3VzIHN0dWR5LCB0aGUgZXhwcmVzc2lvbiBvZiBhZGhlc2lvbi1hc3NvY2lhdGVkIHByb3RlaW5zIGluIGZpYnJvYmxhc3RzIHdhcyBmb3VuZCB0byBjaGFuZ2Ugb24gaW9uLWltcGxhbnRlZCBzaWxpY29uZSBydWJiZXI7IGhvd2V2ZXIsIHRoZSBhY3R1YWwgZWZmZWN0cyBvZiB0aGUgbW9kaWZpZWQgc3VyZmFjZXMgb24gY2VsbHVsYXIgbWVjaGFuaWNhbCBwcm9wZXJ0aWVzIHJlbWFpbiB0byBiZSBwcm9iZWQuIEhlcmUsIHdlIHByb3Bvc2VkIGEgY29udmVuaWVudCBtZXRob2QgdG8gY29tcGFyZSB0aGUgY2VsbCBhZGhlc2lvbiBzdHJlbmd0aCBvbiB2YXJpb3VzIHN1cmZhY2VzLCBmb3IgbXVsdGlwbGUgYWRoZXNpb24gcGVyaW9kcyBhbmQgd2l0aCBkaWZmZXJlbnQgY2VsbCB0eXBlcy4gVGhpcyBtZXRob2QgcmVxdWlyZXMgb25seSBjb21tb24gbGFib3JhdG9yeSBlcXVpcG1lbnQuIEluIGFkZGl0aW9uLCB3ZSBpbnRyb2R1Y2VkIGEgbmV3IHBhcmFtZXRlciwgRUNTIDUwICwgd2hpY2ggaXMgYXBwcm9wcmlhdGUgZm9yIHNjcmVlbmluZyBvcHRpbXVtIGNlbnRyaWZ1Z2FsIGNvbmRpdGlvbnMgd2hlbiB0aGUgY2VsbCBhZmZpbml0eSBvZiB0aGUgc3VyZmFjZSBhcyBhIGNvbnRyb2wgaXMgaW5pdGlhbGx5IHVua25vd24uIFRoaXMgcGFyYW1ldGVyIGlzIGhlbHBmdWwgZm9yIGZ1cnRoZXIgZXhwbG9yYXRpb24gb2YgY2VsbCBhZmZpbml0eSBvbiBhbGwgdGhlIGJpb21hdGVyaWFscyBvZiBpbnRlcmVzdC4gVGhlIHJlc3VsdHMgZGVtb25zdHJhdGUgdGhhdCB0aGlzIGNlbnRyaWZ1Z2F0aW9uIGFzc2F5IGlzIHNpbXBsZSwgZWZmaWNpZW50IGFuZCBhZGFwdGFibGUgaW4gaW52ZXN0aWdhdGluZyB0aGUgb3ZlcmFsbCBhZGhlc2lvbiBzdHJlbmd0aCBvZiBsaXZpbmcgY2VsbHMgdW5kZXIgdmFyaW91cyBjb25kaXRpb25zLCBhbmQgdGhlcmVmb3JlLCBpdCBpcyBhIHZhbGlkIHdheSB0byBkZXZlbG9wIGFkaGVzaW9uLWNvbnRyb2xsZWQgYmlvaW50ZXJmYWNlIG1hdGVyaWFscyBpbiB0aGUgZnV0dXJlLiIsImlzc3VlIjoiNCIsInZvbHVtZSI6IjEwIn0sImlzVGVtcG9yYXJ5IjpmYWxzZX1dLCJwcm9wZXJ0aWVzIjp7Im5vdGVJbmRleCI6MH0sImlzRWRpdGVkIjpmYWxzZSwibWFudWFsT3ZlcnJpZGUiOnsiaXNNYW51YWxseU92ZXJyaWRkZW4iOmZhbHNlLCJjaXRlcHJvY1RleHQiOiIoMSkiLCJtYW51YWxPdmVycmlkZVRleHQiOiIifX0="}]" />
      <we:property name="MENDELEY_CITATIONS_STYLE" value=""https://www.zotero.org/styles/vancouver"" />
   </we:properties>
   <we:bindings />
   <we:snapshot xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" />
</we:webextension>