Apache OpenOffice Wiki - User contributions [en]

Database/Drivers/MySQL Native/1.0

2013-03-15T14:02:08Z

MSPhobe: /* Contact */

{{DISPLAYTITLE:MySQL Connector for OpenOffice.org 1.0}}

== Introduction ==

MySQL Connector for OpenOffice.org is a [http://www.mysql.org MySQL] driver for [http://www.openoffice.org/ OpenOffice.org]. It can be used to connect from [http://download.openoffice.org OpenOffice.org 3.1] to a MySQL server 5.1 or newer.

Before MySQL Connector for OpenOffice.org became available you'd have to use [http://dev.mysql.com/downloads/connector/j/ MySQL Connector/J (JDBC)] or [http://dev.mysql.com/downloads/connector/odbc/ MySQL Connector for ODBC] to connect to a MySQL server.

Therefore the driver is also referred to as a native driver in the context of OpenOffice.org. The term native driver clashes with the MySQL definition of a native driver: MySQL Connector for OpenOffice.org does not implement the MySQL Client Server protocol. Technically speaking the MySQL Connector for OpenOffice.org is implemented as a proxy on top of the [http://dev.mysql.com/doc/refman/5.1/en/connector-cpp.html MySQL Connector/C++].

The driver is delivered as an OpenOffice.org extension.

=== Advantages ===

Using MySQL Connector for OpenOffice.org has the following advantages:

*Easy installation through the OpenOffice.org Extension Manager.
*Seamless integration into OpenOffice.org.
*Work on multiple MySQL schemata (databases) simultaneously
*Connect to MySQL servers using named pipes (Windows) or Sockets (Unix)
*No need to go through an additional Connector installation routine (ODBC/JDBC)
*No need to configure or register an additional Connector (ODBC)
*No need to install or configure a driver manager (ODBC)
*No need for a Java Runtime Environment (JDBC)

=== Status ===

The MySQL Connector for OpenOffice.org is released in version 1.0.1, in production quality.

== Installation ==

=== Install or upgrade to OpenOffice.org 3.1 ===

OpenOffice.org 3.1 is available from OpenOffice.org's [http://download.openoffice.org download site]. The driver does not work together with earlier versions of OpenOffice.org. It will also run in OpenOffice.org when it becomes available, but not in current developer snapshots (up to, anticipated, DEV300.m57).

Please use "vanilla" OpenOffice.org: As with all extensions containing binary code, they're potentially incompatible with other OpenOffice.org distributions (like the one from your favorite Linux distribution), and are not necessarily expected to work with them. If you're using an OpenOffice.org build obtained elsewhere, e.g. by your favorite Linux distributor, then please ask this source to also provide the MySQL Connector for OpenOffice.org.

=== Download MySQL Connector for OpenOffice.org ===

The extension is available from the [http://extensions.services.openoffice.org/project/mysql_connector OpenOffice.org extensions repository]. It is provided for the usual 6 platforms (Windows, Linux Intel 32 Bit, Linux Intel 64 Bit, Solaris Sparc, Solaris Intel 32 Bit, Mac OS X Intel).

Download the file to a location of your choice, for example <code>My Documents</code> or <code>~/Documents</code>.

=== Users of the Beta version please note ===

If you have installed the previous Beta version please uninstall it first manually in the Extension Manager. The final version has a new product name and therefore it is not possible to update it via the extension mechanism. Also delete the cached database connection that was previously created as it cannot be re-used again (e.g., Windows: <code>"C:\Documents and Settings\<user>\Application Data\OpenOffice.org\3\user\uno_packages\cache\registry\*"</code> or Unix: <code>"/home/<user>/.openoffice.org/3/user/uno_packages/cache/registry/*"</code>).

=== Installing the extension ===

Add the <code>.oxt</code> extension through the Extension Manager of OpenOffice.org. In OpenOffice.org, select <code>Tools, Extension Manager...</code> and specify the <code>.oxt</code> file as a new extension. When done, MySQL Connector for OpenOffice.org should show up as a new extension under <code>My Extensions</code>.

[[Image:Conn ooo 1.0 GA extensions.png]]

Restart OpenOffice.org to complete the installation.

== Getting Started: Connecting to MySQL ==

MySQL Connector for OpenOffice.org allows you to access the MySQL Server and its schemata from the OpenOffice.org suite.

The following example demonstrates the creation of a new OpenOffice.org Base database which uses a local MySQL Server for storage and the new connector for connecting.

=== Select the database ===

Create a new database (<code>File, New, Database</code>). This starts a wizard that allows you to create a new, open an existing, or connect to existing database. Select the latter option.

From the drop-down list, select <code>MySQL</code>. Click <code>Next >></code>.

[[Image:Conn ooo alpha wizard1.png]]

=== Select the type of the driver ===

You can use three different MySQL drivers for connecting to MySQL from OpenOffice.org. You can choose a generic ODBC or JDBC connection method or the native driver. Select <code>Connect native</code>. Click <code>Next >></code>.

[[Image:Conn ooo alpha wizard2.png]]

=== Setting up the database connection ===

Set up the database connection. Put the schema (database) you want to connect to into <code>Name of the database</code>. Enter the URL (host name, or simply type <code>localhost</code> when connecting to the server on your own PC), Port and Socket (or leave socket empty) of your MySQL Server. Click <code>Next >></code>.

[[Image:Conn ooo alpha wizard3.png]]

=== Fill in user credentials ===

Provide the user credentials for connecting to your MySQL Server. Click <code>Next >></code>.

[[Image:Conn ooo alpha wizard4.png]]

=== Save and proceed ===

Finish the wizard. All defaults are a safe choice. Click <code>Finish >></code>.

[[Image:Conn ooo alpha wizard5.png]]

== Getting Started: Usage Examples ==

=== Listing Tables ===

In the Database area of the Base main window, select Tables. If this is the first time you're accessing the database you'll be prompted for your credentials (username and password); you can store these settings for your current Base session.

[[Image:Conn ooo alpha base.png]]

Depending on your connection settings you will now see all databases with all their tables, or just the database you've specified in the connection settings.

== Known Issues ==

There is currently [[Database/Drivers/MySQL Native/1.0/Known Issues|1 known issue]] in MySQL Connector for OpenOffice.org. We decided to nonetheless release version 1.0, since we think that it's better for all users, which do not encounter this particular problem, to benefit from this great extension.

== Contact ==

If you discover a bug, or just want to give any kind of feedback on the connector, please send an email to [mailto:users@dba.openoffice.org users@dba.openoffice.org]. It's a low-volume list with less than 10 mails per day. If you prefer reading it by means other than subscribing to it, see [[Base Mailing List|here]].

[[Category:Database_Drivers]] [[fr:FR/Documentation/Base/MySQL Connector|fr:FR/Documentation/Base/MySQL Connector]]

== Other resources ==

[http://sheepdogguides.com/srv/s0MySqlDoInst.htm Guide to setting up, getting started with, Open Office as client on MySQL server]

Connect MySQL and Base

2013-03-15T14:00:14Z

MSPhobe: Information added about more direct way to go to a MySQL server... the OO "native" MySQL connector.

This is a tutorial on connecting to a MySQL database server with OpenOffice.org Base using the JDBC connector.

Since this tutorial was written, [http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0 a "native" connector for Open Office has been created]. (Connector has exisited since at least Jan-11) Some would say that a "direct", "native" connection was more likely to run well that one that introduces "extra" elements to the situation. There is a [http://sheepdogguides.com/srv/s0MySqlDoInst.htm "getting started" tutorial for the native connector].

OpenOffice.org comes directly with support of JDBC connectivity to multiple databases. OpenOffice.org needs [http://www.java.com/en/download/index.jsp Java Runtime Environment] to be able to use JDBC. Verify that you have JRE on your OOo by going to '''Tools - Options - OpenOffice.org General - Java'''.

== Using JDBC on Windows ==
=== Installation ===
First, download and unzip the java archive. Obtain the [http://www.mysql.com/products/connector/j/ mysql-connector-J] from the [http://www.mysql.com MySQL website]. Follow the instructions on the [http://www.mysql.com MySQL website]to find and then download a gzipped and zipped set of files to a convenient location on the local computer. The target file will be named something like "mysql-connector-java-x.x.x.zip." Following the appropriate method for your zip program, unzip the downloaded file to a permanent location, for example, c:\Program Files\mySQL-Connector\. (NOTE: In Windows systems, double-clicking a zipped file usually gives access to the contents of the zip file, whereupon you may select from the resulting explorer window "Extract Files.")

Next, make OOo aware of the newly downloaded java archive. Start OpenOffice.org and on the menu select '''Tools - Options - OpenOffice.org - Java'''. Click on the button '''Class Path...'''; then click on the button '''Add Archive...'''; and navigate to where the mysql-connector-x.x.x-java-bin.jar file is located (see previous step). Click on the mysql-connector-x.x.x-java-bin.jar file once to highlight and click on the button '''Open'''. The mysql-connector-x.x.x-java-bin.jar file should then appear in the list of '''Assigned folders and Archives'''. Click on '''OK''' to close the dialog. OpenOffice.org will notify you that you need restart the program for the changes to take effect.

Finally, restart OOo and check functionality. Close OpenOffice.org '''completely''', that is, close all open OOo windows and shut down the quickstarter program located in the system tray (if it is running). Restart OpenOffice.org, and the JDBC connector should then be available and functioning.

=== Operation ===
See Operation below under Linux.

== Using ODBC on Windows ==

Obtain [http://dev.mysql.com/downloads/connector/odbc/ mysql-connector-odbc] from the [http://www.mysql.com MySQL website] and install it on your system. Then:

1) Navigate to Control Panel > Administrative Tools and double-click on Data Sources (ODBC)

2) on the User DSN tab Click Add button and from the list of available drivers, select the MySQL ODBC Driver, and click OK.

3) Input requires data in the appeared dialog:

Data Source Name: it's optional. Let it be "Mysql-test" in our case.

Description: is optional as well.

Server: '''localhost''' (in case mysql server is installed on the local machine, or IP Address if it's on network machine)

fill out user and password fields respectively. You should be able to see mysql databases under Database drop-down list, choose one. Click OK.

Then, Establishing connection by Creating New Base file:

1) File > New > Database

2) Click on the radio button Connect to an existing database and choose MySQL from the dropdown menu. Click on Next.

3) In the next dialog, you should accept the default choice of Connect using ODBC, and then click on Next.

4) Click Browse and select created connection ([MySQL-test] should be in the list in our case) and next.

5) then enter username and Finish. Save file.

== Using JDBC on Linux ==
=== Installation ===
Download the [http://www.mysql.com/products/connector/j/ mysql-connector-J] which you can download from the [http://www.mysql.com MySQL website]. [http://www.mysql.com/products/connector/j/ MySQL Connector/J] adds JDBC connectivity to MySQL. Unpack, untar or unzip the downloaded file anywhere where you can access it as a normal user, for example, to your desktop. On KDE, you can use Ark, on Gnome FileRoller, or even the Nautilus scripts that are included in some Linux distributions, or the usual "tar -zvf" from a console. A directory is created at the desired location named mysql-connector-java-x.x.x, where the x.x.x represents the version number of the JDBC connector you have downloaded. Inside this directory, you will find a file called mysql-connector-x.x.x-java-bin.jar.

Start OpenOffice.org and go to the menu '''Tools - Options - OpenOffice.org General Java'''. Click on the button '''Class Path...''', then choose '''Add Archive...''' and navigate to where the mysql-connector-x.x.x-java-bin.jar file is located. Click on '''Open''', and the file should then appear in the list of '''Assigned folders and Archives'''. You can then click on '''OK''' and close OpenOffice.org completely. You may receive a message indicating that you have to do that anyway in order for OpenOffice.org to be able recognize your changes correctly. If the OpenOffice.org quickstarter is running, you should close that application as well.

Instead of downloading the connector from the MySQL download site, you can also use the corresponding packages of your distribution like
* libmysql-java for debian and ubuntu

Note that the use of the MySQL Java Connector requires MySQL to be installed and running on your Linux system. On Redhat/Enterprise Linux, MySQL can be installed and made to run via the following commands in a terminal;

::su root
::yum install mysql-server mysql
::cd /sbin
::./chkconfig mysqld on
::/etc/init.d/mysqld start

=== Operation ===

When you restart OpenOffice.org after installing the MySQL Java connect driver, you should now be able to create a new OpenOffice.org Base database document that can connect to your existing mysql database. Note that you will need to have first created your database on your mysql server.

:: One method to do this requires using the mysql command line client;
:::mysqladmin -u root password NEWPASSWORD
:::mysql -u root -p
:::CREATE DATABASE newdatabasename;
:::CREATE USER 'newusername'@'localhost' IDENTIFIED BY 'password';
:::GRANT ALL ON *.* TO 'newusername'@'localhost';

:: Another method to do this requires the use of a graphical user interface to administer your mysql server (for example PHPMyAdmin).

Now do the following :

1) '''File > New > Database'''

2) Click on the radio button '''Connect to an existing database''' and choose '''MySQL''' from the dropdown menu. Click on '''Next'''.

