Database

Base Project Please view the guidelines before contributing.
Projects on this Wiki: (edit list) Art Project * Application Framework Documentation Education Project * Marketing Project * Native Language Confederation * Product Releases Security Team Universal Network Objects User Experience Project Website Project Writer Project
DBA.OpenOffice.org View or edit this template.

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

• Standard Distributed Schema

Queries

• Built-in functions and Stored Procedures

Reports

• SUN Report Builder

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

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

• AOo Community Forum

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

• Database_Automatic_Testing
• Base_Guide-Planning
• FAQ Base
• OOoHelpOutline#Base_and_Database Base_and_Database

• 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

• https://dannenhoefer.de/faqstarbasic/Datenbanken.html

• https://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0

• DE/FAQ/Base

• End user documentation

https://www.ooowiki.de/KategorieBase

• 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

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.