Re: [Refdb-users] Not reinventing the wheel ...

[<ste...@jo...>]

Markus Hoenicka a =E9crit :
> St=E9phane T=E9letch=E9a <ste...@jo...> was heard to say:
>=20
>> Not sure about the future, but actually it already works with Bibus
>> (that's the reason i've looked towards it).
>>
>> You can get a rather complete description for OpenOffice.org connectio=
n:
>> http://bibus-biblio.sourceforge.net/bibus_doc/html/en/usingOOo.html
>>
>=20
>=20
> As far as I understand the document there are two ways to interact with
> OpenOffice:
>=20
> 1) ODBC
> This simply pulls the data out of a SQL table via ODBC. This requires t=
hat there
> is a 1:1 mapping of the fields that OO expects and the fields in the da=
tabase
> table. RefDB reference databases are relational, that is this simple ma=
pping is
> not going to work.

Right.

> 2) External control of OO through the UNO interface
> Sure you can program OO (and Word, fwiw) using their APIs, but this req=
uires
> each bibliography tool to write one interface per supported word proces=
sor (n
> tools times m word processors makes n*m interfaces).

Right, but that also means you can take advantage of the existing work=20
done in bibus, this is my major argument, in the end.

> The OO bib project (Bruce, correct me if I'm wrong) tries to implement =
a
> mechanism that allows OO to retrieve cited data through the SRU/SRW
> (http://www.loc.gov/standards/sru/) interface from any database that pr=
ovides
> such an interface. This would result in n+m interfaces and is the bette=
r
> approach as soon as you're looking at more than two word processors and=
 more
> than two data sources.

Sorry to not follow you argument but i've been on their mailing list=20
long time ago (around 2002 IIRC) and this feature is *far* from being=20
the priority. We're now close to 2007 and this is still a work in=20
progress. What we need is somthing working for the moment, and may be=20
another implementation later if they provide a better way.

Second that does not solve the Word problem, bibus does.

> regards,
> Markus

I'm not against any idea here, this is just i'm looking for solutions=20
since 2000/2001 and so far, only little pieces are available, nothing=20
integrated.

My suggestions are :

- Take refdb as the backend system (for data manipulation, import,=20
export and mangament),
- use exising code (from refbase) for the php interface since it seems=20
more advanced that what we have in refdb for now, at least this will=20
help both sides i presume
- take the bibus connectors for Word/OpenOffice.org

The problem lies in the compaction of it. Do we need to integrate all in=20
refdb (that would be a must) or let them work flawlessly together (i was=20
thinking of getting a correspondance between tables and/or renaming some)=
 ?

I hope i'm clearer now.

Cheers,

St=E9phane


--=20
St=E9phane T=E9letch=E9a, PhD.                  http://www.steletch.org
Unit=E9 Math=E9matique Informatique et G=E9nome http://migale.jouy.inra.f=
r/mig
INRA, Domaine de Vilvert                  T=E9l : (33) 134 652 891
78352 Jouy-en-Josas cedex, France         Fax : (33) 134 652 901