3) In the next dialog, you should accept the default choice of '''Connect using JDBC''', and then click on '''Next'''.

4) The next step varies depending upon the exact version of openoffice.org installed.

::If the fields '''Name of the database''' and '''Server URL''' are present, perform the following;

:::In the '''Name of the database''' field, enter the name of your mysql database as it is called on the mysql server, paying attention to the spelling.
:::In the '''Server URL''' field, enter either the fully qualified internet domain name of the server on which your mysql server is running, or its IP address or, if you are running the mysql server locally on your own computer, simply type localhost. You can adjust the connection port or leave default port 3306 in the field '''Port number'''. An example Server URL would be: localhost, 192.168.1.1, or 96.115.86.166, or something like that.

::If only the field '''Data Source URL''' is present perform the following;

:::In the '''Data Source URL''' field, enter a combination of the servername, port (optional), and data base name, in the following format; jdbc:mysql://serverAddress:3306/databaseName (or jdbc:mysql://serverAddress/databaseName without the port number). An example Server Address would be: '''localhost''' (if mysql server is installed on local computer), 192.168.1.1, or 96.115.86.166, or something like that if mysql server is installed on network computer.

::For the field '''MySQL JDBC driver class:''' enter the class name for the JDBC driver you installed. You can find the correct class name in the documentation that came with the driver. MySQL java connector archive version 5.1.6 contains connector-j.pdf document with description in subdirectory docs. The class name is '''com.mysql.jdbc.Driver''' for version 5.1.6. Click on '''Test Class''' just to make sure that you have correctly set up the access to the connector as detailed above. If the connector has been set up correctly, you will get a message that says '''The JDBC driver was loaded correctly'''. Now click on '''Next'''.

