Apache OpenOffice (AOO) Bugzilla – Issue 58889
can't change table in bibliography
Last modified: 2006-02-09 11:03:42 UTC
I've added a sqlite database (Bibus) via ODBC. Now I tried to change the database in the biliography. That works fine. But then I then want to change the tables with in the new database nothing happens. The table is namewise change but not the content. You'll allways get the content of the first table of the database displayed.
Created attachment 32058 [details] Picturs documenting me trying to change the bibliographic database
Reassigned to ES.
I suppose Bibus is bibliographis software by Pierre Martineau. As fas as I know, Bibus itself keeps track of bibliography database, citations and bibliography table, you do not need to access the bibliography table from OOo itself, but from Bibus application. This sounds to me like a problem of permissions to write into the Bibus database, not an OOo problem.
In Bibus dokumentation Pierre Martineau discribes howto use the Bibus database instead of the standard OOo. So the Problem isto change the databse source in OOo Bibliography. If you look at the picutes send in as zip it becomes clearer now I hope. Here I'm adding the mail I wrote to Pierre Martineau about the problem: () designates a comment I made about the setps discribed. Hi I'm just setting-up the OOo2 interface. I followed your steps from your web page: Menu : Tools/Data Sources ... On the left, click in "New Data Source" Give a name (Biblio for instance) Select ODBC in Database Type (You can also select MySQL if you use this database) Click on ... for 'Data source URL' and select the database which should appear in the list if you correctly configured ODBC Click in the ODBC Tab Enter User Name, password required if necessary, Unicode (UTF-8) Click on Tables Tab A pop up dialog should ask you about your password. Give it. The tables should be displayed. Close the window Menu Tools/Bibliography Database (pic1.jpg shows my desktop before the next step) Menu Edit/Choose Data Source (pic2.jpg shows my desktop before the next step) In the listBox, choose your database (Biblio) OpenOffice.org may complain about some column names. Click No for the moment. (pic3.jpg and pic4.jpg show my desktop before the next step) Select the correct table in the Table menu in the tool bar. If you use the database supplied with Bibus, it should be Biblio.bibref (pic5.jpg shows my desktop after the this step Itstill shows the table from bibquery. Why doesn't it change?) OpenOffice.org may complain again about some column names. Note carefully the name of the fields that was not recognized (usually, 'Type' and 'Type of Report') and click in Yes. Choose the correct fields. With some OpenOffice.org version, if you choose other fields that the ones asked at the previous step, the program will crash. However it seems not to be the case anymore with 1.1.1. The name of the fields in Bibus are easy to understand. There is a ScreenShot below that shows the dialog with all the fields name filled. Now you can insert citations in OpenOffice.org using the normal menu and you don't need to have Bibus running. Menu : Insert/Indexes and Tables/Bibliography Entry ... Have a look at the OpenOffice.org Help for how to insert citation and generate a bibliographic index. So my question is what am I doing wrong? Thanks in advance again. CU Michael Burkhardt
duplicate *** This issue has been marked as a duplicate of 59196 ***
Closed