Morton, Good to hear from you. I have Jabref installed on my system and think you have done a fine job.
On Thursday 12 January 2006 8:05 am, Morten Omholt Alver wrote: > Hi, all, > > I manage the bibliography manager project JabRef > (http://jabref.sf.net). One of our most-requested features is > interoperability with Openoffice, and I really want to do something > about that. > > Currently we have a spreadsheet export option that produces a > spreadsheet that can be used as bibliography data source in OOo 1.x.It > seems to me that a spreadsheet cannot be used in this way under OOo > 2.0. Am I correct, or is this still possible (if so, how do I set > it?)? > You can still use a text / spreadsheet / csv file as a (read-only) OOo bibliographic database in OOo version 2. Just by chance I posted details of how to do this ysterday at http://wiki.services.openoffice.org/wiki/Bibliographic_FAQ I wrote this for someone asking how to use B3 (a java app similar to Jabref) with OpenOffice. B3 offers csv file export or writing to a ODBC database that Openoffice can use. I have only tested B3 with csv files without problems. I have just download jabref 2beta, (it looks good) and OOo will not work with the spread sheet or csv file produced by Jabref. I have not worked out why but it is probably because the fields are not exactly the same (number, name and order) as in the original biblio database file. For a start you have 'BibliographyType' rather than the orignal 'Type'. To work out the correct format find the .openoffce.org2/user/database/biblio/biblio.dbf file and open it in the spreadsheet, were you can see the fields, You could save it as a biblio.csv file and work from that. > As far as I know there are two other options that we could consider: > > 1. Communicating directly via the OOo socket (UNO) I think this is a nicer option. As it does not require the user to sup databases etc. I understand Bibus has done this but I have not got bibus to work on nys system. It should not be too hard to translate the UNO calls in Python to Java. You could think of adding 'Insert Selection Citations into OpenOffice' > 2. Offer a database export that OOo can use > You just need to set up an ODBC link. But again you need to make sure the fields are exactly the same (number name and order) as in the original biblio database file. With OOo1.x I could connect to a MYSQL database and 'drag and drop' the orignal biblio db into the MYSQL connection and it would give me the option of copying fields and data to new MYSQL db. You can not get it much easier. But I have not worked if one can or how to do this OOo2. > For either of these cases I need support - someone who can help me > understand how things work on the OOo side (or who can point out a > better alternative than those I listed). OpenOffice is a fairly > complicated product, so I think some inside help is necessary to get > the best possible solution. I hope someone is able and willing to > help! We do not have expertise in our project but post to [EMAIL PROTECTED] or the list dealing with UNO [email protected] > > Please tell me if there is a better place to address this request. > > > Yours sincerely, > Morten O. Alver > > > PS: I tried to post this a few weeks ago, but since it doesn't seem to > have reached the list, I'm trying again. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
