OpenOffice

ATPM 14.04 - FileMaking: Getting Relational. FileMaker is described as a relational database.

Most of us have at least an intuitive idea of what a database is. While we covered the relational aspect in some detail in the first column, we’re going to look more closely at its meaning here. Some of what will be presented here is theoretical, but it will have practical applications, and the only portions of relational theory that we’ll cover will be those directly applicable to FileMaker databases. What Is a Relational Database? Long ago in the neolithic era of computing (1969), Edgar Codd wrote an article describing the relational model of database structure that is the basis of modern relational databases.

The basic idea of Codd’s relational model was that data should be broken into tables, and tables are made up of columns and rows. Normalization Normalization is a rather theoretical and complex topic, but in regard to building FileMaker databases, it can be broken down into the following guidelines: Example Design Breaking the Rules. Importing a csv file directly into base. GWJackson: You have asked, what in my opinion, is a good question about BASE. That is, how to get data from a CSV ( or text file ) into the database . . . with the least effort. I will assume, that you are using the HSQL ( embedded database ), rather then something like dBase, MySQL, SQLite, Access, etc as your database engine. Furthermore, I will assume, you already have a Base table defined, AND, that your CSV or TEXT file 'matches' the HSQL table.

I mean, the 'data' in the Base table is in the same 'order' as the CSV or TEXT file. The 'issues' are Create a 'link' so Base will know about the text file . . . the name, and kind of file . . . Once Base knows about this CSV or TEXT file, how to 'easily' get it into Base. Well, there are a few ways to make the above simple, up, to the best of my knowledge . . . as of this date . . . there is no 'WIZARD' to do it.

Anyway, these are the steps. For the FIRST item above (create a link to a text file Base will know about): [Tutorial] Using csv/text files as editable data source. (View topic) HSQLDB database engine allow to connect existing csv/text as editable data source.

Details can be found in 6th chapter in HSQLDB documentation: To use this feature you can not use wizards or table design mode, you must create table with SQL command window. This type of connection can be created if you follow this steps:1. Create new odb file, save this file into folder where your csv/text table sits.2. Create database table structure, which mirror of your csv file. To demonstrate this feature use csv file names.csv: Code: Select all Expand viewCollapse view ID,FirstName,Name,DOB1,John,White,1960-01-232,Elisabeth,Smith,1972-11-103,Eric,Long,1987-04-07 First create new odb file with name: names.odb.Second, go to the menu Tools > SQL... and open SQL command window.Insert into: CREATE TEXT TABLE "Names" ("ID" INTEGER PRIMARY KEY, "FirstName" VARCHAR(20), "Name" VARCHAR(20), "DOB" DATE);

Table of Contents - OpenOffice Database: ooBase Tutorials - fdb1main. For other topics, same author, go to AUTHOR'S MAIN SITE This article, as it stood at 18 September 2012, is available, translated by humans, into Serbo-Croatian by Web Geeks.

Custom Search- Results will open in new window or tab Bookmark this on Delicious Recommend to StumbleUpon "ooBase", aka "Base" (Also has articles about other OpenOffice components) First: a few "stop press"... the main table of contents is just a little further down the page Oh no! Scary, weird, form incident... Good news? Table of contents- Main Page for FDB ("Free Data Base") Tutorials from Sheepdog Guides ( First three groups of tutorials grouped to help you do first things first ) ( Other tutorials, for when you've got started ) ( Et cetera ) Just before we continue to the main part of this page....

Thank you! ... to all the people who have deemed these pages worthy of recommendation to others. Also.... I try to make my pages browser friendly. Page contents © TK Boyd, Sheepdog Software, 2/06-12/12. First section: Macros: