Description: Database biblio: When opening the tools-bibliography_database menu, this error message appears: The following column names could not be assigned... then I have to reassign all columns. Problem is worse in other than english languages, hardly anybody knows the assignment of the columns. Big problem: you must use a table for the database, unfortunately it's not possible to use a query, so you cannot take a relational database for the job. Best would be a relational database with at least 2 tables, one for the medium (books, magazines etc.) and the other for the articles, authors... Then a query should assemble the data for the biblio-format. Steps to Reproduce: 1. tools-bibliography_database menu 2. 3. Actual Results: The following column names could not be assigned: Type Publication type Organization Institution Type of report Do you want to edit the column arrangement? Expected Results: All columns should be assigned automatically Reproducible: Always User Profile Reset: No Additional Info:
Next problem: if there is the same bibliography entry multiple times in a document, then this entry appears multipls times in the index. Every instance of a bibliography entry should have the same number and should appear only once in the index.
Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Problem has nothing to do with my user profile. The main problem is, that the literature database module cannot connect to a query! So it must connect to a table and therefor you have to do a reassign orgy first. From an existing literatur database you could do a query to the biblio format. Would it be possible to do the whole bibliography index with base and insert it in the document?
Created attachment 156140 [details] Quick provisional example how it should work with a query. Query has still wrong field names.
(In reply to saxofon from comment #3) > The main problem is, that the literature database module cannot connect to a > query! So it sounds more like an enhancement request than like a bug. I'm not familiar with bibliography in writer, because I use zotero, so I don't know if input from Design-Team or from a developer is needed. cc: Design-Team
The request is reasonable and we should improve the database organization.
Great, if biblio could be done with queries, we can use a fully normalized relational database for it. Everyone could build his own database in different languages, only the query must be standardized to fit into the biblio format.