5) Now enter the name of the user and the password (if required by the mysql server) that you have previously created for use of the database on the mysql server. If you click on '''Test Connection''', you will be asked for a password if you have ticked the password box beforehand. If the connection to the database succeeds, you will get a message '''Connection test: The connection was established successfully'''. Click on '''Next'''. If you get an error indicating a character conversion error, edit both the [client] and [mysqld] sections of my.cnf to include default-character-set=utf8 in both sections. Restart the mysql server.

6) On the final screen of the database wizard dialog, you can in general leave the default settings as they are, i.e. '''Yes, register the database for me''' and '''Open the database for editing'''. Click on '''Finish'''.

7) You will be asked for a file name to give to your database document. Once you have done this and clicked on '''Save''', the database document will open, and the Forms button on the left will be highlighted. Congratulations, you have now connected to your MySQL database via the JDBC connector.

== Using ODBC on Linux ==
OpenOffice.org also support ODBC connectivity to MySQL, you will need [http://www.unixodbc.org/ Unix-ODBC] in order to make a connection through it.

=== Debian/Ubuntu ===

Install package libmyodbc from synaptic package manager (assuming package unixodbc is already installed) or obtain [http://dev.mysql.com/downloads/connector/odbc/ mysql-connector-odbc] from the [http://www.mysql.com MySQL website].

You need to have 2 files configured:

1) /etc/odbcinst.ini should contain:

[MySQL]

Description = MySQL driver

Driver = /usr/lib/odbc/libmyodbc.so

Setup = /usr/lib/odbc/libodbcmyS.so

2) and/etc/odbc.ini should have (or create ~/.odbc.ini so that you can modify it as normal user):

