Difference between revisions of "Database"

From Apache OpenOffice Wiki
Jump to: navigation, search
(added query functions)
(Manuals)
 
(119 intermediate revisions by 23 users not shown)
Line 1: Line 1:
 +
{{Template:Base Project}}
 
{{Database/Lang|Database}}
 
{{Database/Lang|Database}}
On this page you find links to Base documentation ordered by languages and topics. It may be helpful for authors and translators.
 
  
This page is considered to be "Work in Progress". Please add documents you are missing to this list.
+
This page is hosted by the [https://wiki.openoffice.org/wiki/Database_Docu_Coordinator OO Database Docu Coordinator], who are members of the [https://www.openoffice.org/qa/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA Team].
 +
You can find here links to Base documentation ordered by languages and topics. Feel free to add missing documents to this list.
  
Resources related to OpenOffice.org Base:
+
This documentation describes basic functionality about Apache- /Libre- /Star- Office Base which doesn't change.
 +
 
 +
Resources related to {{AOo}} Base:
  
 
= English =
 
= English =
 +
The following links are in English.
 
== Manuals ==
 
== Manuals ==
 
=== General ===
 
=== General ===
 +
 +
* Forum
 +
: Lots of Base examples and answers to questions in the [https://forum.openoffice.org//en/forum/viewforum.php?f=83 Base Forum]
 +
 
* Base
 
* Base
: [http://wiki.services.openoffice.org/wiki/Base Base]
+
: [[Documentation/Database | Database]]
: Description of Base (short overview)
+
: Description of the features of OpenOffice Base (short overview), Documentation resources and official sites
 +
 
 +
* OpenOffice.org User Guides (Getting Started with Base)
 +
: [http://wiki.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf  Getting Started with Base] - ''PDF''
 +
: or Getting Started with Base [[Documentation/OOo3_User_Guides/Getting_Started/Getting_Started_with_Base|wiki version]]
 +
: Learn how to create a database, queries, forms and reports and connect to and use other data sources within {{AOo}} Base.
  
* OpenOffice.org User Guides (Getting started with Base) - ''PDF''
+
* Base Guide
: [http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf  Getting started with Base]  
+
:[[Documentation/OOoAuthors_User_Manual/Base_Guide/Planning|Base Guide Planning]]
: Learn how to create a database, queries, forms and reports and connect to and use other data sources within OOo-Base.
+
:Base Guide Outline Proposal from OOoAuthors
  
* OpenOffice.org Base Manual
+
* Mid Level Base Tutorial
: [http://nothickmanuals.info/doku.php/articles:ooobaseprimer OpenOffice.org Base Primer]
+
: [https://wiki.openoffice.org/w/images/0/02/Base_tutorial.pdf Mid Level Base Tutorial] and the subsequent SQL [https://wiki.openoffice.org/w/images/1/1d/Base_Tutorial_SQL_code.txt Base Tutorial SQL code]
: Initial Authors: Andre 'Drew' Jensen, Frank Schoenheit, et al.
+
: Initial Authors: Mariano Casanova, Andrew 'Drew' Jensen
: A short screenshot-guided overview on how to use Base.
+
  
 
* Beginners - Example Database - Base Tutorial  
 
* Beginners - Example Database - Base Tutorial  
: [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
+
: [https://web.archive.org/web/20060924184242/http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
: Initial author: Andrew 'Drew' Jensen  
+
: Initial author: Andrew 'Drew' Jensen
: This tutorial covers creating a first database using OOoBase. It is intended for those that have not used Base before or those that have never used any database manager.  
+
: This tutorial covers creating a first database using OOo Base. It is intended for those that have not used Base before or those that have never used any database manager.  
  
* Mid Level OpenOffice.org Base tutorial
+
* Beginners - Example Database - "MELOMAN" Music Database
: [http://wiki.services.openoffice.org/wiki/Documentation/Dashboard/Tutorials/Base_%28Mariano%29 Base Tutorial]
+
: Initial author: Vlad Seredkine
: Initial author: Mariano
+
: [https://wiki.openoffice.org/w/index.php?title=MusicDataBase_VladS/Presentation Database presentation]
: ''-- under construction --''
+
: [https://www.mediafire.com/download.php?wj41ynimytk “MELOMAN” Open Office Music Database]
 +
: [https://www.mediafire.com/download.php?4dotmnmjn11 “Meloman_User_Guide”]
 +
: [https://www.mediafire.com/download.php?z3mkmjmitgf “MELOMAN Open Office 3.1 Data Base Application. Internal Design Specification”]
 +
: [https://www.mediafire.com/download.php?dymtn1rmzrc “Meloman test cases”]
  
 
* Base and Macros
 
* Base and Macros
: [http://www.pitonyak.org/database/ Pitonyak's document]
+
: [https://www.pitonyak.org/database/ Pitonyak's document]
 
: Initial author: Andrew Pitonyak
 
: Initial author: Andrew Pitonyak
: This documentation focuses on operating a database with the help of OpenOffice.org Macros.
+
: This documentation focuses on operating a database with the help of OpenOffice Macros.
  
*  Database: "ooBase", aka "Base"
+
*  Database: "ooBase", aka "Base"- From getting started to more advanced
: [http://sheepdogguides.com/fdb/fdb1main.htm Base Tutorial by Sheepdogguides.com]
+
: [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials and "How to"s... 45 from one author at Sheepdogguides.com]
 
: Initial author: TK Boyd
 
: Initial author: TK Boyd
: After a short introduction some every day tasks like importing data from other tables are explained.
+
: Both specific tasks and fundamental skills are explained.
 +
: A section introducing the use of macros added 5/09.
  
 
*  Bringing data into OpenOffice 2.0's database
 
*  Bringing data into OpenOffice 2.0's database
: [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Database]
+
: [https://searchdatacenter.techtarget.com/tip/Bringing-data-into-OpenOffice-20s-database Database]
: Initial author: Solveig Haugland
+
: Initial author: Solveig Haugland
 
: Screenshot guided tutorial on how to import data into Openoffice.org Base.
 
: Screenshot guided tutorial on how to import data into Openoffice.org Base.
 +
 +
* New Features in 3.1
 +
: [[Base/New_features_in_3_1|New Features]]
 +
: Initial author: Reizinger Zoltán
 +
: Compiled from mailing list
 +
 +
* New Features in 3.2
 +
: [[Base/New_features_in_3_2|New Features]]
 +
: Initial author: Reizinger Zoltán
 +
: Compiled from mailing list
 +
 +
* New Features in 3.3
 +
: [[Base/New_features_in_3_3|New Features]]
 +
: Initial author: Reizinger Zoltán
 +
: Compiled from mailing list
 +
 +
* New Features in 3.4
 +
: [[Base/New_features_in_3_4|New Features]]
 +
: Initial author: Reizinger Zoltán
 +
: Compiled from mailing list
  
 
=== Tables ===
 
=== Tables ===
  
* [http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema Standard Distributed Schema]
+
* [[Standard Distributed Schema]]
  
 
=== Queries ===
 
=== Queries ===
* [http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Available functions and stored procedures]
+
* [[Built-in functions and Stored Procedures]]
  
 
=== Reports ===
 
=== Reports ===
* Sun Report Builder  
+
* [[SUN Report Builder]]
: [http://wiki.services.openoffice.org/wiki/SUN_Report_Builder SUN_Report_Builder]  
+
 
: ''description followed''
 
: ''description followed''
  
 
* Sun Report Builder (Reference)
 
* Sun Report Builder (Reference)
: [http://wiki.pentaho.org/display/Reporting/Pentaho+Reporting+Latest Reference]  
+
: [http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+Community+Documentation Reference]  
: ''description follow''''
+
: ''description follow ''
 +
 
 +
* Sun Report Builder Documentation
 +
: [[SUN_Report_Builder/Documentation|Documentation]]
 +
: Basic Features
  
 
* Functions in Reports
 
* Functions in Reports
: [http://wiki.pentaho.org/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
+
: [http://wiki.pentaho.com/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
: ''description follow
+
: ''description followed''
 +
 
 +
* Functions in Reports
 +
: [[SUN Report Builder/Functions]]
 +
: ''description followed''
  
 
=== Developer ===
 
=== Developer ===
 
* Working basis to make the user guide better  
 
* Working basis to make the user guide better  
: [http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base Getting_Started/Getting_Started_with_Base]  
+
: [[Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base | Getting_Started/Getting_Started_with_Base]]
 
: ''description followed''
 
: ''description followed''
  
 
* Using Macros in Database Files
 
* Using Macros in Database Files
: [http://wiki.services.openoffice.org/wiki/Macros_in_Database_Documents Macros_in_Database_Documents]
+
: [[Macros_in_Database_Documents | Macros_in_Database_Documents]]
: 'Specification to develope this functionality
+
: 'Specification to develop this functionality
  
 
=== FAQ ===
 
=== FAQ ===
 +
*FAQ (Base)
 +
: [[FAQ_(Base)|FAQ_(Base)]]
 +
 
* Common tasks
 
* Common tasks
: [http://wiki.services.openoffice.org/wiki/Common_tasks Common_tasks]
+
: [[Common_tasks | Common_tasks]]
: Initial author: Andrew 'Drew' Jensen
+
: Initial author: Andrew 'Drew' Jensen
: Many good questions, no answers.  
+
: Many good questions, no answers.
  
 
=== Misc ===
 
=== Misc ===
 
* HSQLDB Tips and Tricks
 
* HSQLDB Tips and Tricks
: [http://wiki.services.openoffice.org/wiki/HSQLDB:Tips_and_Tricks Tips_and_Tricks]  
+
: [[HSQLDB:Tips_and_Tricks | Tips_and_Tricks]]
 
: ''description followed''
 
: ''description followed''
  
* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]
+
* [https://web.archive.org/web/20071005143043/http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]
 
+
* [http://www.baseusers.com/index.html http://www.baseusers.com/index.html]
+
  
 
== Connecting ==
 
== Connecting ==
 
* Base New Driver Tutorial
 
* Base New Driver Tutorial
 
+
: [[Base_New_Driver_Tutorial]]  
[http://wiki.services.openoffice.org/wiki/Base_New_Driver_Tutorial http://wiki.services.openoffice.org/wiki/Base_New_Driver_Tutorial]  
+
: Initial author: Robert Vojta
 
+
: This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
Initial author: Robert Vojta
+
 
+
This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
+
  
 
* Better Database Drivers  
 
* Better Database Drivers  
 
+
: [[BetterDatabaseDrivers]]  
[http://wiki.services.openoffice.org/wiki/BetterDatabaseDrivers http://wiki.services.openoffice.org/wiki/BetterDatabaseDrivers]  
+
: Initial author:Eric Bischoff
 
+
:Some ideas for a better and simpler infrastructure for database drivers
Initial author:Eric Bischoff
+
 
+
Some ideas for a better and simpler infrastructure for database drivers
+
  
 
* Connecting to Microsoft Access
 
* Connecting to Microsoft Access
 +
: [[Connecting_to_Microsoft_Access]]
 +
: Initial author: Regina Henschel
 +
: These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
  
[http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access]
+
* OpenOffice Base - Database Drivers
 
+
: [https://www.openoffice.org/dba/drivers/ https://www.openoffice.org/dba/drivers/]  
Initial author: Regina Henschel
+
 
+
These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
+
 
+
* OpenOffice.org Base - Database Drivers
+
 
+
[http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/]  
+
  
 
* Connecting with MySQL
 
* Connecting with MySQL
 +
: [[Connect_MySQLandBase]]
  
[http://wiki.services.openoffice.org/wiki/Connect_MySQLandBase http://wiki.services.openoffice.org/wiki/Connect_MySQLandBase]
+
* An overview page
 
+
: Native PostgreSQL Driver
An overview page
+
: [https://www.openoffice.org/dba/drivers/postgresql/index.html https://www.openoffice.org/dba/drivers/postgresql/index.html]  
 
+
* Native PostgreSQL Driver
+
 
+
[http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html]  
+
  
 
* SQL-lite Driver
 
* SQL-lite Driver
 
+
: [https://www.openoffice.org/dba/drivers/sqlite/index.html https://www.openoffice.org/dba/drivers/sqlite/index.html]
http://dba.openoffice.org/drivers/sqlite/index.html
+
  
 
* mdb-sdbc-driver-0.1.0
 
* mdb-sdbc-driver-0.1.0
 
+
: [https://www.openoffice.org/dba/drivers/mdb/index.html https://www.openoffice.org/dba/drivers/mdb/index.html]
[http://dba.openoffice.org/drivers/mdb/index.html http://dba.openoffice.org/drivers/mdb/index.html]
+
: Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
 
+
: It is a try to connect a Linux system to MS Access. There is no further development.
Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
+
 
+
It is a try to connect a Linux system to MS Access. There is no further development.
+
  
 
* A working page
 
* A working page
 
+
: [[MDB_Driver_Integration]]
[http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration]
+
  
 
* MSA-Base Faq
 
* MSA-Base Faq
 
+
: [[MSA-Base_Faq]]
[http://wiki.services.openoffice.org/wiki/MSA-Base_Faq http://wiki.services.openoffice.org/wiki/MSA-Base_Faq]
+
  
 
* Firebird driver update for OO.org
 
* Firebird driver update for OO.org
[http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]
+
: [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]
 +
 
 +
* Using csv/text files as editable data source.
 +
: [https://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 OOo users forum Tutorial]
  
 
== Examples ==
 
== Examples ==
 
=== General ===
 
=== General ===
 
* Base Example (Overview)
 
* Base Example (Overview)
 
+
: [[Category:Base_Example]]
[http://wiki.services.openoffice.org/wiki/Category:Base_Example http://wiki.services.openoffice.org/wiki/Category:Base_Example]
+
: Initial author: Frank Schönheit
 
+
Initial author: Frank Schönheit
+
  
 
* Standard Distributed Schema
 
* Standard Distributed Schema
 
+
: [[Standard_Distributed_Schema]]
[http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema]
+
  
 
=== Concrete Examples ===
 
=== Concrete Examples ===
 
* A club membership database
 
* A club membership database
 +
: [[A_club_membership_database]]
 +
: Initial author: Andrew 'Drew' Jensen ✞
 +
: Description of creating an example database
  
[http://wiki.services.openoffice.org/wiki/A_club_membership_database http://wiki.services.openoffice.org/wiki/A_club_membership_database]
+
* OpenOffice.org API - Code snippets
 +
: [https://web.archive.org/web/20130928070355/http://codesnippets.services.openoffice.org/Database/index.xml http://codesnippets.services.openoffice.org/Database/index.xml]
 +
: Useful code snippets solving frequently asked questions.
  
Initial author: Andrew 'Drew' Jensen
+
* Base Example
 +
: [[Help_Files]]
  
Description of creating an example database
+
* Three table example, with supporting essay- Project management
 
+
: [http://sheepdogguides.com/fdb/fdb7peopproj.htm Link to essay, which has link to download a small database]
* OpenOffice.org API - Code snippets: [http://codesnippets.services.openoffice.org/Database/index.xml http://codesnippets.services.openoffice.org/Database/index.xml] <br/> Useful code snippets solving frequently asked questions.
+
: The database illustrates techniques explained in the essay. It is provided as an illustration, not for the data it contains.
  
 
* Base Example
 
* Base Example
 +
: [[File:DerbyToursDB.odb]]
  
http://wiki.services.openoffice.org/wiki/Help_Files
+
== Misc ==
  
http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema
+
* [https://forum.openoffice.org/en/forum/viewforum.php?f=13 AOo Community Forum]
 +
: Initial author: Andrew 'Drew' Jensen ✞
 +
: Starting Point for all kind of AOo Database Questions
  
== Misc ==
 
 
== Testing ==
 
== Testing ==
* [http://wiki.services.openoffice.org/wiki/Database_Automatic_Testing http://wiki.services.openoffice.org/wiki/Database_Automatic_Testing]
 
* [http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning]
 
* [http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29 http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29]
 
  
 +
* Main Point of AOo Database Testing
 +
: [https://www.openoffice.org/qa/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html AOo Database QA Team Site]
 +
: Initial Author: [[User:Clu Christoph Lukasiak]]
 +
 +
* Main Starter Document for QA Newbies
 +
: [https://www.openoffice.org/qa/ooQAReloaded/Docs/QA-Reloaded-HowToStart.html AOo QA How to Start Document]
 +
: Initial Author: [[User:Wg Wolfram Garten]]
  
* [http://wiki.services.openoffice.org/wiki/OOoHelpOutline#Base_and_Database http://wiki.services.openoffice.org/wiki/OOoHelpOutline#Base_and_Database]
+
* [[Database_Automatic_Testing]]
 +
* [[Documentation/OOoAuthors_User_Manual/Base_Guide/Planning |Base_Guide-Planning]]
 +
* [[FAQ_%28Base%29 |FAQ Base]]
 +
* [[OOoHelpOutline#Base_and_Database Base_and_Database]]
  
*
 
 
* [http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm]  
 
* [http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm]  
Connecting OpenOffice.org To A Remote MySQL Database] (event. 1.x)
+
: Connecting OpenOffice.org To A Remote MySQL Database] (event. 1.x)
 +
 
 +
= French  =
 +
 
 +
The following Links are showing French documents. If someone translate them we can show here the corresponding links.
 +
 
 +
*[[FR/Documentation/HSQLDB Guide]]
 +
*[[FR/Documentation/Base/Nouvelles Fonctions 3 1]]
  
= French =
 
 
= German =
 
= German =
http://wiki.services.openoffice.org/wiki/DE:Beispielsdatenbank_mit_Base
 
  
http://dannenhoefer.de/faqstarbasic/Datenbanken.html
+
The following Links are showing German documents. If someone translate them we can show here the correponding links.
  
http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0
+
* [[DE/Beispielsdatenbank_mit_Base]]
  
http://wiki.services.openoffice.org/wiki/DE:FAQ/Base
+
* https://dannenhoefer.de/faqstarbasic/Datenbanken.html
  
End user documentation
+
* https://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0
* http://www.ooowiki.de/KategorieBase
+
  
 +
* [[DE/FAQ/Base]]
 +
 +
* End user documentation
 +
: https://www.ooowiki.de/KategorieBase
 +
 +
* [[OpenOffice_per_JDBC_an_Informix | Anbindung von OpenOffice an Informix per JDBC]]
  
 
= Portugese =
 
= Portugese =
 +
 +
The following Links are showing Portugese documents. If someone translate them we can show here the correponding links.
  
 
http://broffice.org/files/Introdu%C3%A7%C3%A3o_ao%20BrOffice.org_Base_2.0.x.odt
 
http://broffice.org/files/Introdu%C3%A7%C3%A3o_ao%20BrOffice.org_Base_2.0.x.odt
 +
 +
=Español=
 +
El siguiente Links esta escrito en español.
 +
 +
http://wiki.services.openoffice.org/wiki/ES/Database
  
 
=Copyright=
 
=Copyright=
  
[http://dba.openoffice.org/ OOo Database Development]<br>
+
[https://www.openoffice.org/dba/ AOO Database Development]<br>
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
+
[https://www.openoffice.org/qa/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html AOO Database QA]<br>
[http://wiki.services.openoffice.org/wiki/Category:Database OOo General Database Info]<br>
+
[https://wiki.openoffice.org/wiki/Category:Database AOO General Database Info]<br>
 
<br>
 
<br>
 
<br>
 
<br>
''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann]  24 September 2007''<br>
+
: ''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann]  24 September 2007''
''Please do not change the logical content of this site without acknowledge of the author or the [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads]. This side is linked by the online help.''
+
: This page is under [http://creativecommons.org/licenses/by-sa/3.0/legalcode CC by-sa] since 2009-02-02
 +
:''Please do not change the logical content of this site without acknowledge of the author or the [https://wiki.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads]. This side is linked by the online help.''
 +
 
 +
<div id="Template_CC-BY-SA">
 +
{|align="left" width="100%" border="0" cellspacing="4" cellpadding="0" style="border-top: 1px solid #666; font-size: xx-small; margin-top: 20px; text-align: right;"
 +
| Content on this page is licensed under the [http://creativecommons.org/licenses/by-sa/3.0/legalcode Creative Common Attribution 3.0 license (CC BY-SA)].
 +
|}
 +
</div>
  
 
[[Category:Quality Assurance]]
 
[[Category:Quality Assurance]]
 
[[Category:Database]]
 
[[Category:Database]]
 +
[[Category:Base_Tutorials]]
 +
[[Category:Project]]
 +
[[Category:Files]]
 +
[[Category:PDF]]
 +
[[fa:FA/Localization:Database]]

Latest revision as of 14:51, 2 August 2022

Base Icon.png

Base Project

Please view the guidelines
before contributing.

DBA.OpenOffice.org

There are documents also in DE - FR - ES -PT


This page is hosted by the OO Database Docu Coordinator, who are members of the OOo Database QA Team. You can find here links to Base documentation ordered by languages and topics. Feel free to add missing documents to this list.

This documentation describes basic functionality about Apache- /Libre- /Star- Office Base which doesn't change.

Resources related to Apache OpenOffice Base:

English

The following links are in English.

Manuals

General

  • Forum
Lots of Base examples and answers to questions in the Base Forum
  • Base
Database
Description of the features of OpenOffice Base (short overview), Documentation resources and official sites
  • OpenOffice.org User Guides (Getting Started with Base)
Getting Started with Base - PDF
or Getting Started with Base wiki version
Learn how to create a database, queries, forms and reports and connect to and use other data sources within Apache OpenOffice Base.
  • Base Guide
Base Guide Planning
Base Guide Outline Proposal from OOoAuthors
  • Mid Level Base Tutorial
Mid Level Base Tutorial and the subsequent SQL Base Tutorial SQL code
Initial Authors: Mariano Casanova, Andrew 'Drew' Jensen ✞
  • Beginners - Example Database - Base Tutorial
Example
Initial author: Andrew 'Drew' Jensen ✞
This tutorial covers creating a first database using OOo Base. It is intended for those that have not used Base before or those that have never used any database manager.
  • Beginners - Example Database - "MELOMAN" Music Database
Initial author: Vlad Seredkine
Database presentation
“MELOMAN” Open Office Music Database
“Meloman_User_Guide”
“MELOMAN Open Office 3.1 Data Base Application. Internal Design Specification”
“Meloman test cases”
  • Base and Macros
Pitonyak's document
Initial author: Andrew Pitonyak
This documentation focuses on operating a database with the help of OpenOffice Macros.
  • Database: "ooBase", aka "Base"- From getting started to more advanced
Tutorials and "How to"s... 45 from one author at Sheepdogguides.com
Initial author: TK Boyd
Both specific tasks and fundamental skills are explained.
A section introducing the use of macros added 5/09.
  • Bringing data into OpenOffice 2.0's database
Database
Initial author: Solveig Haugland ✞
Screenshot guided tutorial on how to import data into Openoffice.org Base.
  • New Features in 3.1
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list
  • New Features in 3.2
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list
  • New Features in 3.3
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list
  • New Features in 3.4
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list

Tables

Queries

Reports

description followed
  • Sun Report Builder (Reference)
Reference
description follow
  • Sun Report Builder Documentation
Documentation
Basic Features
  • Functions in Reports
Functions and Expressions
description followed
  • Functions in Reports
SUN Report Builder/Functions
description followed

Developer

  • Working basis to make the user guide better
Getting_Started/Getting_Started_with_Base
description followed
  • Using Macros in Database Files
Macros_in_Database_Documents
'Specification to develop this functionality

FAQ

  • FAQ (Base)
FAQ_(Base)
  • Common tasks
Common_tasks
Initial author: Andrew 'Drew' Jensen ✞
Many good questions, no answers.

Misc

  • HSQLDB Tips and Tricks
Tips_and_Tricks
description followed

Connecting

  • Base New Driver Tutorial
Base_New_Driver_Tutorial
Initial author: Robert Vojta
This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
  • Better Database Drivers
BetterDatabaseDrivers
Initial author:Eric Bischoff
Some ideas for a better and simpler infrastructure for database drivers
  • Connecting to Microsoft Access
Connecting_to_Microsoft_Access
Initial author: Regina Henschel
These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
  • OpenOffice Base - Database Drivers
https://www.openoffice.org/dba/drivers/
  • Connecting with MySQL
Connect_MySQLandBase
  • An overview page
Native PostgreSQL Driver
https://www.openoffice.org/dba/drivers/postgresql/index.html
  • SQL-lite Driver
https://www.openoffice.org/dba/drivers/sqlite/index.html
  • mdb-sdbc-driver-0.1.0
https://www.openoffice.org/dba/drivers/mdb/index.html
Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
It is a try to connect a Linux system to MS Access. There is no further development.
  • A working page
MDB_Driver_Integration
  • MSA-Base Faq
MSA-Base_Faq
  • Firebird driver update for OO.org
Jaybird OpenOffice.org Base support
  • Using csv/text files as editable data source.
OOo users forum Tutorial

Examples

General

  • Base Example (Overview)
Initial author: Frank Schönheit
  • Standard Distributed Schema
Standard_Distributed_Schema

Concrete Examples

  • A club membership database
A_club_membership_database
Initial author: Andrew 'Drew' Jensen ✞
Description of creating an example database
  • OpenOffice.org API - Code snippets
http://codesnippets.services.openoffice.org/Database/index.xml
Useful code snippets solving frequently asked questions.
  • Base Example
Help_Files
  • Three table example, with supporting essay- Project management
Link to essay, which has link to download a small database
The database illustrates techniques explained in the essay. It is provided as an illustration, not for the data it contains.
  • Base Example
File:DerbyToursDB.odb

Misc

Initial author: Andrew 'Drew' Jensen ✞
Starting Point for all kind of AOo Database Questions

Testing

  • Main Point of AOo Database Testing
AOo Database QA Team Site
Initial Author: User:Clu Christoph Lukasiak
  • Main Starter Document for QA Newbies
AOo QA How to Start Document
Initial Author: User:Wg Wolfram Garten
Connecting OpenOffice.org To A Remote MySQL Database] (event. 1.x)

French

The following Links are showing French documents. If someone translate them we can show here the corresponding links.

German

The following Links are showing German documents. If someone translate them we can show here the correponding links.

  • End user documentation
https://www.ooowiki.de/KategorieBase

Portugese

The following Links are showing Portugese documents. If someone translate them we can show here the correponding links.

http://broffice.org/files/Introdu%C3%A7%C3%A3o_ao%20BrOffice.org_Base_2.0.x.odt

Español

El siguiente Links esta escrito en español.

http://wiki.services.openoffice.org/wiki/ES/Database

Copyright

AOO Database Development
AOO Database QA
AOO General Database Info


Initial author : Mechtilde Stehmann 24 September 2007
This page is under CC by-sa since 2009-02-02
Please do not change the logical content of this site without acknowledge of the author or the OOo QA Project Lead/Co-Leads. This side is linked by the online help.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC BY-SA).
Personal tools
In other languages