hyperlinking citations to bibliography in OpenOffice


Does anyone know how to automatically link zotero citations within OpenOffice or Word documents to their respective references in the bibliography? Then these stay together when exported to a PDF. From there it would be nice if there were any DOI or URLs etc. to hyperlink to out the web browser.

Many many thanks,
  • I would also like to know how to make the URLs presented in a bibliography 'hot', that is make them hyperlinks that allow the reader to click on the URL to view the source in the browser. Once a bibliography is 'hard-wired', you can manually visit each URL and make them a hyperlink but it would be great if this could be done automatically.
  • edited July 27, 2009

    I am also interested in any ways of achieving these effects automatically.

    In the case of hyperlinking from references to external target resources (via URLs from the database) I would also ideally like the option to not expose this URL, but be able to choose another field (usually the "title") that would function as the link text.

    Assuming these functions are not currently available, even some advice on what would be required to add them would be helpful (e.g., what components need to be modified - just the zotero extension, or zotero itself, or openoffice itself, or some openoffice xslt filters, or what?). Right now, I don't know enough about the architecture of openoffice or zotero to have any feel for this; but if I knew what was involved I might be able to contribute to fixing it.

    (All this functionality is available with pdflatex+natbib+hyperref - but for certain projects I need to use openoffice, so it would be nice if it could offer comparable ability for these cases. Here is an example paper demonstrating, in both HTML and PDF formats, the linkage from citations to references; and also hotlinking of references to targets, albeit still with exposed URLs in this case.)

  • OK, so I guess it's a bit lame to reply to my own message ... but I just want to log the limited further research I've done...

    I have established that it is definitely possible to manually add internal hyperlinks linking citations to corresponding entries in the bibliography. Basically just go through the bibliography and insert a bookmark at the start of each one. Then go back to each citation, highlight it, click the hyperlink button, click "Document" (rather than "Internet") if not already active, click the button to the right of the "Target" field, navigate to the relevant bookmark, click "apply", close the target navigation (sub-)window, click "apply" again in the hyperlink window, and close that. Once this is all done, export to PDF and you should find that these internal hyperlinks work as expected in the PDF version.

    (Note: I'm not saying there is anything special here about linking citations to bibliography entries - this is just the standard oowriter "internal hyperlink" functionality. I'm just logging it here for the benefit of anybody reading the thread who has not done it before...)

    Hyperlinking bibliography entries to external resources (either exposing or suppressing URLs) can presumably also be achieved manually with this sort of approach.

    Of course, this is all pretty labour intensive. Also, I have not checked, but I suspect that if, for any reason, one asks the zotero extension to re-generate/update the bibliography, or manipulate/edit individual citations, then this linkage could easily get blown away again. But my conclusion is that, on the face of it, it looks like the desired functionality can, in principle, be automated in a reliable way with modifications only to the zotero openoffice extension (i.e., it should not be necessary to change either zotero itself or dig into the internals of openoffice, including the PDF exporter). I've never attempted to develop or modify an openoffice extension, but a quick peek inside the Zotero.oxt (with unzip) suggests that the functionality is basically all in the Zotero.py - a 1500 line python script (which may not currently have any maintainer?).

    I might roll up my sleeves and try to have a go at this sometime in the coming months, but it is not a very high priority and would be a fairly big learning curve for me ... so I would equally be very pleased if anybody already experienced in openoffice python extension development would be interested ;-) ...
  • Your comments have been very helpful bmcm - thank you. It would be AMAZING to have all these functionality added to the ooo extension, which has hardly been updated since its creation. Unfortunately I don't have the skills at all to do this sort of thing myself. Awaiting eagerly for those kind souls:)
  • Hi zdemery -

    Yep, it will be very nice if/when this is all implemented. Unfortunately, the bad news is that I think I was a little over-optimistic in my earlier assessment. I had assumed that when zotero delivers a formatted bibliography to the openoffice extension, there would be unique embedded identifiers associated with each item that could be matched with corresponding identifiers in each citation; and this would be the basis for the extension to automatically hyperlink them together. However, while I can find suitable embedded identifiers associated with the citations, I can't find any corresponding identifiers associated with the items in the bibliography. Without such embedded identifiers, it is quite complex to try to match citations to bibliography items (not least because the relationship would depend critically on the citation and referencing style in use). So, if I am right that zotero is not currently embedding such identifiers in the bibliography it sends to the extension, then I think it would be necessary to modify zotero itself somewhat to add this information; this is, I don't think this issue can currently be addressed just by working on the extension. There again, I have not investigated that deeply, and I may have missed something. Or maybe this functionality will be added to zotero in the future for some other reasons anyway...
  • Update: so ... I eventually got around to hacking a little bit more on this. I've done a very crude, clunky, "proof-of-concept" implementation. This works only for openoffice.org and is not properly integrated anyway (uses an external, standalone, perl script for post-processing the ODT file to actually properly instantiate the hypertext links). But the advice from the zotero-dev list is that this will all become much cleaner and easier when the "new" CSL processor is released, sometime real soon. So, I may look at it again once that comes out...

  • Also note that you can already start working with the new CSL processor in the trunk XPI builds of Zotero, just be sure to not use it with vital data.
  • ajlyon points out: "Also note that you can already start working with the new CSL processor in the trunk XPI builds of Zotero, just be sure to not use it with vital data."

    Yes, I should have mentioned that. It's a bit more "bleeding edge" than I want to look at myself, but maybe others will take it on...

  • there is another work-around. you can simply use the openoffice AutoCorrect function. But for make it working you have to copy your bibliography in an new document (no idea, why AutoCorrect doesn't work in the area of the bibliography)

    1. Ctrl+C your whole bibliography (at the end of writing)
    2. ctrl+shift+v -> formattet text (rtf) -> to import the format
    3. adapt your AutoCorrect options -> Format -> AutoCorrect -> AutoCorrect Options -> only url-recognition should be marked (in the [M]-Section)
    4. run AutoCorrect
    5. copy+paste the bibliography in your original document.
  • Hello,

    I've just been googling around for this feature and it seems that this is still unsolved in Zotero Standalone 3.0beta. Is this true?

    May be the developers think differently but having the bibliography citations without hyperlinks to their bibliography entries is to me too ... hm ... antiquated.

    In many other respects Zotero is a wonderful tool, thanks a lot for it!
  • This thread is what I am searching for--Hyperlink Citations in a Bibliography / reference in ms office document or its printed/exported pdf.

    I thought I was able to do it with Zotero but it seems that it has not been implemented yet.

    But FYI, this feature has been implemented long time ago in Endnote, for example, see this: http://libguides.utoledo.edu/content.php?pid=221467&sid=1877021

    So for now, for practical reason, if I want to be able to do this, then I should switch doing the job by using Endnote.

    Looking forward to being able to do something important ( to hyperlink citations in ms office and in its printed pdf file) like this in Zotero in the future. Thanks.
Sign In or Register to comment.