[MySQL-test]

Description = MySQL database test

Driver = MySQL

Server = localhost

Database = test

Port = 3306

Socket =

Option = 3

ReadOnly = No

In above configuration we assumed that database named "test" exists on local server. Then, Establishing connection by Creating New Base file:

1) File > New > Database

2) Click on the radio button Connect to an existing database and choose MySQL from the dropdown menu. Click on Next.

3) In the next dialog, you should accept the default choice of Connect using ODBC, and then click on Next.

4) Click '''Browse''' and select created connection ([MySQL-test] should be in the list in our case) and next.

5) then enter username and Finish. Save file.

For other Linux distros procedure should be pretty much the same in my opinion. You should just know the installation locations for files: libmyodbc.so and libodbcmyS.so, and replace them in the example above.

== Using JDBC on OS X ==
=== Installation ===

1) Download MySQL Connector/J from [http://www.mysql.com/downloads/ MySQL Downloads]

Choose '''Platform independent'''
Choose '''Zip File''' or '''Tar File''' (either will do)

2) Double click file to extract

3) Make a directory under your user name (I use a combination of connectorj and the version number.)

4) Copy the contents of the zip file into this new directory.

=== OpenOffice.org settings ===

Set up OpenOffice.org for use via JDBC (Warning! This will require a restart of OpenOffice.org!):

OpenOffice.org > Perferences > Java

Click "CLASSPATH"

Click "Add Archive"

Browse to the jar file from the zip/tar file (mysql-connector-java-x.x.x-bin.jar where x.x.x is the version number).

Click OK. OpenOffice.org will warn a restart of the application is required.

=== Setting up a database for use ===

''These instructions assume the use of an existing database.''

Start OpenOffice.org and choose a file type of "Database."

Click the radio button "Connect to an existing database" with the drop down set to JDBC.

Click Next.

In the URL following jdbc: fill in with the proper settings in the format mysql://servername:port/databasename (if default port, you can ignore the port portion.)

Fill in the Driver Class with '''com.mysql.jdbc.Driver''' and click "Test Class." You should see a message "The JDBC driver was loaded successfully."

Click Next.

Enter the user name to connect to the DB with. If a password is required, check the "Password required" box.

Click "Test Connection" and it should prompt with the user name and a password prompt. You should see a pop-up saying "The connection was established successfully."

Click Next.

Best to leave the defaults on this next screen set.

Click Finish.

You will be prompted on where to put the database configurations for use with OpenOffice.org. (I usually make a small directory in my Documents folder.)

== Recommendations settings ==

Known issues regarding MySQL and OpenOffice.org can be avoided by having specific settings here are some of those:

