Return-Path: X-Original-To: apmail-incubator-ooo-commits-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C400F97AC for ; Sun, 25 Sep 2011 19:39:54 +0000 (UTC) Received: (qmail 28568 invoked by uid 500); 25 Sep 2011 19:39:54 -0000 Delivered-To: apmail-incubator-ooo-commits-archive@incubator.apache.org Received: (qmail 28544 invoked by uid 500); 25 Sep 2011 19:39:54 -0000 Mailing-List: contact ooo-commits-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-dev@incubator.apache.org Delivered-To: mailing list ooo-commits@incubator.apache.org Received: (qmail 28536 invoked by uid 99); 25 Sep 2011 19:39:54 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Sep 2011 19:39:54 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Sep 2011 19:39:30 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 5B3A22388AF0; Sun, 25 Sep 2011 19:39:03 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Subject: svn commit: r1175536 [4/11] - /incubator/ooo/ooo-site/trunk/content/bibliographic/ Date: Sun, 25 Sep 2011 19:39:01 -0000 To: ooo-commits@incubator.apache.org From: kschenk@apache.org X-Mailer: svnmailer-1.0.8-patched Message-Id: <20110925193903.5B3A22388AF0@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Added: incubator/ooo/ooo-site/trunk/content/bibliographic/bib-dtd-bits.html URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/bib-dtd-bits.html?rev=1175536&view=auto ============================================================================== --- incubator/ooo/ooo-site/trunk/content/bibliographic/bib-dtd-bits.html (added) +++ incubator/ooo/ooo-site/trunk/content/bibliographic/bib-dtd-bits.html Sun Sep 25 19:38:58 2011 @@ -0,0 +1,177 @@ + + + + + + + + + + +

<!-- Extract of the bibliographic entries from -
$Id: bib-dtd-bits.html,v 1.1 2003/06/17 06:11:53 dnw Exp $

I have just cut and pasted bits from the full file so this is +not likley to be properly formed.
The full OpenOffice dtd documnets are at -
+http://xml.openoffice.org/source/browse/xml/xmloff/dtd/#dirlist
-->

<!ENTITY % fields "text:date | text:bibliography-mark +>


