Success! and a thank you for those who helped.
| From: | Bill Mudry | Date: | Wed, 14 Jul 2010 05:29:03 +0000 |
| Subject: | Success! and a thank you for those who helped. | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-30216@lists.php.net to get a copy of this message | ||
Some of you may recall my request for information on appending information from one
table to another with the difficult part being not introducing new duplicate records.
I want to thank those that helped, especially Neil and Tyrael.
I had to first manually delete with care around 1,600 duplicate and triplicate lines out of an initial
6,550 records. I would have lost a lot of data using any script. Once that was done, I was ready
to try a script suggested by Tyrael. The source for the new data (the Tervuren file) had about
11,300 records with no duplicate lines. The destination 'species" file sans duplicates now
came in at 4947 records.
After adjusting names and parameters, I ran the script --- and was absolutely enthralled that
it worked perfectly. I was also amazed that it took only 0.563 seconds to go through such a
large collection of names when I though it would take a few minutes! Now my TAXA Wood
Knowledge website is reporting a much burgeoned 14,117 wood species names :-) :-)
As I had hoped and predicted, this has been a major successful advancement in the
project. Much Thanks!
There is one last fact worth sharing ;-) . Because I now have an algorithm and typical script
that worked, I have numerous other data lists that later can be processed one by one to
grow this total of wood names even much more. It has been a few years that I have looked to
having a software tool to do this.
Bill Mudry