=== MySQL settings ===

* Make sure that MySQL is using TCP/IP as opposed to sockets. Edit the my.cnf file at /etc/ and comment '''skip-networking'''. NOTE: In Ubuntu my.cnf is located in /etc/mysql

=== OpenOffice.org settings ===

* OpenOffice.org uses Java for JDBC, please make sure you have JRE at Tools - Options - OpenOffice.org General - Java
* Declare the '''mysql-connector-j.bin''' at the classpath at Tools - Options - OpenOFfice.org General - Java
* MySQL and JDBC on Debian Testing: Package sun-java6-jre from the non-free repository is needed and has to be activated in "Options-> OpenOffice.org -> Java". The FSF java environment will not work returning a SQL syntax code whenever connecting to the MySQL server (July 27th 2008).

[[Category:Database]]

Connect MySQL and Base

2013-03-15T13:56:32Z

MSPhobe: (checkpoint save)

Here is a tutorial on connecting to a MySQL database server with OpenOffice.org Base using the JDBC connector.

Since this tutorial was written, [http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0 a "native" connector for Open Office has been created]. (Connector has exisited since at least Jan-11)

OpenOffice.org comes directly with support of JDBC connectivity to multiple databases. OpenOffice.org needs [http://www.java.com/en/download/index.jsp Java Runtime Environment] to be able to use JDBC. Verify that you have JRE on your OOo by going to '''Tools - Options - OpenOffice.org General - Java'''.

== Using JDBC on Windows ==
=== Installation ===
First, download and unzip the java archive. Obtain the [http://www.mysql.com/products/connector/j/ mysql-connector-J] from the [http://www.mysql.com MySQL website]. Follow the instructions on the [http://www.mysql.com MySQL website]to find and then download a gzipped and zipped set of files to a convenient location on the local computer. The target file will be named something like "mysql-connector-java-x.x.x.zip." Following the appropriate method for your zip program, unzip the downloaded file to a permanent location, for example, c:\Program Files\mySQL-Connector\. (NOTE: In Windows systems, double-clicking a zipped file usually gives access to the contents of the zip file, whereupon you may select from the resulting explorer window "Extract Files.")

Next, make OOo aware of the newly downloaded java archive. Start OpenOffice.org and on the menu select '''Tools - Options - OpenOffice.org - Java'''. Click on the button '''Class Path...'''; then click on the button '''Add Archive...'''; and navigate to where the mysql-connector-x.x.x-java-bin.jar file is located (see previous step). Click on the mysql-connector-x.x.x-java-bin.jar file once to highlight and click on the button '''Open'''. The mysql-connector-x.x.x-java-bin.jar file should then appear in the list of '''Assigned folders and Archives'''. Click on '''OK''' to close the dialog. OpenOffice.org will notify you that you need restart the program for the changes to take effect.

Finally, restart OOo and check functionality. Close OpenOffice.org '''completely''', that is, close all open OOo windows and shut down the quickstarter program located in the system tray (if it is running). Restart OpenOffice.org, and the JDBC connector should then be available and functioning.

=== Operation ===
See Operation below under Linux.

== Using ODBC on Windows ==

Obtain [http://dev.mysql.com/downloads/connector/odbc/ mysql-connector-odbc] from the [http://www.mysql.com MySQL website] and install it on your system. Then:

1) Navigate to Control Panel > Administrative Tools and double-click on Data Sources (ODBC)

2) on the User DSN tab Click Add button and from the list of available drivers, select the MySQL ODBC Driver, and click OK.

3) Input requires data in the appeared dialog:

Data Source Name: it's optional. Let it be "Mysql-test" in our case.

Description: is optional as well.

Server: '''localhost''' (in case mysql server is installed on the local machine, or IP Address if it's on network machine)

fill out user and password fields respectively. You should be able to see mysql databases under Database drop-down list, choose one. Click OK.

Then, Establishing connection by Creating New Base file:

1) File > New > Database

2) Click on the radio button Connect to an existing database and choose MySQL from the dropdown menu. Click on Next.

3) In the next dialog, you should accept the default choice of Connect using ODBC, and then click on Next.

4) Click Browse and select created connection ([MySQL-test] should be in the list in our case) and next.

5) then enter username and Finish. Save file.

