[Novalug] going from spreadsheet to database
jbholland at gmail.com
Fri Mar 26 14:29:03 EDT 2010
If you have existing ID numbers for the dogs, use those as data elements: ie
Dog ID MotherID FatherID
Lassie 1 2 3
LassMom 2 NULL NULL
LassDad 3 NULL NULL
LassSister 4 2 3
LassPup 5 1 6
LassBeau 6 ................................
If you already have numbers with these sorts of relationships. use them
as data elements - don't try and make generated IDs match up with them.
the table description would include .........MotherID foreign key dogs(id)
(something like that anyway)
On 03/26/2010 02:05 PM, Bryan J. Smith wrote:
> Have you considered using OpenOffice.org (OOo) Base as your front-end
> for all this? You can access the data from OOo Calc as well, but Base is
> definitely built for automating much via its GUI Designer and built-in script.
> Base doesn't have a full SQLite driver yet (you can still use it, but you can't
> use the BASE GUI Designer to change things), but it does its own HSQL, as
> well as tie-ins to MySQL, PostgreSQL and other, full SQL services. It also
> supports anything that can talk ODBC or JDBC, so that's another layer you
> could use if you want.
> ----- Original Message ----
> From: Bonnie Dalzell<bdalzell at qis.net>
> I finally found a tool that runs on my Linux tower set up that allows me
> to import into SQLite. It is a firefox add on.
> I am not trying to do MySQL right now because I seem to have really messed
> up the MySQL install on the desktop tower. I cannot get it to accept a new
> password, so I cannot connect to the server. I have tried completely
> uninstalling it and reinstalling it. After spending a large number of
> hours I think all I can do is to reinstall Ubuntu in my / directory which
> I do not want to do right now.
> So I am taking the pre-existing dog pedigree database which exists
> as a series of pipe separated text files and importing it into series
> of sqlite tables.
> Two of the relationships from a dog to the record number of its mother and
> to the record number of its father should be referring to the record
> number in the same table - the main dog record table.
> Does anyone have the time to suggest to me how to get those fields in the
> main table to refer to the same table. Can I do this after importing?
> Novalug mailing list
> Novalug at calypso.tux.org
More information about the Novalug