Creating a Database in NeoOffice 1.x

From NeoWiki

Revision as of 03:43, 15 September 2005 (edit) Sardisson (Talk | contribs) m (forgot to add categories to new page :-() ← Previous diff		Current revision (18:17, 23 October 2008) (edit) (undo) Sardisson (Talk | contribs) m (Creating a Database moved to Creating a Database in NeoOffice 1.x: this is most relevant for Neo 1.x)
(13 intermediate revisions not shown.)
Line 1:		Line 1:
-	While NeoOffice/J 1.1 and OpenOffice.org/X11 1.1.x do not contain a database component similar to Microsoft Access, it is still possible to create a database (this is handy if you don't have access to [[Using MySQL|MySQL]] or another external database).	+	{{handbook sidebar|DatabaseTOC}}
		+	While NeoOffice 1.2 and OpenOffice.org/X11 1.1.x do not contain a database component similar to Microsoft Access, it is still possible to create a database (this is handy if you don't have access to [[Configuring_MySQL_using_JDBC_and_NeoOffice_2.x|MySQL]] or another external database).
	[[User:Max_Barel|Max]] offered the following tips on [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=11456#11456 trinity]:		[[User:Max_Barel|Max]] offered the following tips on [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=11456#11456 trinity]:
-	There is a simple database functionality in OOo and thus NeoJ : use the dbase file format.	+	There is a simple database functionality in OOo and thus Neo: use the '''dbase''' file format.
	This is not a full-featured database but it works for most cases.		This is not a full-featured database but it works for most cases.
Line 10:		Line 11:
	# create a new data source		# create a new data source
	# select a dbase format		# select a dbase format
-	# name the dbase file (edit: folder) as you like; the folder will contain the table files created later	+	# choose the folder (directory) where the table files will be stored. If the folder already contains <tt>.dbf</tt> files, the tables they describe are automatically added to the database. This is a simple way to import dBase files
	# close the panel		# close the panel
-	# edit: add a table to the base, defining colums as you need.	+	# add a table to the base, defining colums as you need.
-	# then open the recently created dbase file (edit: table) and add/modify/delete item in the table.	+	# open the recently created table and add/modify/delete item.
	# use the data-source as planned (mailing and such)		# use the data-source as planned (mailing and such)
-	See the NeoOffice/J help for details.	+	See the NeoOffice Help for details.
-	I write this from memory, without checking the process but, roughly, this is it and worked many times for me.	+	Before editing this wiki page I ([[User:Max_Barel|Max]]) checked the above process.
-		+	{{botlangbarEN|[[fr:Créer une Base de Données|Français]] [[de:Eine_Datenbank_erstellen|Deutsch]]}}
-	[[Category:Tips and Hints]][[Category:NeoOffice/J]][[Category:OpenOffice.org]]	+	[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]

---

Current revision

Introduction to NeoBase Configuring MySQL using ODBC and Mac App Store versions of NeoOffice Configuring MySQL using JDBC and NeoOffice 2.x Configuring MySQL using ODBC Configuring hsqldb Configuring postgresql Configuring FileMaker Pro Working with dBase databases Using a Calc spreadsheet as a data source Using your database with NeoOffice

While NeoOffice 1.2 and OpenOffice.org/X11 1.1.x do not contain a database component similar to Microsoft Access, it is still possible to create a database (this is handy if you don't have access to MySQL or another external database).

Max offered the following tips on trinity:

There is a simple database functionality in OOo and thus Neo: use the dbase file format. This is not a full-featured database but it works for most cases.

How-to:

1. display data-source pane
2. create a new data source
3. select a dbase format
4. choose the folder (directory) where the table files will be stored. If the folder already contains .dbf files, the tables they describe are automatically added to the database. This is a simple way to import dBase files
5. close the panel
6. add a table to the base, defining colums as you need.
7. open the recently created table and add/modify/delete item.
8. use the data-source as planned (mailing and such)

See the NeoOffice Help for details.

Before editing this wiki page I (Max) checked the above process.