== Using JDBC on Linux ==
=== Installation ===
Download the [http://www.mysql.com/products/connector/j/ mysql-connector-J] which you can download from the [http://www.mysql.com MySQL website]. [http://www.mysql.com/products/connector/j/ MySQL Connector/J] adds JDBC connectivity to MySQL. Unpack, untar or unzip the downloaded file anywhere where you can access it as a normal user, for example, to your desktop. On KDE, you can use Ark, on Gnome FileRoller, or even the Nautilus scripts that are included in some Linux distributions, or the usual "tar -zvf" from a console. A directory is created at the desired location named mysql-connector-java-x.x.x, where the x.x.x represents the version number of the JDBC connector you have downloaded. Inside this directory, you will find a file called mysql-connector-x.x.x-java-bin.jar.

Start OpenOffice.org and go to the menu '''Tools - Options - OpenOffice.org General Java'''. Click on the button '''Class Path...''', then choose '''Add Archive...''' and navigate to where the mysql-connector-x.x.x-java-bin.jar file is located. Click on '''Open''', and the file should then appear in the list of '''Assigned folders and Archives'''. You can then click on '''OK''' and close OpenOffice.org completely. You may receive a message indicating that you have to do that anyway in order for OpenOffice.org to be able recognize your changes correctly. If the OpenOffice.org quickstarter is running, you should close that application as well.

Instead of downloading the connector from the MySQL download site, you can also use the corresponding packages of your distribution like
* libmysql-java for debian and ubuntu

Note that the use of the MySQL Java Connector requires MySQL to be installed and running on your Linux system. On Redhat/Enterprise Linux, MySQL can be installed and made to run via the following commands in a terminal;

::su root
::yum install mysql-server mysql
::cd /sbin
::./chkconfig mysqld on
::/etc/init.d/mysqld start

=== Operation ===

When you restart OpenOffice.org after installing the MySQL Java connect driver, you should now be able to create a new OpenOffice.org Base database document that can connect to your existing mysql database. Note that you will need to have first created your database on your mysql server.

:: One method to do this requires using the mysql command line client;
:::mysqladmin -u root password NEWPASSWORD
:::mysql -u root -p
:::CREATE DATABASE newdatabasename;
:::CREATE USER 'newusername'@'localhost' IDENTIFIED BY 'password';
:::GRANT ALL ON *.* TO 'newusername'@'localhost';

:: Another method to do this requires the use of a graphical user interface to administer your mysql server (for example PHPMyAdmin).

Now do the following :

1) '''File > New > Database'''

2) Click on the radio button '''Connect to an existing database''' and choose '''MySQL''' from the dropdown menu. Click on '''Next'''.

3) In the next dialog, you should accept the default choice of '''Connect using JDBC''', and then click on '''Next'''.

4) The next step varies depending upon the exact version of openoffice.org installed.

::If the fields '''Name of the database''' and '''Server URL''' are present, perform the following;

:::In the '''Name of the database''' field, enter the name of your mysql database as it is called on the mysql server, paying attention to the spelling.
:::In the '''Server URL''' field, enter either the fully qualified internet domain name of the server on which your mysql server is running, or its IP address or, if you are running the mysql server locally on your own computer, simply type localhost. You can adjust the connection port or leave default port 3306 in the field '''Port number'''. An example Server URL would be: localhost, 192.168.1.1, or 96.115.86.166, or something like that.

::If only the field '''Data Source URL''' is present perform the following;

:::In the '''Data Source URL''' field, enter a combination of the servername, port (optional), and data base name, in the following format; jdbc:mysql://serverAddress:3306/databaseName (or jdbc:mysql://serverAddress/databaseName without the port number). An example Server Address would be: '''localhost''' (if mysql server is installed on local computer), 192.168.1.1, or 96.115.86.166, or something like that if mysql server is installed on network computer.

::For the field '''MySQL JDBC driver class:''' enter the class name for the JDBC driver you installed. You can find the correct class name in the documentation that came with the driver. MySQL java connector archive version 5.1.6 contains connector-j.pdf document with description in subdirectory docs. The class name is '''com.mysql.jdbc.Driver''' for version 5.1.6. Click on '''Test Class''' just to make sure that you have correctly set up the access to the connector as detailed above. If the connector has been set up correctly, you will get a message that says '''The JDBC driver was loaded correctly'''. Now click on '''Next'''.

5) Now enter the name of the user and the password (if required by the mysql server) that you have previously created for use of the database on the mysql server. If you click on '''Test Connection''', you will be asked for a password if you have ticked the password box beforehand. If the connection to the database succeeds, you will get a message '''Connection test: The connection was established successfully'''. Click on '''Next'''. If you get an error indicating a character conversion error, edit both the [client] and [mysqld] sections of my.cnf to include default-character-set=utf8 in both sections. Restart the mysql server.

6) On the final screen of the database wizard dialog, you can in general leave the default settings as they are, i.e. '''Yes, register the database for me''' and '''Open the database for editing'''. Click on '''Finish'''.

7) You will be asked for a file name to give to your database document. Once you have done this and clicked on '''Save''', the database document will open, and the Forms button on the left will be highlighted. Congratulations, you have now connected to your MySQL database via the JDBC connector.

