Issue 11576 - A HOWTO to use the Bibliography database for flat databases
Summary: A HOWTO to use the Bibliography database for flat databases
Alias: None
Product: documentation
Classification: Unclassified
Component: How To (show other issues)
Version: current
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-02-18 06:34 UTC by gimpy
Modified: 2013-07-30 02:43 UTC (History)
1 user (show)

See Also:
Issue Type: TASK
Latest Confirmation in: ---
Developer Difficulty: ---

a same flat text database file in csv format for the bibliographic db (21.92 KB, text/plain)
2003-08-17 07:58 UTC, dnwilson
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gimpy 2003-02-18 06:34:50 UTC
I would like to see an official OOo howto on using the Bibliography database function to create and 
use simple flat-file databases with TXT files and spreadsheets.
Comment 1 scarr 2003-02-26 05:15:34 UTC
CHanging the type to "Task" so it shows up in the Doc Task list.
Comment 2 dnwilson 2003-08-17 07:56:54 UTC
I have not responed to this because I had not worked out how to do 
myself untill now. 
We have now worked out what needs to be done. 
The cvs file must have the fields delimited by semicolons - ; 
OOo users numbers to indicate the citation type 0=article, 1=book, 
The following file fragment text can be saved as biblio.cvs in the 
user/Openofficexx/user/database/biblio directory. (I shall attache a 
lager version in case the format is messed up here.) 
You can now define biblio.cvs as the flat file database - 
In Openoffice go to View>Data Sources. Right click on Bibliographic, 
Administer data sources, change the database type to text, select 
bibliographic directory again 
on the Text tab, select extension=csv 
on the table tab select Biblio 
It is done. 
Now try tools>Bibliographic Database, you will get a prompt that 
some fields need to be redefined select yes, some for the field 
names have not exactly matched, but it should be obvious what to do 
find the fields defined as <none> and select the appropriate ones. 
It should then be working, test inset bibliographic references and 
produce a bibliographic table. 
Note: you can not write to the text database. 
--- cut--- 
"Rig03";"1";"";" A Companion to Britian in the Later Middle Ages 
";"2003";"";"";"";"";"Rigby S. H.";"";"";"";"";"";"";"";"";"";" 
Blabkwell Publishing ";"";"";"";"";"";""; 
"ALDFIRTH1999";"1";"Aldfirth d. 705,King of Northumbria";" Old Irish 
Wisdom attributed to Aldfirth of Northumbria : an edition of Briatha 
Flainn Fhina maic Ossu ";"1999";"";"";"";"";",edited Colin A. 
Ireland,translated by 
"ANDERSSONct.";"0";"Andersson Theodore M.";" the displacement of the 
heroic ideal in the family saga ";" (1970:Oct.) 
";"";"";"";"";"";"";"";"";"oct";"";"";"";"";"";" Speculum; a Journal 
of Mediaeval Studies 45:4 (1970:Oct.) 575 Journal Subject: 
Humanities ";"";"";"";"";"";""; 
"Be96";"1";"Bartlett Thomas, ,eds,Keith Jeffery";" A Military 
History of Ireland, ";"1996";"";"";"";"";"";"";"";"";"";" Ba 
355.009415 MILI ";"";"";"";"";" (Cambridge: Cambridge University 
Press, 1996) ";"";"";"";"";"";""; 
--- cut --- 
Comment 3 dnwilson 2003-08-17 07:58:46 UTC
Created attachment 8508 [details]
a same flat text database file in csv format for the bibliographic db
Comment 4 gimpy 2003-09-21 07:13:42 UTC
tested "biblio.csv" file in 1.1rc3 and it works fine.
Comment 5 scarr 2004-08-19 20:10:41 UTC
Closing per user instruction.
Comment 6 scarr 2004-08-19 20:12:06 UTC
Reopening issue, will add howto using these instructions tonight.  Sorry, jumped
the gun. ;-)
Comment 7 grsingleton 2005-08-27 21:50:19 UTC
Where is the doc?
Comment 8 grsingleton 2005-08-27 21:51:11 UTC
From 2004
Comment 9 grsingleton 2005-09-30 01:11:15 UTC
What is the status of this task
Comment 10 Rob Weir 2013-07-30 02:43:26 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.