[Novalug] going from spreadsheet to database

[Bonnie Dalzell]

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?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                        Bonnie Dalzell, MA
mail:5100 Hydes Rd PO Box 60, Hydes,MD,USA 21082-0060|EMAIL:bdalzell at qis.net
Freelance anatomist, vertebrate paleontologist, writer, illustrator, dog
breeder, computer nerd & iconoclast... Borzoi info at www.borzois.com.
HOME www.batw.net    ART bdalzellart.batw.net  BUSINESS www.boardingatwedge.com