Bug 128997

Summary:	Bibliography database must be re-assigned to all columns; Use of a query is not possible.
Product:	LibreOffice	Reporter:	software.v9onn
Component:	Writer	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	dgp-mail, heiko.tietze, xiscofauli
Priority:	medium
Version:	6.3.3.2 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	101258
Attachments:	Quick provisional example how it should work with a query. Query has still wrong field names.

Description software.v9onn 2019-11-24 21:18:23 UTC

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:

Comment 1 software.v9onn 2019-11-25 11:28:10 UTC

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.

Comment 2 Xisco Faulí 2019-11-26 11:02:58 UTC

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

Comment 3 software.v9onn 2019-11-26 14:20:20 UTC

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?

Comment 4 software.v9onn 2019-11-27 09:33:02 UTC

Created attachment 156140 [details]
Quick provisional example how it should work with a query. Query has still wrong field names.

Comment 5 Dieter 2020-05-11 16:59:52 UTC

(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

Comment 6 Heiko Tietze 2020-05-12 06:35:24 UTC

The request is reasonable and we should improve the database organization.

Comment 7 software.v9onn 2020-05-12 11:07:06 UTC

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.