== Using ODBC on Linux ==
OpenOffice.org also support ODBC connectivity to MySQL, you will need [http://www.unixodbc.org/ Unix-ODBC] in order to make a connection through it.

=== Debian/Ubuntu ===

Install package libmyodbc from synaptic package manager (assuming package unixodbc is already installed) or obtain [http://dev.mysql.com/downloads/connector/odbc/ mysql-connector-odbc] from the [http://www.mysql.com MySQL website].

You need to have 2 files configured:

1) /etc/odbcinst.ini should contain:

[MySQL]

Description = MySQL driver

Driver = /usr/lib/odbc/libmyodbc.so

Setup = /usr/lib/odbc/libodbcmyS.so

2) and/etc/odbc.ini should have (or create ~/.odbc.ini so that you can modify it as normal user):

[MySQL-test]

Description = MySQL database test

Driver = MySQL

Server = localhost

Database = test

Port = 3306

Socket =

Option = 3

ReadOnly = No

In above configuration we assumed that database named "test" exists on local server. Then, Establishing connection by Creating New Base file:

1) File > New > Database

2) Click on the radio button Connect to an existing database and choose MySQL from the dropdown menu. Click on Next.

3) In the next dialog, you should accept the default choice of Connect using ODBC, and then click on Next.

4) Click '''Browse''' and select created connection ([MySQL-test] should be in the list in our case) and next.

5) then enter username and Finish. Save file.

For other Linux distros procedure should be pretty much the same in my opinion. You should just know the installation locations for files: libmyodbc.so and libodbcmyS.so, and replace them in the example above.

== Using JDBC on OS X ==
=== Installation ===

1) Download MySQL Connector/J from [http://www.mysql.com/downloads/ MySQL Downloads]

Choose '''Platform independent'''
Choose '''Zip File''' or '''Tar File''' (either will do)

2) Double click file to extract

3) Make a directory under your user name (I use a combination of connectorj and the version number.)

4) Copy the contents of the zip file into this new directory.

=== OpenOffice.org settings ===

Set up OpenOffice.org for use via JDBC (Warning! This will require a restart of OpenOffice.org!):

OpenOffice.org > Perferences > Java

Click "CLASSPATH"

Click "Add Archive"

Browse to the jar file from the zip/tar file (mysql-connector-java-x.x.x-bin.jar where x.x.x is the version number).

Click OK. OpenOffice.org will warn a restart of the application is required.

=== Setting up a database for use ===

''These instructions assume the use of an existing database.''

Start OpenOffice.org and choose a file type of "Database."

Click the radio button "Connect to an existing database" with the drop down set to JDBC.

Click Next.

In the URL following jdbc: fill in with the proper settings in the format mysql://servername:port/databasename (if default port, you can ignore the port portion.)

Fill in the Driver Class with '''com.mysql.jdbc.Driver''' and click "Test Class." You should see a message "The JDBC driver was loaded successfully."

Click Next.

Enter the user name to connect to the DB with. If a password is required, check the "Password required" box.

Click "Test Connection" and it should prompt with the user name and a password prompt. You should see a pop-up saying "The connection was established successfully."

Click Next.

Best to leave the defaults on this next screen set.

Click Finish.

You will be prompted on where to put the database configurations for use with OpenOffice.org. (I usually make a small directory in my Documents folder.)

== Recommendations settings ==

Known issues regarding MySQL and OpenOffice.org can be avoided by having specific settings here are some of those:

=== MySQL settings ===

* Make sure that MySQL is using TCP/IP as opposed to sockets. Edit the my.cnf file at /etc/ and comment '''skip-networking'''. NOTE: In Ubuntu my.cnf is located in /etc/mysql

=== OpenOffice.org settings ===

* OpenOffice.org uses Java for JDBC, please make sure you have JRE at Tools - Options - OpenOffice.org General - Java
* Declare the '''mysql-connector-j.bin''' at the classpath at Tools - Options - OpenOFfice.org General - Java
* MySQL and JDBC on Debian Testing: Package sun-java6-jre from the non-free repository is needed and has to be activated in "Options-> OpenOffice.org -> Java". The FSF java environment will not work returning a SQL syntax code whenever connecting to the MySQL server (July 27th 2008).

[[Category:Database]]

Documentation/OOoAuthors User Manual/Getting Started/Finding more information

2009-05-24T10:08:41Z

MSPhobe: New resource listed

{{DISPLAYTITLE:Finding more information}}
{{Documentation/GSMacroTOC
|ShowPrevNext=block
|PrevPage=Documentation/OOoAuthors User Manual/Getting Started/Writing macros without the recorder
|NextPage=Documentation/OOoAuthors User Manual/Getting Started/Keyboard Shortcuts
}}__NOTOC__
Numerous resources are available that provide help with writing macros. Use '''Help > OpenOffice.org Help''' to open the OOo help pages. The upper left corner of the OOo help system contains a drop-down list that determines which help set is displayed. To view the help for Basic, the drop-down must display ''Help about OpenOffice.org Basic''.

==Included material==

