NeoBase

From NeoWiki

Revision as of 07:02, 28 February 2009 (edit) Sardisson (Talk | contribs) (→Connecting to and Importing from Other Databases - delete reference to removed article) ← 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)
(2 intermediate revisions not shown.)
Line 8:		Line 8:
	===Connecting to and Importing from Other Databases===		===Connecting to and Importing from Other Databases===
		+	* [[Configuring MySQL using ODBC and NeoOffice Secure Edition]]
	* [[Configuring MySQL using JDBC and NeoOffice 2.x]]		* [[Configuring MySQL using JDBC and NeoOffice 2.x]]
	* [[Configuring MySQL using ODBC]]		* [[Configuring MySQL using ODBC]]
Line 14:		Line 15:
	* [[Working with dBase databases]]		* [[Working with dBase databases]]
	* [[Working with Microsoft Access 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===
Line 20:		Line 22:
	* [[Using the Mail Merge Wizard]] (in Writer, but using Base datasources)		* [[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.		* [[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>		<br>

---

Current revision

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 1 Tips and Hints in the Wiki 1.1 Connecting to and Importing from Other Databases 1.2 Other Base Tips in the Wiki 2 External Tips 3 Documentation, Tutorials, etc. 3.1 User Guides and Documentation 3.1.1 User Guides and Other "General" Documentation 3.1.2 Definitions 3.1.3 Using Macros in Base 3.1.4 HSQLDB and SQL Documentation 3.2 Books 3.3 Forums 3.4 Tutorials 3.5 Miscellaneous 4 Database Examples

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

• Configuring MySQL using ODBC and NeoOffice Secure Edition
• 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
• Migrating an AppleWorks database to NeoBase

Other Base Tips in the Wiki

• Using a Calc spreadsheet as a data source
• 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.

External Tips

• Adding a Button to Search on a Form
• 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.
• OOo Basic crash course: Creating charts with Base and Calc

Documentation, Tutorials, etc.

User Guides and Documentation

User Guides and Other "General" Documentation

• OpenOffice User Guide Chap 7
• OpenOffice.org wiki "main page" for the Base component.
• PDF Article on Advanced Report Techniques, Including SQL-Based Calculated Fields on Reports. By Solveig Haugland
• OOo Base Primer A brief overview of Base, with detailed information on connecting to MySQL.

Definitions

• Built-in Functions and Stored Procedures that can be used in Queries.
• List of Data Types

Using Macros in Base

• OOBasic Database Dev.pdf Covers Statement, ResultSet, & RowSet Services by Roberto Benitez.
• 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
• Andrew Pitonyak on using Macros with Base

HSQLDB and SQL Documentation

• HSQLDB User Guide (HSQLDB is the underlying database engine in Base)
• Good guide on SQL, Suggested by the HSQLDB User Guide
• Introduction to SQL

Books

• Books on database design from OOoForum.org

Forums

• OOoForum.org discussion forum for Base

Probably the oldest forum OpenOffice.org users. It is well frequented.

• OpenOffice Community Forums

A newer OpenOffice.org forum. Many of the regulars also frequent ooforum.org, so double posting is not reccommended.

Tutorials

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

• SheepDogGuides a collection of smaller Base tutorials
• Dai's Tutorials for Base video tutorials
• OOo Base Primer
• 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

• Visual tutorial for Base from InPics
• Two-part introduction to Base for database beginners: Part 1, Part2

• The simplest way to make databases in OpenOffice.org An 3 page article by Solveig Haugland.

Miscellaneous

• Wikipedia article on Base

includes lots of good links to documentation and tutorials

Database Examples

• Gemstone. A double entry accounting system.

• ArtDatabase. For use in a sculpture artists' gallery.

• Inventory Database at sourceforge.net.

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