Configuring and Using Databases

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 22:37, 15 January 2007 (edit)
Valterb (Talk | contribs)
(botlangbar -> IT)
← Previous diff
Revision as of 22:07, 14 February 2007 (edit) (undo)
Ovvldc (Talk | contribs)
(MS Access-related tips - added link to Mac version of migration toolkit)
Next diff →
Line 34: Line 34:
Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files.
-An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. a commercial one, but it works.+An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. It is a commercial one, but it works. The [http://www.mysql.com/products/tools/migration-toolkit/ MySQL Migration Toolkit] for the Mac can be found in the [http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle] and can be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with). Other options are discussed on the [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436 Trinity forum].
-hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]+
{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}} {{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}
[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]] [[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]

Revision as of 22:07, 14 February 2007

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki. You can help the NeoOffice community by fixing it. If you do not have a NeoWiki account, please follow the steps on the New User page to request one.

While NeoOffice 1.2.x, NeoOffice/J 1.1 and OpenOffice.org/X11 1.1.x do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports. NeoOffice 2.0 includes a new database component, “Base”, but you can still connect to various external databases and manipulate data from NeoOffice.

If you do not have a MySQL or hsqldb database, you can also create a simple database in NeoOffice or OpenOffice.org/X11—or even use a Calc table if your needs are very simple.

The various pages of this article contain information on installing, configuring, and using a these databases with NeoOffice or OpenOffice.org/X11.

Maybe insert a screenshot here to balance the length of the page vs. the length of the TOC--the TOC will get shorter when the articles are done, but storing comments there now until we decide on page names, etc.

Include a reference to the Address Book article somewhere, though it's not part of this article

dbf import tip

The table structure of the dbf file for all the fields containing leading apostrophes say they are characters. This can easily seen if you import the DBF file and look at the first row. All columns have a header defining it. C is for characters (text), N would be numeric.

So Calc imports the values correctly as Characters. As the number format for the default template is set to numeric, a apostrophe is placed in front of the value to make it a text.

To change such text values to real numeric values, you have two choices.

1.) Change the field setting in the DBF from C to N and re-import the file or 2.) use the Search and replace functionality. Open the search and replace dialog and enter '.*' (without the quotes) into the search field. Type '&' (also without quotes) into the replace field. Now press on the More Button and tag the option Regular expression. Click on replace all and all the apostrophes should be gone.

MS Access-related tips

Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files.

An ODBC driver that works with MS Access on a Mac is the Actual ODBC driver. It is a commercial one, but it works. The MySQL Migration Toolkit for the Mac can be found in the MySQL GUI Tools Bundle and can be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with). Other options are discussed on the Trinity forum.


This article in other languages: Français Italiano
Personal tools