Zotero to OOffice database script - errors (missing TY tag)

dalloliogm

I am trying to use the zotero to ooffice db script described here:
- http://forums.zotero.org/discussion/19/openoffice-writer/
- http://bibliographic.openoffice.org/files/documents/124/3078/RISImport.py

but haven't managed to get it working.

When I try to convert a RIS file I get the following error:

<blockquote>*********************************************
ERROR: The RIS tag TY is missing
*********************************************

*********************************************
ERROR: The RIS tag TY is missing
*********************************************

Traceback (most recent call last):
File "/home/user/Local_Repository/Bibliografia/RISImport.py", line 243, in ?
insertToOOo(references)
File "/home/user/Local_Repository/Bibliografia/RISImport.py", line 229, in insertToOOo
rowSet.insertRow()
__main__.com.sun.star.sdbc.SQLException: invalid value for column 'URL'
</blockquote>

The RIS TY tag is not missing in the data I have. I just have exported the zotero collection using the menus in zotero.
This is the library I'm using:
- http://genome.imim.es/~giovanni/archive/zoterolib.ris

I believe I've followed the installation instructions correctly, but the RISimport.py script has never worked.
I've added /usr/lib/openoffice/program on $PATH and $PYTHONPATH variables with the command export PATH=/usr/lib/openoffice/program:$PATH (the same for PYTHONPATH).
Then I've started openoffice with the option described in the instruction file.
Then, I've exported the library from zotero in .ris format and executed the script.

I'm on a debian sid with openoffice 2.2.1.
Zotero version is 1.0.0b4.r5.

bdarcus

I don't really recommend using this approach for integration with OOo. There will be a better solution coming soon (any day now??).

dalloliogm

Well, it's two months I'm waiting :(

Matthias

@dalloliogm: as a temporary solution until a direct integration of Zotero and OOo is available, you could login at http://beta.refbase.net/ and import your Zotero RIS data there. Then, display all your imported records on one page, select all and export using format "ODF XML". This will export your data to an OpenDocument spreadsheet file for use with OOo.

dalloliogm

ok thanks: but how to import ODF spreadsheet in OOo database?
That's the point, because I've already used jabref for exporting the rif document.

Matthias

> but how to import ODF spreadsheet in OOo database?

Please see the instructions at http://openoffice.refbase.net/