NeoBase

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 01:27, 21 July 2007 (edit)
Lorinda (Talk | contribs)
(Connecting to and Importing From Other Databases - MySQL/ODBC)
← Previous diff
Current revision (04:55, 20 May 2014) (edit) (undo)
Sardisson (Talk | contribs)
(Connecting to and Importing from Other Databases - add link to stub page for NeoSE)
 
(35 intermediate revisions not shown.)
Line 1: Line 1:
-{{Fixme}}+{{Fixme}}<!--''This page is very much under construction''-->
-<!--''This page is very much under construction''-->+
- +
NeoOffice Base allows you to either connect to an external database (MySQL, dBase, Calc, etc.) or to create an "embedded database" using the included HSQL database engine. In addition to entering and editing data, you can create Queries, Views, and Forms, as well as access any registered datasource in Writer and Calc documents. NeoOffice Base allows you to either connect to an external database (MySQL, dBase, Calc, etc.) or to create an "embedded database" using the included HSQL database engine. In addition to entering and editing data, you can create Queries, Views, and Forms, as well as access any registered datasource in Writer and Calc documents.
==Tips and Hints in the Wiki== ==Tips and Hints in the Wiki==
''Note that some of the pages are "stubs" consisting mostly of links to discussions on trinity.''<br> ''Note that some of the pages are "stubs" consisting mostly of links to discussions on trinity.''<br>
-===Connecting to and Importing From Other Databases===+ 
-[[Configuring MySQL using JDBC and NeoOffice 2.0]]<br>+''Additional tips can be found on the [[New Articles Needed]] page, which contains links to stub pages and/or threads in trinity that need to be developed into full blown articles.''
-[[Configuring MySQL using ODBC]]<br>+ 
-[[Configuring postgresql]]<br>+===Connecting to and Importing from Other Databases===
-[[Configuring FileMaker Pro]]<br>+* [[Configuring MySQL using ODBC and NeoOffice Secure Edition]]
-[[dbf and Access Tips]]<br>+* [[Configuring MySQL using JDBC and NeoOffice 2.x]]
 +* [[Configuring MySQL using ODBC]]
 +* [[Configuring postgresql]]
 +* [[Configuring FileMaker Pro]]
 +* [[Working with dBase databases]]
 +* [[Working with Microsoft Access databases]]
 +* [[Opening_AppleWorks_documents#Database|Migrating an AppleWorks database to NeoBase]]
===Other Base Tips in the Wiki=== ===Other Base Tips in the Wiki===
-[[Using a Calc spreadsheet as a data source]]<br>+* [[Using a Calc spreadsheet as a data source]]
-[[Importing Data from Address Book]]<br>+* [[Importing Data from Address Book]]
 +* [[Using the Mail Merge Wizard]] (in Writer, but using Base datasources)
 +* [[To Base and Back Again]] A new series of Base tutorials in the wiki.
 +* [[Compacting your database]] Eliminating wasted space in your database and reducing its file size.
 +<br>
 + 
 +==External Tips==
 +*[http://www.oooforum.org/forum/viewtopic.phtml?p=252799#252799 Adding a Button to Search on a Form]
 +*[http://www.oooforum.org/forum/viewtopic.phtml?p=268350&sid=9e17b76732a7e32a7635757399279971#268350 importing a large csv file into a base table] For files too large to bring through via a Calc document, or where field type definitions do not set properly.
 +*[http://www.linux.com/feature/142229 OOo Basic crash course: Creating charts with Base and Calc]
==Documentation, Tutorials, etc.== ==Documentation, Tutorials, etc.==
===User Guides and Documentation=== ===User Guides and Documentation===
 +====User Guides and Other "General" Documentation====
* [http://documentation.openoffice.org/manuals/index.html OpenOffice User Guide Chap 7] * [http://documentation.openoffice.org/manuals/index.html OpenOffice User Guide Chap 7]
-* [http://hsqldb.org/doc/guide/guide.html HSQLDB User Guide] (HSQLBD is the underlying database engine in Base)+* [http://wiki.services.openoffice.org/wiki/Base OpenOffice.org wiki "main page" for the Base component.]
-* [http://www.postgresql.org/files/documentation/books/aw_pgsql/index.html Good guide on SQL]+* [http://openoffice.blogs.com/openoffice/2007/08/a-huge-pdf-prin.html PDF Article on Advanced Report Techniques], Including SQL-Based Calculated Fields on Reports. By Solveig Haugland
-:Suggested by the HSQLDB User Guide+* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer OOo Base Primer] A brief overview of Base, with detailed information on connecting to MySQL.
 + 
 +====Definitions====
 +*[http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Built-in Functions and Stored Procedures] that can be used in Queries.
 +* [http://hsqldb.sourceforge.net/doc/guide/ch09.html#datatypes-section List of Data Types]
 + 
 +====Using Macros in Base====
 +*[http://www.geocities.com/rbenitez22/OOo/OOBasicDatabaseDev.pdf OOBasic Database Dev.pdf] Covers Statement, ResultSet, & RowSet Services by Roberto Benitez.
 +* [http://www.geocities.com/rbenitez22/OOo/FormsAndDialogs.pdf PDF on Designing Forms], Mostly devoted to form related macros, but it also covers using the Form Wizard and Design View to create forms. By Roberto Benitez
 +* [http://www.pitonyak.org/database/ Andrew Pitonyak on using Macros with Base]
 + 
 +====HSQLDB and SQL Documentation====
 +* [http://hsqldb.org/doc/guide/guide.html HSQLDB User Guide] (HSQLDB is the underlying database engine in Base)
 +* [http://www.postgresql.org/files/documentation/books/aw_pgsql/index.html Good guide on SQL], Suggested by the HSQLDB User Guide
* [http://www.sqlcourse.com/ Introduction to SQL] * [http://www.sqlcourse.com/ Introduction to SQL]
Line 31: Line 58:
===Forums=== ===Forums===
* [http://www.oooforum.org/forum/viewforum.phtml?f=10 OOoForum.org discussion forum for Base] * [http://www.oooforum.org/forum/viewforum.phtml?f=10 OOoForum.org discussion forum for Base]
-::Probably the best place to ask questions about using Base.+::Probably the oldest forum OpenOffice.org users. It is well frequented.
 +* [http://user.services.openoffice.org/en/forum/viewforum.php?f=13 OpenOffice Community Forums]
 +::A newer OpenOffice.org forum. Many of the regulars also frequent ooforum.org, so double posting is not reccommended.
===Tutorials=== ===Tutorials===
* [[To Base and Back Again]] * [[To Base and Back Again]]
-:A new series of tutorials being written by one of Neowiki's editors. Follows the creation of a database for tracking birding trips and sightings.+:A new series of tutorials being written by one of NeoWiki's editors. Follows the creation of a database for tracking birding trips and sightings.
-* [http://sheepdogguides.com/fdb/fdb1main.htm Collection of smaller Base tutorials]+* [http://sheepdogguides.com/fdb/fdb1main.htm SheepDogGuides] a collection of smaller Base tutorials
-* [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Base tutorial] +*[http://documentation.openoffice.org/tutorials/daibutt/Base/Base.html Dai's Tutorials for Base] video tutorials
 +* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer OOo Base Primer]
 +* [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Base tutorial in the OOoforum]
:step-by-step construction of a small relational database for employees, with some advanced concepts like forms toward the end :step-by-step construction of a small relational database for employees, with some advanced concepts like forms toward the end
* [http://inpics.net/base2.html Visual tutorial for Base] from InPics * [http://inpics.net/base2.html Visual tutorial for Base] from InPics
* Two-part introduction to Base for database beginners: [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1148271,00.html Part 1], [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1151013,00.html Part2 ] * Two-part introduction to Base for database beginners: [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1148271,00.html Part 1], [http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1151013,00.html Part2 ]
-<br>+ 
 +* [http://www.freesoftwaremagazine.com/articles/the_simplest_way_to_make_databases_with_ooo?page=0%2C0 The simplest way to make databases in OpenOffice.org] An 3 page article by Solveig Haugland.
 + 
===Miscellaneous=== ===Miscellaneous===
*[http://en.wikipedia.org/wiki/OpenOffice.org_Base Wikipedia article on Base] *[http://en.wikipedia.org/wiki/OpenOffice.org_Base Wikipedia article on Base]
:includes lots of good links to documentation and tutorials :includes lots of good links to documentation and tutorials
 +
 +
 +==Database Examples==
 +*[http://www.ninthavenue.com.au/products/gemstone Gemstone]. A double entry accounting system.
 +
 +*[http://www.e-easel.org/staticpages/index.php/artdatabase ArtDatabase]. For use in a sculpture artists' gallery.
 +
 +*[http://sourceforge.net/project/showfiles.php?group_id=155237&package_id=172855 Inventory Database] at sourceforge.net.
 +
 +*[http://www.calmhey.com/5452.html Herbs] An example which tracks groups, cures, and myths for herbs. A commercial site, but the Herbs example database is Free.
 +
 +{{botlangbarEN|[[Fr:NeoOffice Base|Français]]}}<!-- [[De:|Deutsch]] [[It:|Italiano]] [[Es:|Español]]}}-->
 +[[Category:NeoOffice]][[Category:Tips and Hints]]

Current revision

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

NeoOffice Base allows you to either connect to an external database (MySQL, dBase, Calc, etc.) or to create an "embedded database" using the included HSQL database engine. In addition to entering and editing data, you can create Queries, Views, and Forms, as well as access any registered datasource in Writer and Calc documents.

Contents

Tips and Hints in the Wiki

Note that some of the pages are "stubs" consisting mostly of links to discussions on trinity.

Additional tips can be found on the New Articles Needed page, which contains links to stub pages and/or threads in trinity that need to be developed into full blown articles.

Connecting to and Importing from Other Databases

Other Base Tips in the Wiki


External Tips

Documentation, Tutorials, etc.

User Guides and Documentation

User Guides and Other "General" Documentation

Definitions

Using Macros in Base

HSQLDB and SQL Documentation

Books

Forums

Probably the oldest forum OpenOffice.org users. It is well frequented.
A newer OpenOffice.org forum. Many of the regulars also frequent ooforum.org, so double posting is not reccommended.

Tutorials

A new series of tutorials being written by one of NeoWiki's editors. Follows the creation of a database for tracking birding trips and sightings.
step-by-step construction of a small relational database for employees, with some advanced concepts like forms toward the end

Miscellaneous

includes lots of good links to documentation and tutorials


Database Examples

  • Gemstone. A double entry accounting system.
  • Herbs An example which tracks groups, cures, and myths for herbs. A commercial site, but the Herbs example database is Free.


This article in other languages: Français
Personal tools