<!ELEMENT text:bibliography-mark (#PCDATA)>
<!ATTLIST text:bibliography-mark text:bibliography-type
( article | book | booklet | conference | custom1 | custom2 | +custom3 |
custom4 | custom5 | email | inbook | incollection | +inproceedings |
journal | manual | mastersthesis | misc | phdthesis | +proceedings |
techreport | unpublished | www ) #REQUIRED >
<!ATTLIST text:bibliography-mark text:identifier CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:address CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:annote CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:author CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:booktitle CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:chapter CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:edition CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:editor CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:howpublished CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:institution CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:journal CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:month CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:note CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:number CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:organizations CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:pages CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:publisher CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:school CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:series CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:title CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:report-type CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:volume CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:year CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:url CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:custom1 CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:custom2 CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:custom3 CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:custom4 CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:custom5 CDATA +#IMPLIED>
<!ATTLIST text:bibliography-mark text:isbn CDATA +#IMPLIED>


<!ELEMENT text:bibliography (text:bibliography-source, +text:index-body) >
<!ATTLIST text:bibliography %sectionAttr;>

<!ELEMENT text:bibliography-source ( +text:index-title-template?,
text:bibliography-entry-template* ) >

<!ELEMENT text:bibliography-entry-template ( +text:index-entry-span |
text:index-entry-tab-stop |
text:index-entry-bibliography )* >
<!ATTLIST text:bibliography-entry-template +text:bibliography-type
( article | book | booklet | conference | custom1 | custom2 +|
custom3 | custom4 | custom5 | email | inbook | incollection +|
inproceedings | journal | manual | mastersthesis | misc |
phdthesis | proceedings | techreport | unpublished | www )
#REQUIRED >
<!ATTLIST text:bibliography-entry-template +text:style-name
%styleName; #REQUIRED>


<!ELEMENT text:index-entry-bibliography EMPTY>
<!ATTLIST text:index-entry-bibliography text:style-name +%styleName; #IMPLIED>
<!ATTLIST text:index-entry-bibliography +text:bibliography-data-field
( address | annote | author | bibliography-type |
booktitle | chapter | custom1 | custom2 |
custom3 | custom4 | custom5 | edition | editor |
howpublished | identifier | institution | isbn |
journal | month | note | number | organizations |
pages | publisher | report-type | school |
series | title | url | volume | year ) #REQUIRED>




<!ELEMENT text:bibliography-configuration +(text:sort-key)*>
<!ATTLIST text:bibliography-configuration text:prefix +%string; #IMPLIED>
<!ATTLIST text:bibliography-configuration text:suffix +%string; #IMPLIED>
<!ATTLIST text:bibliography-configuration +text:sort-by-position %boolean; "true">
<!ATTLIST text:bibliography-configuration +text:numbered-entries %boolean; "false">
<!ATTLIST text:bibliography-configuration fo:language +%string; #IMPLIED>
<!ATTLIST text:bibliography-configuration fo:country +%string; #IMPLIED>
<!ATTLIST text:bibliography-configuration +text:sort-algorithm %string; #IMPLIED>

<!ELEMENT text:sort-key EMPTY>
<!ATTLIST text:sort-key text:key ( address | annote | author +|
bibliography-type | booktitle | chapter | custom1 | custom2 +|
custom3 | custom4 | custom5 | edition | editor | howpublished +|
identifier | institution | isbn | journal | month | note | +number |
organizations | pages | publisher | report-type | school | +series |
title | url | volume | year ) #REQUIRED>
<!ATTLIST text:sort-key text:sort-ascending %boolean; +"true">

+ + Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/bib-dtd-bits.html ------------------------------------------------------------------------------ svn:eol-style = native Added: incubator/ooo/ooo-site/trunk/content/bibliographic/bib-project-page1_html_m4658e43f.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/bib-project-page1_html_m4658e43f.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/bib-project-page1_html_m4658e43f.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/bib_page.html URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/bib_page.html?rev=1175536&view=auto ============================================================================== --- incubator/ooo/ooo-site/trunk/content/bibliographic/bib_page.html (added) +++ incubator/ooo/ooo-site/trunk/content/bibliographic/bib_page.html Sun Sep 25 19:38:58 2011 @@ -0,0 +1,219 @@ + + + + + +

Bibliographic

Bibliography n, 1. a complete or +selective list of literature on a particular subject. 2. a +list of the works of a particular author. 3. a list or source +materials used or consulted in the preparation of a work. 4 +the systematic description, history, classification etc. of books and +other written or printed works. - bibliographic, +bibliographical, adj.

The Macquarie Dictionary, (St. Leonards, NSW, +Australia: Macquarie Library Pty. Ltd, 1981)

Mission Statement

A number of different style conventions are in common use for + the formatting of documents. These conventions use different formats + for bibliographic citations and for reference tables. At present + OpenOffice Writer provides support for only on of these conventions. +
+ +
+ This project has three objectives -

+ to build support with OpenOffice for the formating requirements of + all of the commonly used style conventions. +
to develop a function which would enable the formate of a + document to be changed form one style to another with minimal + editing. +
to develop a function which would allow easy import and + export of bibliographic data between OpenOffice and bibliographic + databases such as BibTeX.
+

+
+ If the project’s objectives were achieved, it would be + possible to convert a scientific, technical or academic paper to the + style required by a different journal, simply by selecting the + required style convention and then generating the new version. +
+ +
+ So far as I know, no other WYSIWYG word processor can do this. Some + (eg. Word for Windows with Endnote) may handle variations in the + in-text citations of the author-date / author-number types, but not + variations between in-text and footnote / endnote citations. [ + wysiwyg -- relating to or being a word processing system that prints + the text exactly as it appears on the computer screen]

+Background

Many institutions require their documents to conform to a + specific Style Convention, which covers aspects of document format, + including the styles of bibliographic tables and citations. + [Citation: a short note recognizing a source of information or of a + quoted passage.] There are a number of Style Conventions: these + include MLA, ASA, PSA, Harvard, Chicago. These different styles + differ in the way in which they present citations and references for + different types of source documents, such as books, articles, + journals, collections etc. If a document has been written with one + Style Convention it is a laborious task to convert all these + references to another style. The ideal would be a fully automated + method of conversion. This project is working towards that. +
+ +
+ LaTeX, with BibTeX, is the standard word processor in mathematics + and the hard sciences. It can handle many types of bibliographic + style conversions. OpenOffice will have to emulate LaTeX/BibTeX's + flexibility in bibliographic styles (and in mathematic equations) if + it is to gain acceptance in that field. +
+ +
+ However, I believe that LaTeX / BibTeX can only handle in-text + citations eg. [dwilson:2002] / [dwilson:1] and not of footnote / + endnote citations. LaTeX is not WYSIWYG (even with it’s GUI + interface - Lyx). +
+ +
+ OpenOffice's current functions are limited. At present there are two + loosely coupled bibliographic facilities. One is the old StarOffice + 5.2 Bibliographic database (dbase format). It has a simple reference + insertion process. When an database bibliographic entry is dragged + onto a document, a dialog box opens which allows the fields required + for the entry to be selected. This process can be configured for + only one citation format in one citation style - eg book reference + for MLA - and it does not support character formatting of fields, + such as italic or underlining. The bibliographic database cannot + import or export data in acceptable formats for other bibliographic + applications. +
+ +
+ The other facility in new in OpenOffice. It stores bibliographic + data within the document. The data is entered through 'Insert + >Indexes and Tables> Bibliographic Entry' function, and + bibliographic tables can be generated from it. The new facility can + also access the old bibliographic database. It allows Bibliographic + citations to be selected either from the bibliographic database or + from the ‘document content' and inserted into the document. + Selecting the 'From document content' option and pressing the New + button adds bibliographic references as hidden fields. A + Bibliographic Table can be inserted that utilised the citations from + the database and / or the 'document content' . The format of the + Bibliographic Table can be finely controlled (it has character + formatting) and this is a very good piece of design and + implementation. However, the citation and table field definitions + can be set up to support only one Style Convention. To reset the + table definitions for a different style is a laborious exercise. + Another limitation is that only the in-text author-date [wilson2002] + form of citation is properly supported: the footnote or endnote + citation style is not supported. Another important limitation is + that there is no capacity for in-document bibliographic data to be + imported or exported. Nor can data be transferred between the + internal document storage and the old database.

+Project Summary

As this project is just starting, the first steps are -

+ To develop detailed requirements to achieve the objectives. +
To check what existing OpenSource work could be of use - not + reinventing the wheel. +
To encourage developers to help with the project. +
To gain an understanding of the implementation issues form the + developers. +
To undertake detailed specification and design work. +
To work with the project managers and volunteers to get the + development work done.
+

Areas of Work

We shall need to decide whether we want to provide support for + or utilise OpenSource bibliographic tools such as LaTeX/BibTeX, + sixpack, bp, or pybliographer to work with OpenOffice (they could + provide significant parts of the bibliographic functions). It would + not be difficult to provide interaction with these applications (at + least on Linux). Support for a pipe and some text conversion code + would be required in order to accept citation input from these + applications. +
Add a selection option for 'Document Style' to cover whole + document. +
Adapt the current Bibliography Table Field editor for the + bibliographic citation fields. +
Build support for the footnote and/or endnote citation methods. +
Provide for collections of bibliographic field definitions that + are selected via a ‘Select Document Style’ option. Most + of the styles are already defined in the BibTeX, but this is not a + simple format from which to extract information. +
Develop the processing to handle citations and references for + styles that require different treatment for first and subsequent + uses of the citation. +
Develop the processing required to handle the conversion of one + document style to an other. +
Develop a mechanism for transferring the internal Document + Bibliographic entries to and from the database. Also to allow import + and export from OpenOffice. And, most importantly, to support import + / export of, or direct access to, BibTeX databases. +
An import filter for LaTeX, would assist users of that word + processor to move to OpenOffice. The text conversion would not be + difficult, but converting the mathematical equations would be a bit + more tricky. (see issue + ) +
Some of the Bibliographic Database fields (Author, Title, etc.) + need to be increased in length. +
Add symbols to the automatic footnote numbering scheme.(see + issue) + +
Develop a list of the Document Styles to be included, with + details about each one. +
We need more information about bibliographic requirements + from Europe and Asia. (We have info on German JURABIB & DIN + 1505, and French UNIMARK & ISO2709)
+

Questions

Should we persist with the current DBASE Bibliographic Database? + Or, replace it with storage in BibTeX format and utilise other + OpenSource work (code or design) for a BibTeX editor and browser? + (For example see a screen-print of Sixpack + application) +
When OpenOffice database project develops support for a SQL + database, would there be any advantage of making use of it? +
Could we decode the publicly available Endnote (TM) style + definition files, and make use of them?
+

More Details

Link to a more + detailed consideration of these issues

+Participation

First, subscribe to the bibliographic +mailing lists that interest you.

Next, please scan the archive of the lists you joined to catch up +on what's been discussed so far. To read the users archive: +http://bibliographic.openoffice.org/servlets/SummarizeList?listName=dev

Then, you might consider introducing yourself, letting us know how +you found out about the project, what your interests are, and +anything else you care to share.

The originator of this project is David Wilson dnw@openoffice.org

Please feel free to subscribe and to tell to the community what +you know or what you would like to find in this project.

+ + + + Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/bib_page.html ------------------------------------------------------------------------------ svn:eol-style = native Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-er.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-er.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-er.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-styles.html URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-styles.html?rev=1175536&view=auto ============================================================================== --- incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-styles.html (added) +++ incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-styles.html Sun Sep 25 19:38:58 2011 @@ -0,0 +1,15 @@ + + + + + + + +

Style Manuals and Related WebLinks

+ +

This page has moved to the wiki +at http://wiki.services.openoffice.org/wiki/Bibliographic_Styles

+ + Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-styles.html ------------------------------------------------------------------------------ svn:eol-style = native Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.html URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.html?rev=1175536&view=auto ============================================================================== --- incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.html (added) +++ incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.html Sun Sep 25 19:38:58 2011 @@ -0,0 +1,25 @@ + + + + + + + + + +

Bibliographic Related Software and Standards Information

+ +

This page has been moved to our wiki site so that developers and users and +keep it up to date.

+ +

wiki.services.openoffice.org/wiki/Bibliographic_Software_and_Standards_Information

+ +

+ + + Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.html ------------------------------------------------------------------------------ svn:eol-style = native Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.pdf URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.pdf?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio-sw.pdf ------------------------------------------------------------------------------ svn:mime-type = application/pdf Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_1bd246eb.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_1bd246eb.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_1bd246eb.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_3058155b.png URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_3058155b.png?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_3058155b.png ------------------------------------------------------------------------------ svn:mime-type = image/png Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_4a7d5d98.png URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_4a7d5d98.png?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_4a7d5d98.png ------------------------------------------------------------------------------ svn:mime-type = image/png Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_4f86184a.png URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_4f86184a.png?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_4f86184a.png ------------------------------------------------------------------------------ svn:mime-type = image/png Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_631121c0.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_631121c0.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_631121c0.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_727633a0.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_727633a0.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_727633a0.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m18abad4c.png URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m18abad4c.png?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m18abad4c.png ------------------------------------------------------------------------------ svn:mime-type = image/png Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m1b2c13e0.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m1b2c13e0.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m1b2c13e0.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m2b2d4cbb.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m2b2d4cbb.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m2b2d4cbb.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m2e7e83a8.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m2e7e83a8.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m2e7e83a8.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m53faf055.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m53faf055.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m53faf055.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m76566d97.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m76566d97.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblio1_html_m76566d97.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDB-summary.html URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDB-summary.html?rev=1175536&view=auto ============================================================================== --- incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDB-summary.html (added) +++ incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDB-summary.html Sun Sep 25 19:38:58 2011 @@ -0,0 +1,1395 @@ + + + + + + + +

Summary File for Database : BiblioDB (Build 33)

+ +

er-diagram

+ +

Date of creation: 2006-04-10 11:20:24
+

+ +

reference_items

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	-	X	-	X
reference_type_id	reference_types(id)	int	-	-	X	-	X
title	Varchar-255	varchar(255)	-	-	X	-	-
year	date	date	-	-	-	-	-
locators_id	locators(id)	int	-	-	-	-	X
description	text	varchar(32,000)	-	-	-	-	-
collection_id	collections(id)	int	-	-	-	-	-
container_id	smallint	smallint	-	-	-	-	-
abstract	text	varchar(32,000)	-	-	-	-	-
event_id	events(id)	int	-	-	-	-	-
original_id	reference_items(id)	int	-	-	-	-	-

+ +

collections

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	X	X	-	X
title	Varchar-255	varchar(255)	-	-	X	-	-
short_title	Varchar-255	varchar(255)	-	-	-	-	-
description	text	varchar(32,000)	-	-	-	-	-
collection_type-Id	collection_types(id)	int	-	-	X	-	X

+ +

contributors

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	X	X	-	X
sort_name	Varchar-255	varchar(255)	-	-	X	-	-
display_name	Varchar-255	varchar(255)	-	-	-	-	-
organisation	Bool	char(1)	-	-	-	-	-
discription	text	varchar(32,000)	-	-	-	-	-

+ +

names

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1
id	Serial	int	X	X	X	-		X
givenname	Varchar-50	varchar(50)	-	-	-	-		-
familyname	Varchar-50	varchar(50)	-	-	-	-		-
articular	Varchar-50	varchar(50)	-	-	-	-		-
prefix	Varchar-50	varchar(50)	-	-	-	-		-
suffix	Varchar-50	varchar(50)	-	-	-	-		-
preffered	Bool	char(1)	-	-	-	-	1	-
language	Varchar-5	varchar(5)	-	-	-	-		-
valid	date	date	-	-	-	-		-
contributers_id	contributors(id)	int	-	-	-	-		-

+ +

events

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	X	X	-	X
event_type_id	event_types(id)	int	-	-	X	-	X
name	Varchar-255	varchar(255)	-	-	X	-	-
sponser	contributors(id)	int	-	-	-	-	-
begin_date	date	date	-	-	-	-	-
end_date	date	date	-	-	-	-	-
other_date	date	date	-	-	-	-	-

+ +

feeds

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	X	X	-	X
url	Varchar-255	varchar(255)	-	-	X	-	-
title	Varchar-255	varchar(255)	-	-	X	-	-
link	Varchar-255	varchar(255)	-	-	-	-	-
data_feed	text	varchar(32,000)	-	-	-	-	-
data_feed_type	Varchar-50	varchar(50)	-	-	-	-	-
http_headers	text	varchar(32,000)	-	-	-	-	-
last_retrieved	date	date	-	-	-	-	-

+ +

roles

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-		X
name	Varchar-50	varchar(50)	-	-	X	-		-

+ +

reference_types

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-		X
name	Varchar-50	varchar(50)	-	-	X	-		-

+ +

collection_types

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-		X
name	Varchar-50	varchar(50)	-	-	X	-		-

+ +

event_types

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-		X
name	Varchar-50	varchar(50)	-	-	X	-		-

+ +

locators

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	X	X	-	X
value	Varchar-50	varchar(50)	-	-	X	-	-
locator_type_id	locator_type(id)	int	-	-	X	-	X
reference_item_id	reference_items(id)	int	-	-	-	-	X

+ +

locator_type

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-		X
name	Varchar-50	varchar(50)	-	-	X	-		-

+ +

users

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	X	X	-	X
nick	Varchar-50	varchar(50)	-	-	X	-	-
password	Varchar-50	varchar(50)	-	-	-	-	-
modified	date	date	-	-	-	-	-
access	date	date	-	-	-	-	-

+ +

contributions

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	-	-	-	X
position	smallint	smallint	-	-	-	-	-
role_id	roles(id)	int	-	-	-	-	-
contributor_id	contributors(id)	int	-	-	-	-	-

+ +

identifiers

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	-	-	-	X
reference_item_id	reference_items(id)	int	-	-	-	-	X
content	Varchar-50	varchar(50)	-	-	-	-	-
identifier_type_id	identifier_type(id)	int	-	-	-	-	-

+ +

identifier_type

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	-	-	-	-		-
name	Varchar-50	varchar(50)	-	-	-	-		-

+ +

annotations

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	X	-	-	-	X
user_id	users(id)	int	-	-	-	-	-
content	text	varchar(32,000)	-	-	-	-	-

+ +

tagings

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Idx1
id	Serial	int	-	-	-	-	-
tagable_type	Varchar-50	varchar(50)	-	-	-	-	-
tags_id	tags(id)	int	-	-	-	-	-

+ + Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDB-summary.html ------------------------------------------------------------------------------ svn:eol-style = native Added: incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDbase.gif URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDbase.gif?rev=1175536&view=auto ============================================================================== Binary file - no diff available. Propchange: incubator/ooo/ooo-site/trunk/content/bibliographic/biblioDbase.gif ------------------------------------------------------------------------------ svn:mime-type = image/gif Added: incubator/ooo/ooo-site/trunk/content/bibliographic/bibquery.perl URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/bibliographic/bibquery.perl?rev=1175536&view=auto ============================================================================== --- incubator/ooo/ooo-site/trunk/content/bibliographic/bibquery.perl (added) +++ incubator/ooo/ooo-site/trunk/content/bibliographic/bibquery.perl Sun Sep 25 19:38:58 2011 @@ -0,0 +1,45 @@ +!#/usr/bin/perl +#--------------------------------------------------------- +# This script extracts some data from an OOo bibliographic +# entry. Its command line must contain 2 arguments: the +# file name and the identifier of the biblio entry. +# Note: It's not a real world situation; one should not +# instantiate a document object just for retrieving only +# one element; ooDocument() loads and parses the full +# document, and it's the most costly operation. + +use OpenOffice::OODoc; + +my ($filename, $identifier) = @ARGV; + +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â # get a document connector +my $doc = ooDocument(file => $filename) +Â Â Â Â Â Â Â Â or die "Unknown or non-valid OOo file\n"; + +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â # query for the needed biblio field +my $bib = $doc->selectElementByAttribute +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ( +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â '//text:bibliography-mark', +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 'text:identifier', +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $identifier +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ) +Â Â Â Â Â Â Â Â or die "Unknown reference\n"; + +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â # extract the properties +my $author = $doc->getAttribute($bib, "text:author"); +my $title = $doc->getAttribute($bib, "text:title"); +my $publiher = $doc->getAttribute($bib, "text:publisher"); +my $year = $doc->getAttribute($bib, "text:year"); +my $isbn = $doc->getAttribute($bib, "text:isbn"); + +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â # create the report +printÂ Â Â "Author: Â Â $author\n"Â Â Â Â Â Â Â Â Â Â . +Â Â Â Â Â Â Â Â "Title: Â Â $title\n"Â Â Â Â Â Â Â Â Â Â Â . +Â Â Â Â Â Â Â Â "Publisher: $publisher\n"Â Â Â Â Â Â Â . +Â Â Â Â Â Â Â Â "Year: Â Â Â $year\n"Â Â Â Â Â Â Â Â Â Â Â Â . +Â Â Â Â Â Â Â Â "ISBN: Â Â Â $isbn\n"; + +Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â # that's all +exit; + +#---------------------------------------------------------

Bibliographic

Mission Statement

+Background

+Project Summary

Areas of Work

Questions

More Details

+Participation

Style Manuals and Related WebLinks

Bibliographic Related Software and Standards Information

Summary File for Database : BiblioDB (Build 33)

reference_items

collections

contributors

names

events

tags

feeds

roles

reference_types

collection_types

event_types

locators

locator_type

users

contributions

identifiers

identifier_type

annotations

tagings