bibliography

users
#1

Hi everybody!
I want to create bibliography database, but i dont want use default
bibliography biblio for that. How i can perform it? Which files are
correspond to the database and where are they placed in file system?
Thanks in advance.
Andrey

#2

In Writer or Calc hit F4.
Right-click the existing Bibliography and choose "Edit Database".
You get a new window with a database document and with the connection
info in the status bar of that window. "Bibliography" stands for a dBase
directory with one file biblio.dbf in a certain directory.

In Writer or Calc hit F4.
Right-click the existing Bibliography and choose "Registered Databases".
It opens the options dialog with a list of database documents registered
under a certain name.

The idea is that you can re-use any type of database or "tabular files"
such as csv, spreadsheets, dBase directories by connecting a Base
document to that data source you already have. Any registered Base
document connected to any tabular data source can be used in the same
ways as bibliographic database or as a source for serial letters, label
printing or calculation models regardless of the exact type of source.

So the main question is: Where do you store your bibliographic data
right now? Then you may be able to connect a Base document to this data
source.

#3

I have several documents and i want keep databases created "from zero"for
each of them. I want create new databases and keep them separately each
from other. How i can do it? thats my main question. If i open main
document should i connect bibliographic file every time than i do it?

#4

By the way i have three file: biblio.dbf, biblio.dbt, biblio.odb. Which of
them i should save with corresponding writer document? (for transfer them
together to another computer for example)

#5

There is nothing to be saved nor modified. This is just a prepared
database shipped with LibreOffice.
biblio.dbf contains the data. dbf files can be edited in hundreds of
database programs and spreadsheet applications.
biblio.odb is the database document which is connected to the biblio
directory with the biblio table.
This database document is registered under the name "Bibliography" so it
appears in the data source window.

I have never noticed the biblio.dbt file. Don't know what it is.

Before you can create any kind of database, you need to know clearly
what you are going to store in it. There is no magic wizard that
develops the right storage for you. You've got to do this entirely on
your own using the database of your choice. No, Base is not a database.
It is something to work with databases in the context of this office suite.

For bibliographic purposes there is also a cloud based database
https://www.zotero.org/ which can be used with LibreOffice.

I would simply use the existing one if it contains all the required
columns and it is very easy to ignore any columns you don't need.
Simply remove all rows from the biblio table, define a query with the
columns you actually want to user and enter your own data into the query.
Don't try to build a fully functional relational database from scratch
unless you have some basic knowledge about database design which is well
paid development work.

#6

Biblio.dbt is the accompanying file to DBF, which stores the data from
MEMO fields.

Alex

#7

Ah, thank you.

#8

Before you delete all rows from the existing biblio table, go to the
queries section, create a new query in SQL view and paste the following:

SELECT "Identifier","Author",
"Custom1" AS "Language",
"Identifier","ISBN","Pages","Publisher","Title","Type","Year"
FROM "biblio"
ORDER BY "Author"

Save and close the query and double-click its icon.
It selects only those columns of the shipped table which contain some
data in arbitrary order of columns (I rearranged them in alphabitical
order) while sorting the rows by autor name. The "Custom1" column is
renamed to "Language" because this is the actual content of that column.

You could use this subset of a table just like you would use the
original table. Everything you enter in the query will be entered into
the corresponding field of the table.

Base-menu:Tools>SQL...
DELETE FROM "biblio"
deletes all records from the biblio table. You can also click the grey
top left corner of the opened table which selects all records and then
delete all selected rows by button or context menu.