Many excellent macros are included with OOo. Use '''Tools > Macros > Organize Macros > OpenOffice.org Basic''' to open the Macro dialog. Expand the Tools library in the OpenOffice.org library container. Inspect the Debug module—some good examples include <tt>WritedbgInfo(document)</tt> and <tt>printdbgInfo(sheet)</tt>.

==Online resources==

The following links and references contain information regarding macro programming:

* [http://www.openoffice.org/ http://www.openoffice.org] (the main link)
* [http://codesnippets.services.openoffice.org/ http://codesnippets.services.openoffice.org/] (categorized examples)
* [http://www.oooforum.org/ http://www.oooforum.org] (if you need help with your macros this is a good place to ask, probably one of the best supported OOo forums on the web)
* [http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html] (official IDL reference, here you'll find almost every command with a description)
* [http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html] (official documentation that contains a detailed explanation)
* [http://www.pitonyak.org/oo.php http://www.pitonyak.org/oo.php] (Andrew Pitonyak's macro page)
* [http://www.pitonyak.org/AndrewMacro.odt http://www.pitonyak.org/AndrewMacro.odt] (numerous examples of working macros)
* [http://www.pitonyak.org/book/ http://www.pitonyak.org/book/] (Andrew Pitonyak wrote a book on macros)
* [http://www.pitonyak.org/database/ http://www.pitonyak.org/database/] (numerous macro examples using Base)
* [http://docs.sun.com/app/docs http://docs.sun.com/app/docs] (Sun wrote a book on macro programming—very well written and laid out)
* [http://documentation.openoffice.org/ http://documentation.openoffice.org] (contains content related to macros)
* [http://ooextras.sourceforge.net/ http://ooextras.sourceforge.net/] (examples)
* [http://sourceforge.net/project/showfiles.php?group_id=43716 http://sourceforge.net/project/showfiles.php?group_id=43716] (examples)
* [http://homepages.paradise.net.nz/hillview/OOo/ http://homepages.paradise.net.nz/hillview/OOo/] (numerous excellent macros, including reveal codes macros, key macros, and information on converting from MS Office)
* [http://sheepdogguides.com/fdb/fdb1main.htm#gotoMacros Introduction to OO macro writing] Leads to macros for ooBase. From Sheepdogguides.com.

==Published material==

The following published sources contain macro examples. The most obvious example is the documentation from Sun. Start from Sun's documentation site [http://docs.sun.com/app/docs http://docs.sun.com/app/docs] and search for StarOffice documentation.

Andrew Pitonyak wrote a book called ''OpenOffice.org Macros Explained''. Two chapters are available as direct downloads from the publisher. See [http://www.pitonyak.org/book/ http://www.pitonyak.org/book/.]

Dr. Mark Alexander Bain wrote ''Learn OpenOffice.org Spreadsheet Macro Programming'' (see [http://www.packtpub.com/openoffice-ooobasic-calc-automation/book http://www.packtpub.com/openoffice-ooobasic-calc-automation/book]).

{{CCBY}}
[[Category:Getting Started (Documentation)]]

Database

2009-05-24T10:02:39Z

MSPhobe: Link to a new example inserted

{{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.

* 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 Zoltan
: 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 ===
* 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]

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

== 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 correponding links.

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

Database

2009-05-24T09:54:37Z

MSPhobe: Tidied an entry

{{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.

* 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 Zoltan
: 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 ===
* 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]

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

== 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 correponding links.

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

Database

2009-05-24T09:51:39Z

MSPhobe: Fixed awkward phrase... I hope. Maybe original was meant to say "Add requests for things"... if so, and you think it should be here, you put it in!

{{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.

* 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"
: [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials and "How to"s... 45 from one author at Sheepdogguides.com]
: Initial author: TK Boyd
: Specific tasks and also fundamental skills are discussed.
: 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 Zoltan
: 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 ===
* 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]

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

== 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 correponding links.

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

Database

2009-05-24T09:49:19Z

MSPhobe: /* General */

{{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 documents, you are missing, 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.

* 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"
: [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials and "How to"s... 45 from one author at Sheepdogguides.com]
: Initial author: TK Boyd
: Specific tasks and also fundamental skills are discussed.
: 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 Zoltan
: 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 ===
* 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]

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

== 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 correponding links.

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

Database

2009-05-24T09:43:45Z

MSPhobe: Brough description of a source of help up to date

{{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 documents, you are missing, 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.

* 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"
: [http://sheepdogguides.com/fdb/fdb1main.htm Base Tutorial by Sheepdogguides.com]
: Initial author: TK Boyd
: Link takes you to table of contents for 45 tutorials by author.
: Some every day tasks like importing data from other tables.
: Others discuss underlying issues, teach fundamental skills
: A section on getting started with 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 Zoltan
: 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 ===
* 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]

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

== 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 correponding links.

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