[Novalug] going from spreadsheet to database

[John Holland]

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)

my .02



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
> http://calypso.tux.org/mailman/listinfo/novalug
>