Apache OpenOffice Wiki - User contributions [en]

User:HCPotter

2011-07-31T12:38:35Z

HCPotter:

DerbyToursDB.odb implements the Derby Tours database available as
described in the ToursDB_schema.sql file with augmentation and
normalization for OpenOffice.org 2.4.1 operating on Windows XP
SP1. This database should be useful for learning to use Base and
for planning and testing development.

:[[Base#Concrete Examples]]
:[[Concrete Examples]]
:[[Documentation/Database#Wiki Articles and more]]
:[[Base To-Do#Embed Derby into OpenOffice.org databases]]
:[[Base To-Do#Enable Picture Insertion]]
:[[Base To-Do#Discuss Remote Operation Necessity]]

User:HCPotter/Concrete Examples

2011-07-31T12:36:23Z

HCPotter:

User:HCPotter/Concrete Examples

2011-07-31T12:28:34Z

HCPotter:

File:ToursDB schema.sql

2011-07-31T12:24:26Z

HCPotter:

Schema for Derby.Apache.org example database, Tours, implemented with augmentation for OpenOffice.org Base as
[[File:DerbyToursDB.odb]]

File:ToursDB schema.sql

2011-07-31T12:22:39Z

HCPotter:

Schema for Derby.Apache.org example database, Tours, implemented with augmentation for openoffice.org Base as
[[File:DerbyToursDB.odb]]

User:HCPotter

2011-07-31T12:18:26Z

HCPotter:

DerbyToursDB.odb implements the Derby Tours database available as
described in the ToursDB_schema.sql file with augmentation and
normalization for OpenOffice.org 2.4.1 operating on Windows XP
SP1. This database should be useful for learning to use Base and
for planning and testing development.

:[[File:ToursDB schema.sql]]
:[[Base#Concrete Examples]]
:[[Concrete Examples]]
:[[Documentation/Database#Wiki Articles and more]]
:[[Base To-Do#Embed Derby into OpenOffice.org databases]]
:[[Base To-Do#Enable Picture Insertion]]
:[[Base To-Do#Discuss Remote Operation Necessity]]

File:DerbyToursDB.odb

2011-07-31T12:17:02Z

HCPotter:

File:DerbyToursDB.odb

2011-07-31T09:36:32Z

HCPotter:

File:DerbyToursDB.odb

2011-07-31T09:27:11Z

HCPotter:

File:DerbyToursDB.odb

2011-07-31T09:15:35Z

HCPotter:

Database

2011-06-19T08:17:24Z

HCPotter: /* Concrete Examples */

{{Template:Base Project}}
{{Database/Lang|Database}}

This page is hosted by the [http://wiki.services.openoffice.org/wiki/Database_Docu_Coordinator OOo Database Docu Coordinator], who are members of the [http://qa.openoffice.org/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:

= English =
The following links are in English.
== Manuals ==
=== General ===
* Base
: [[Documentation/Database | Database]]
: Description of the features of OpenOffice.org Base (short overview), Documentation resources and official sites

* OpenOffice.org User Guides (Getting Started with Base)
: [http://wiki.services.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 OOo-Base.

* Base Guide
:[[Documentation/OOoAuthors_User_Manual/Base_Guide/Planning|Base Guide Planning]]
:Base Guide Outline Proposal from OOoAuthors

* Mid Level Base Tutorial
: [http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial Mid Level Base Tutorial]
: Initial Authors: Mariano Casanova, Andrew 'Drew' Jensen

* Beginners - Example Database - Base Tutorial
: [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
: 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.

* Base and Macros
: [http://www.pitonyak.org/database/ Pitonyak's document]
: Initial author: Andrew Pitonyak
: This documentation focuses on operating a database with the help of OpenOffice.org Macros.

* Database: "ooBase", aka "Base"- From getting started to more advanced
: [http://sheepdogguides.com/fdb/fdb1main.htm 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
: [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Database]
: Initial author: Solveig Haugland
: 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 ===

* [[Standard Distributed Schema]]

=== Queries ===
* [[Built-in functions and Stored Procedures]]

=== Reports ===
* [[SUN Report Builder]]
: ''description followed''

* Sun Report Builder (Reference)
: [http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+Community+Documentation Reference]
: ''description follow ''

* Sun Report Builder Documentation
: [[SUN_Report_Builder/Documentation|Documentation]]
: Basic Features

* Functions in Reports
: [http://wiki.pentaho.com/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
: ''description followed''

* Functions in Reports
: [[SUN Report Builder/Functions]]
: ''description followed''

=== Developer ===
* Working basis to make the user guide better
: [[Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base | Getting_Started/Getting_Started_with_Base]]
: ''description followed''

* Using Macros in Database Files
: [[Macros_in_Database_Documents | Macros_in_Database_Documents]]
: 'Specification to develope this functionality

=== FAQ ===
*FAQ (Base)
: [[FAQ_(Base)|FAQ_(Base)]]

* Common tasks
: [[Common_tasks | Common_tasks]]
: Initial author: Andrew 'Drew' Jensen
: Many good questions, no answers.

=== Misc ===
* HSQLDB Tips and Tricks
: [[HSQLDB:Tips_and_Tricks | Tips_and_Tricks]]
: ''description followed''

* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]

== 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.org Base - Database Drivers
: [http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/]

* Connecting with MySQL
: [[Connect_MySQLandBase]]

* An overview page
: Native PostgreSQL Driver
: [http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html]

* SQL-lite Driver
: http://dba.openoffice.org/drivers/sqlite/index.html

* mdb-sdbc-driver-0.1.0
: [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.

* A working page
: [[MDB_Driver_Integration]]

* MSA-Base Faq
: [[MSA-Base_Faq]]

* Firebird driver update for OO.org
: [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]

* Using csv/text files as editable data source.
: [http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 OOo users forum Tutorial]

== Examples ==
=== General ===
* Base Example (Overview)
: [[Category:Base_Example]]
: 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 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
: [http://sheepdogguides.com/fdb/fdb7peopproj.htm 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 ==

* [http://user.services.openoffice.org/en/forum/viewforum.php?f=13 OOo Community Forum]
: Initial author: Andrew 'Drew' Jensen
: Starting Point for all kind of OOo Database Questions

== Testing ==

* Main Point of OOo Database Testing
: [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA Team Site]
: Initial Author: [[User:Clu Christoph Lukasiak]]

* Main Starter Document for QA Newbies
: [http://qa.openoffice.org/ooQAReloaded/Docs/QA-Reloaded-HowToStart.html OOo QA How to Start Document]
: Initial Author: [[User:Wg Wolfram Garten]]

* [[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]
: 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]]

= German =

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

* [[DE/Beispielsdatenbank_mit_Base]]

* http://dannenhoefer.de/faqstarbasic/Datenbanken.html

* http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0

* [[DE/FAQ/Base]]

* End user documentation
: http://www.ooowiki.de/KategorieBase

* [[OpenOffice_per_JDBC_an_Informix | Anbindung von OpenOffice an Informix per JDBC]]

= 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=

[http://dba.openoffice.org/ OOo Database Development]<br>
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
[http://wiki.services.openoffice.org/wiki/Category:Database OOo General Database Info]<br>
<br>
<br>
: ''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann] 24 September 2007''
: 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 [http://wiki.services.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:Database]]
[[Category:Project]]
[[fa:FA/Localization:Database]]

File:ToursDB schema.sql

2011-06-10T08:02:29Z

HCPotter:

Schema for Derby.Apache.org example database, Tours.
[[File:DerbyToursDB.odb]]

User:HCPotter

2010-06-14T09:03:12Z

HCPotter:

DerbyToursDB.odb implements the Derby Tours database available as
described in the ToursDB_schema.sql file with augmentation and
normalization for OpenOffice.org 2.4.1 operating on Windows XP
SP1. This database should be useful for learning to use Base and
for planning and testing development.

:[[File:DerbyToursDB.odb]]
:[[File:ToursDB schema.sql]]
:[[Base#Concrete Examples]]
:[[Concrete Examples]]
:[[Documentation/Database#Wiki Articles and more]]
:[[Base To-Do#Embed Derby into OpenOffice.org databases]]
:[[Base To-Do#Enable Picture Insertion]]
:[[Base To-Do#Discuss Remote Operation Necessity]]

Base To-Do

2010-06-14T09:00:25Z

HCPotter:

Below is a list of [[Base]]-related projects which could be implemented by interested developers. Most of these projects are relatively self-contained, and do not require too much knowledge about OOo's code infrastructure.

Note that the actual project descriptions are not yet moved to this place here, they still reside [http://dba.openoffice.org/development/projects.html one of the project's static pages]. Your'e encourage to visit this page, as it contains much more information currently.

(So if you want, one of the To-Dos of our project is to move the To-Dos from http://dba.openoffice.org/development/projects.html to this Wiki page.)

== Joins in dBase queries ==

The content of this item moved to a dedicated page: [[Base_To-Do/Joins_in_dBase_queries]]

== SDBC driver for LDAP directories ==

The content of this item moved to a dedicated page: [[Base_To-Do/SDBC_driver_for_LDAP_directories]]

== New/Enhanced Form Controls ==

The content of this item moved to a dedicated page: [[Base_To-Do/New+Enhanced_Form_Controls]]

== Dialogs with Form Functionality ==

The content of this item moved to a dedicated page: [[Base_To-Do/Dialogs_with_Form_Functionality]]

== Database driver UI modularization ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#driver_modules here].

== HSQLDB: single-file backend ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#single_file_backend here].

== Embed Derby into OpenOffice.org databases ==

OpenOffice.org Base features an abstract mechanism to embed database backend files into OOo databases (.odb). Currently, this is implemented for [http:///hsqldb.org HSQLDB], which is used as OOo's default database engine.

To allow this feature for other engines, one must:

* virtualize the engine's file access, so that it re-routes all its file operations through an abstract API.
* implement this API on the OOo Base side

The project is to do those implementations for [http://db.apache.org/derby Apache Derby database].

* required skills Java, C++
* useful skills: OOo's database access API, OOo's component technology (UNO)
* Contact: mailto:dev@dba.openoffice.org
* effort: 2 months
* difficulty: high

See also:
* [[File:DerbyToursDB.odb]]
* [[User:HCPotter]]

== Native, cross-platform access to MS Access databases ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#cross_access here].

== SDBC driver for vCards ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#vcards here].

== New Filter Dialog ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#new_filter here].

== Enable Picture Insertion ==

:For example uses see table MAPS in [[File:ToursDB_schema.sql]] and [[File:DerbyToursDB.odb]]. [[User:HCPotter|HCPotter]]

== Discuss Remote Operation Necessity ==

:When [[File:DerbyToursDB.odb]] is downloaded it can be used only when saved for local access. I have not tried the external application editing option. [[User:HCPotter|HCPotter]] 09:00, 14 June 2010 (UTC)

<noinclude>[[Category:Database]][[Category:To-Do]]</noinclude>

User:HCPotter

2010-06-14T08:42:59Z

HCPotter:

DerbyToursDB.odb implements the Derby Tours database available as
described in the ToursDB_schema.sql file with augmentation and
normalization for OpenOffice.org 2.4.1 operating on Windows XP
SP1. This database should be useful for learning to use Base and
for planning and testing development.

:[[File:DerbyToursDB.odb]]
:[[File:ToursDB schema.sql]]
:[[Base#Concrete Examples]]
:[[Concrete Examples]]
:[[Documentation/Database#Wiki Articles and more]]
:[[Base To-Do#Embed Derby into OpenOffice.org databases]]
:[[Base To-Do#Enable Picture Insertion]]

Base To-Do

2010-06-14T08:40:12Z

HCPotter:

Below is a list of [[Base]]-related projects which could be implemented by interested developers. Most of these projects are relatively self-contained, and do not require too much knowledge about OOo's code infrastructure.

Note that the actual project descriptions are not yet moved to this place here, they still reside [http://dba.openoffice.org/development/projects.html one of the project's static pages]. Your'e encourage to visit this page, as it contains much more information currently.

(So if you want, one of the To-Dos of our project is to move the To-Dos from http://dba.openoffice.org/development/projects.html to this Wiki page.)

== Joins in dBase queries ==

The content of this item moved to a dedicated page: [[Base_To-Do/Joins_in_dBase_queries]]

== SDBC driver for LDAP directories ==

The content of this item moved to a dedicated page: [[Base_To-Do/SDBC_driver_for_LDAP_directories]]

== New/Enhanced Form Controls ==

The content of this item moved to a dedicated page: [[Base_To-Do/New+Enhanced_Form_Controls]]

== Dialogs with Form Functionality ==

The content of this item moved to a dedicated page: [[Base_To-Do/Dialogs_with_Form_Functionality]]

== Database driver UI modularization ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#driver_modules here].

== HSQLDB: single-file backend ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#single_file_backend here].

== Embed Derby into OpenOffice.org databases ==

OpenOffice.org Base features an abstract mechanism to embed database backend files into OOo databases (.odb). Currently, this is implemented for [http:///hsqldb.org HSQLDB], which is used as OOo's default database engine.

To allow this feature for other engines, one must:

* virtualize the engine's file access, so that it re-routes all its file operations through an abstract API.
* implement this API on the OOo Base side

The project is to do those implementations for [http://db.apache.org/derby Apache Derby database].

* required skills Java, C++
* useful skills: OOo's database access API, OOo's component technology (UNO)
* Contact: mailto:dev@dba.openoffice.org
* effort: 2 months
* difficulty: high

See also:
* [[File:DerbyToursDB.odb]]
* [[User:HCPotter]]

== Native, cross-platform access to MS Access databases ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#cross_access here].

== SDBC driver for vCards ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#vcards here].

== New Filter Dialog ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#new_filter here].

== Enable Picture Insertion ==

:For example uses see table MAPS in [[File:ToursDB_schema.sql]] and [[File:DerbyToursDB.odb]]. [[User:HCPotter|HCPotter]]

<noinclude>[[Category:Database]][[Category:To-Do]]</noinclude>

User:HCPotter

2010-06-12T09:09:35Z

HCPotter:

DerbyToursDB.odb implements the Derby Tours database available as
described in the ToursDB_schema.sql file with augmentation and
normalization for OpenOffice.org 2.4.1 operating on Windows XP
SP1. This database should be useful for learning to use Base and
for planning and testing development.

:[[File:DerbyToursDB.odb]]
:[[File:ToursDB schema.sql]]
:[[Base#Concrete Examples]]
:[[Concrete Examples]]
:[[Documentation/Database#Wiki Articles and more]]
:[[Base To-Do#Embed Derby into OpenOffice.org databases]]

Base To-Do

2010-06-12T09:05:42Z

HCPotter: /* Embed Derby into OpenOffice.org databases */

Below is a list of [[Base]]-related projects which could be implemented by interested developers. Most of these projects are relatively self-contained, and do not require too much knowledge about OOo's code infrastructure.

Note that the actual project descriptions are not yet moved to this place here, they still reside [http://dba.openoffice.org/development/projects.html one of the project's static pages]. Your'e encourage to visit this page, as it contains much more information currently.

(So if you want, one of the To-Dos of our project is to move the To-Dos from http://dba.openoffice.org/development/projects.html to this Wiki page.)

== Joins in dBase queries ==

The content of this item moved to a dedicated page: [[Base_To-Do/Joins_in_dBase_queries]]

== SDBC driver for LDAP directories ==

The content of this item moved to a dedicated page: [[Base_To-Do/SDBC_driver_for_LDAP_directories]]

== New/Enhanced Form Controls ==

The content of this item moved to a dedicated page: [[Base_To-Do/New+Enhanced_Form_Controls]]

== Dialogs with Form Functionality ==

The content of this item moved to a dedicated page: [[Base_To-Do/Dialogs_with_Form_Functionality]]

== Database driver UI modularization ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#driver_modules here].

== HSQLDB: single-file backend ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#single_file_backend here].

== Embed Derby into OpenOffice.org databases ==

OpenOffice.org Base features an abstract mechanism to embed database backend files into OOo databases (.odb). Currently, this is implemented for [http:///hsqldb.org HSQLDB], which is used as OOo's default database engine.

To allow this feature for other engines, one must:

* virtualize the engine's file access, so that it re-routes all its file operations through an abstract API.
* implement this API on the OOo Base side

The project is to do those implementations for [http://db.apache.org/derby Apache Derby database].

* required skills Java, C++
* useful skills: OOo's database access API, OOo's component technology (UNO)
* Contact: mailto:dev@dba.openoffice.org
* effort: 2 months
* difficulty: high

See also:
* [[File:DerbyToursDB.odb]]
* [[User:HCPotter]]

== Native, cross-platform access to MS Access databases ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#cross_access here].

== SDBC driver for vCards ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#vcards here].

== New Filter Dialog ==

described in more detail at the [http://dba.openoffice.org/development/projects.html#new_filter here].

<noinclude>[[Category:Database]][[Category:To-Do]]</noinclude>

User:HCPotter

2010-06-11T08:57:45Z

HCPotter:

DerbyToursDB.odb implements the Derby Tours database available as
described in the ToursDB_schema.sql file with augmentation and
normalization for OpenOffice.org 2.4.1 operating on Windows XP
SP1. This database should be useful for learning to use Base and
for planning and testing development.

:[[File:DerbyToursDB.odb]]
:[[File:ToursDB schema.sql]]
:[[Base#Concrete Examples]]
:[[Concrete Examples]]
:[[Documentation/Database#Wiki Articles and more]]

Documentation/Database

2010-06-11T08:46:46Z

HCPotter: /* Wiki Articles and more */

{{Database/Lang|Documentation/Database}}
'''OpenOffice.org Base''' is the database application of [[OpenOffice.org]], similar to [[MSA-Base_Faq|Microsoft Access]]. Base allows the creation and manipulation of databases and the building of forms and reports to provide easy access to data for end-users. As with Access, Base is able to work as a front-end to a variety of database systems, including Access databases (JET), [[ODBC]] data sources, [[wikipedia:MySQL|MySQL]], and [[wikipedia:PostgreSQL|PostgreSQL]].

Base was not available in the 1.x versions of OpenOffice.org, becoming part of the suite starting with version 2.0. Base enables you to manipulate database data seamlessly within OpenOffice.org. Create and modify tables, forms, queries, and reports, either using your own database or Base’s own built-in [[wikipedia:HSQLDB|HSQLDB]] database engine. Base offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users.

==Features==
With Base, you can:

* Create new tables for your data - and also change them as your needs change
* Maintain indexes on the tables to make data access faster
* View a table in an editing grid and add, change, and delete records
* Use the Report Wizard to produce impressive reports from your data
* Use the Form Wizard to create 'instant' database applications

Using Base, you can not only browse your data, but also:

* Perform simple (single column) or complex (multi-column) sorts
* View subsets of your data with simple (one-click) or complex (logical query) filters
* Create powerful queries to show your data in new ways, including summaries and multi-table views
* Produce reports
** The Base module includes the Report Wizard for creating quick tabular reprts
** With Version 2.3 the [[SUN Report Builder]] is available as an extension for more complex reporting needs
* Base allows you to extend it's functionality via built in scripting capabilities

BASE includes a full version of the [http://hsqldb.org/ HSQL] database engine. It can also access [[dBASE]] files natively for simple database work, but it cannot open MS-Access files natively.

For more advanced requirements, Base supports many popular databases database natively (Adabas D, ADO, Microsoft Access, MySQL), or any database through industry-standard [[ODBC]] and [[JDBC]] drivers. It also supports any [[LDAP]] compliant address book, as well as common formats such as Microsoft Outlook, Microsoft Windows, and [[Mozilla]].

==Resources==
===User Documentation===
* [[Documentation/OOoAuthors User Manual/Getting Started/Getting Started with Base|Getting Started with Base]] on the wiki.
:: [http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf Getting started with Base] as single PDF file.
:: [http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf OOo2 User Guide] as single PDF file.
* [http://www.pitonyak.org/database/ Andrew Pitonyak's Base documents]
* [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials on using ooBase] from Sheepdog Guides
* [[/connectivity|Connecting]] with non-embedded databases
* [[/Reports|Working with reports]]

====Wiki Articles and more====
* The embedded data engine HSQLdb
** [[HSQLDB:Tips and Tricks]]
** [[HSQLDB Localization]]
** [[HSQL Text Table Integration]]
* [[SUN Report Builder]]
** DesktopLinux.com article April 2007[[http://www.desktoplinux.com/news/NS5712122864.html Chris Preimesberger]]
* [[Built-in functions and Stored Procedures|Base Query functions]]
* [[MSA-Base Faq|Working with MS Access files]]
* [[Standard Distributed Schema]]
* [[Bibliographic Database]]
* [[A club membership database]]
* DerbyToursDB [[User:HCPotter]]

===Technical Documentation===
* [http://dba.openoffice.org/specifications/index.html Specification Documents]
** [http://dba.openoffice.org/specifications/ReportDesigner.odt Sun Report Builder (SRB)]
** [http://dba.openoffice.org/specifications/Conditional%20Formatting.odt Conditional formatting dialog in SRB]
* [[Base New Driver Tutorial]]
*[[Logging JDBC Activity|Logging JDBC Activity]] new feature 2.?

== Official sites ==

* [http://dba.openoffice.org/ Base project page]
* [http://www.openoffice.org/product/base.html Base marketing page]
* [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html Base QA]

* '''the mailto and owner would need to be changed appropriately'''
: ''Maintainer: [mailto:atjensen@openoffice.org?subject:OOoWiki Base page] [[User:DrewJensen|Drew]] 21:01, 11 September 2007 (CEST) ''
: 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 [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads].''
<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:Database]]
[[Category:Base Documentation]]
[[Category:Quality Assurance]]

User:HCPotter/Concrete Examples

2010-06-11T07:40:41Z

HCPotter:

User:HCPotter

2010-06-11T07:38:56Z

HCPotter:

Database

2010-06-10T08:43:35Z

HCPotter: /* Concrete Examples */

{{Database/Lang|Database}}
This page is hosted by the [http://wiki.services.openoffice.org/wiki/Database_Docu_Coordinator OOo Database Docu Coordinator], who are members of the [http://qa.openoffice.org/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:

= English =
The following links are in English.
== Manuals ==
=== General ===
* Base
: [[Documentation/Database | Database]]
: Description of the features of OpenOffice.org Base (short overview), Documentation resources and official sites

* OpenOffice.org User Guides (Getting Started with Base)
: [http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf Getting Started with Base] - ''PDF''
: or Getting Started with Base [http://wiki.services.openoffice.org/wiki/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 OOo-Base.

* Base Guide
:[http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning Base Guide Planning]
:Base Guide Outline Proposal from OOoAuthors

* OpenOffice.org Base Manual
: [http://nothickmanuals.info/doku.php/articles:ooobaseprimer OpenOffice.org Base Primer]
: Initial Authors: Andrew 'Drew' Jensen, Frank Schoenheit, et al.
: A short screenshot-guided overview on how to use Base.

* Mid Level Base Tutorial
: [http://documentation.openoffice.org/servlets/ProjectDocumentList?folderID=778&expandFolder=778&folderID=597 Mid Level Base Tutorial]
: Innitial Authors: Mariano Casanova, Andrew 'Drew' Jensen

* Beginners - Example Database - Base Tutorial
: [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
: 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.

* Base and Macros
: [http://www.pitonyak.org/database/ Pitonyak's document]
: Initial author: Andrew Pitonyak
: This documentation focuses on operating a database with the help of OpenOffice.org Macros.

* Database: "ooBase", aka "Base"- From getting started to more advanced
: [http://sheepdogguides.com/fdb/fdb1main.htm 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
: [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Database]
: Initial author: Solveig Haugland
: 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

=== Tables ===

* [[Standard Distributed Schema]]

=== Queries ===
* [[Built-in functions and Stored Procedures]]

=== Reports ===
* [[SUN Report Builder]]
: ''description followed''

* Sun Report Builder (Reference)
: [http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+Community+Documentation Reference]
: ''description follow ''

* Sun Report Builder Documentation
: [[SUN_Report_Builder/Documentation|Documentation]]
: Basic Features

* Functions in Reports
: [http://wiki.pentaho.com/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
: ''description followed''

* Functions in Reports
: [[SUN Report Builder/Functions]]
: ''description followed''

=== Developer ===
* Working basis to make the user guide better
: [[Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base | Getting_Started/Getting_Started_with_Base]]
: ''description followed''

* Using Macros in Database Files
: [[Macros_in_Database_Documents | Macros_in_Database_Documents]]
: 'Specification to develope this functionality

=== FAQ ===
*FAQ (Base)
: [[FAQ_(Base)|FAQ_(Base)]]

* Common tasks
: [[Common_tasks | Common_tasks]]
: Initial author: Andrew 'Drew' Jensen
: Many good questions, no answers.

=== Misc ===
* HSQLDB Tips and Tricks
: [[HSQLDB:Tips_and_Tricks | Tips_and_Tricks]]
: ''description followed''

* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]

== 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.org Base - Database Drivers
: [http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/]

* Connecting with MySQL
: [[Connect_MySQLandBase]]

* An overview page
: Native PostgreSQL Driver
: [http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html]

* SQL-lite Driver
: http://dba.openoffice.org/drivers/sqlite/index.html

* mdb-sdbc-driver-0.1.0
: [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.

* A working page
: [[MDB_Driver_Integration]]

* MSA-Base Faq
: [[MSA-Base_Faq]]

* Firebird driver update for OO.org
: [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]

* Using csv/text files as editable data source.
: [http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 OOo users forum Tutorial]

== Examples ==
=== General ===
* Base Example (Overview)
: [[Category:Base_Example]]
: 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 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
: [http://sheepdogguides.com/fdb/fdb7peopproj.htm 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]]
: [[User:HCPotter]]

== Misc ==

* [http://user.services.openoffice.org/en/forum/viewforum.php?f=13 OOo Community Forum]
: Initial author: Andrew 'Drew' Jensen
: Starting Point for all kind of OOo Database Questions

== Testing ==

* Main Point of OOo Database Testing
: [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA Team Site]
: Initial Author: [[User:Clu Christoph Lukasiak]]

* Main Starter Document for QA Newbies
: [http://qa.openoffice.org/ooQAReloaded/Docs/QA-Reloaded-HowToStart.html OOo QA How to Start Document]
: Initial Author: [[User:Wg Wolfram Garten]]

* [[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]
: 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]]

= German =

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

* [[DE/Beispielsdatenbank_mit_Base]]

* http://dannenhoefer.de/faqstarbasic/Datenbanken.html

* http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0

* [[DE/FAQ/Base]]

* End user documentation
: http://www.ooowiki.de/KategorieBase

* [[OpenOffice_per_JDBC_an_Informix | Anbindung von OpenOffice an Informix per JDBC]]

= 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

=Copyright=

[http://dba.openoffice.org/ OOo Database Development]<br>
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
[http://wiki.services.openoffice.org/wiki/Category:Database OOo General Database Info]<br>
<br>
<br>
: ''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann] 24 September 2007''
: 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 [http://wiki.services.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:Database]]
[[Category:Project]]

User:HCPotter

2010-06-10T08:37:42Z

HCPotter:

User:HCPotter

2010-06-09T09:12:58Z

HCPotter:

User:HCPotter/Concrete Examples

2010-06-09T09:07:15Z

HCPotter:

User talk:B michaelsen

2010-06-08T09:24:22Z

HCPotter:

Hi B michaelsen

RE: categories on Documentation/OOo3_User_Guides/Writer_Guide/Customizing_toolbars

I didn't think I had, sorry, just updated the contents of the pages to reflect the pdf and removed a few sections.

Clairedwood

RE:you recently created the page Concrete Examples without categories. Please add categories to that page. see OOo_Wiki_Contribution_Rules for details. Thanks!

--B michaelsen 12:17, 7 June 2010 (UTC)
I did, but I'm new to the wiki and do not yet understand how it works. When I added page it was somewhere in the system, but I can't find where now. Your reference to ..._Rules does not help me understand how this system is supposed to work or how we new users are to become familiar with its operation. I presume level2headlines would add categories, but at this time I do not even know where the page I added is located in the system. Maybe you can clarify.
[[User:HCPotter]]

Database

2010-06-06T09:31:11Z

HCPotter: /* Concrete Examples */

{{Database/Lang|Database}}
This page is hosted by the [http://wiki.services.openoffice.org/wiki/Database_Docu_Coordinator OOo Database Docu Coordinator], who are members of the [http://qa.openoffice.org/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:

= English =
The following links are in English.
== Manuals ==
=== General ===
* Base
: [[Documentation/Database | Database]]
: Description of the features of OpenOffice.org Base (short overview), Documentation resources and official sites

* OpenOffice.org User Guides (Getting Started with Base)
: [http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf Getting Started with Base] - ''PDF''
: or Getting Started with Base [http://wiki.services.openoffice.org/wiki/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 OOo-Base.

* Base Guide
:[http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning Base Guide Planning]
:Base Guide Outline Proposal from OOoAuthors

* OpenOffice.org Base Manual
: [http://nothickmanuals.info/doku.php/articles:ooobaseprimer OpenOffice.org Base Primer]
: Initial Authors: Andrew 'Drew' Jensen, Frank Schoenheit, et al.
: A short screenshot-guided overview on how to use Base.

* Mid Level Base Tutorial
: [http://documentation.openoffice.org/servlets/ProjectDocumentList?folderID=778&expandFolder=778&folderID=597 Mid Level Base Tutorial]
: Innitial Authors: Mariano Casanova, Andrew 'Drew' Jensen

* Beginners - Example Database - Base Tutorial
: [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
: 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.

* Base and Macros
: [http://www.pitonyak.org/database/ Pitonyak's document]
: Initial author: Andrew Pitonyak
: This documentation focuses on operating a database with the help of OpenOffice.org Macros.

* Database: "ooBase", aka "Base"- From getting started to more advanced
: [http://sheepdogguides.com/fdb/fdb1main.htm 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
: [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Database]
: Initial author: Solveig Haugland
: 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

=== Tables ===

* [[Standard Distributed Schema]]

=== Queries ===
* [[Built-in functions and Stored Procedures]]

=== Reports ===
* [[SUN Report Builder]]
: ''description followed''

* Sun Report Builder (Reference)
: [http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+Community+Documentation Reference]
: ''description follow ''

* Sun Report Builder Documentation
: [[SUN_Report_Builder/Documentation|Documentation]]
: Basic Features

* Functions in Reports
: [http://wiki.pentaho.com/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
: ''description followed''

* Functions in Reports
: [[SUN Report Builder/Functions]]
: ''description followed''

=== Developer ===
* Working basis to make the user guide better
: [[Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base | Getting_Started/Getting_Started_with_Base]]
: ''description followed''

* Using Macros in Database Files
: [[Macros_in_Database_Documents | Macros_in_Database_Documents]]
: 'Specification to develope this functionality

=== FAQ ===
*FAQ (Base)
: [[FAQ_(Base)|FAQ_(Base)]]

* Common tasks
: [[Common_tasks | Common_tasks]]
: Initial author: Andrew 'Drew' Jensen
: Many good questions, no answers.

=== Misc ===
* HSQLDB Tips and Tricks
: [[HSQLDB:Tips_and_Tricks | Tips_and_Tricks]]
: ''description followed''

* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]

== 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.org Base - Database Drivers
: [http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/]

* Connecting with MySQL
: [[Connect_MySQLandBase]]

* An overview page
: Native PostgreSQL Driver
: [http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html]

* SQL-lite Driver
: http://dba.openoffice.org/drivers/sqlite/index.html

* mdb-sdbc-driver-0.1.0
: [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.

* A working page
: [[MDB_Driver_Integration]]

* MSA-Base Faq
: [[MSA-Base_Faq]]

* Firebird driver update for OO.org
: [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]

* Using csv/text files as editable data source.
: [http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 OOo users forum Tutorial]

== Examples ==
=== General ===
* Base Example (Overview)
: [[Category:Base_Example]]
: 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 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
: [http://sheepdogguides.com/fdb/fdb7peopproj.htm 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
: DerbyToursDB.odb
: [[User:HCPotter]]

== Misc ==

* [http://user.services.openoffice.org/en/forum/viewforum.php?f=13 OOo Community Forum]
: Initial author: Andrew 'Drew' Jensen
: Starting Point for all kind of OOo Database Questions

== Testing ==

* Main Point of OOo Database Testing
: [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA Team Site]
: Initial Author: [[User:Clu Christoph Lukasiak]]

* Main Starter Document for QA Newbies
: [http://qa.openoffice.org/ooQAReloaded/Docs/QA-Reloaded-HowToStart.html OOo QA How to Start Document]
: Initial Author: [[User:Wg Wolfram Garten]]

* [[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]
: 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]]

= German =

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

* [[DE/Beispielsdatenbank_mit_Base]]

* http://dannenhoefer.de/faqstarbasic/Datenbanken.html

* http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0

* [[DE/FAQ/Base]]

* End user documentation
: http://www.ooowiki.de/KategorieBase

* [[OpenOffice_per_JDBC_an_Informix | Anbindung von OpenOffice an Informix per JDBC]]

= 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

=Copyright=

[http://dba.openoffice.org/ OOo Database Development]<br>
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
[http://wiki.services.openoffice.org/wiki/Category:Database OOo General Database Info]<br>
<br>
<br>
: ''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann] 24 September 2007''
: 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 [http://wiki.services.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:Database]]
[[Category:Project]]

User:HCPotter/Concrete Examples

2010-06-06T09:19:51Z

HCPotter:

User:HCPotter

2010-06-06T09:13:44Z

HCPotter:

User:HCPotter/Concrete Examples

2010-06-06T09:04:11Z

HCPotter: Created page with 'DerbyToursDB.odb implements the Derby Tours database available as described in the ToursDB_schema.sql file with augmentation and normalization for OpenOffice.org 2.4.1 operatin…'

User:HCPotter

2010-06-04T09:20:08Z

HCPotter:

User:HCPotter

2010-06-03T09:08:54Z

HCPotter:

User:HCPotter

2010-06-03T09:02:33Z

HCPotter:

User:HCPotter

2010-06-03T08:42:27Z

HCPotter: DerbyToursDB.odb

User:HCPotter

2010-06-03T08:27:04Z

HCPotter: DerbyToursDB.odb

File:ToursDB schema.sql

2010-06-03T08:12:54Z

HCPotter: Schema for Derby.Apache.org example database, Tours.

Schema for Derby.Apache.org example database, Tours.