Thanks Shlomi,<br><br>I'll have a play at the weekend.<br><br>Many thanks for your work on this.<br><br>Leo<br><br><div class="gmail_quote">2009/12/9 Shlomi Fish <span dir="ltr"><<a href="mailto:shlomif@iglu.org.il">shlomif@iglu.org.il</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi all!<br>
<div><div></div><div class="h5"><br>
On Monday 23 Nov 2009 22:34:09 Leo Lapworth wrote:<br>
> Hi,<br>
><br>
> 2009/11/23 Shlomi Fish <<a href="mailto:shlomif@iglu.org.il">shlomif@iglu.org.il</a>><br>
><br>
> > MySQL-only SQL file and the table is MyISAM.<br>
><br>
> Feel free to change it to any MySQL type, even if CSV is fine<br>
><br>
> > <a href="http://www.perlfoundation.org/perl5/index.cgi?lost_mailing_lists" target="_blank">http://www.perlfoundation.org/perl5/index.cgi?lost_mailing_lists</a><br>
> ><br>
> > Should we remove them from the SQL too?<br>
><br>
> Could you add a column 'defunct' and flag those in the SQL that are dead?<br>
><br>
> The SQL may give me some idea about how to structure the table<br>
><br>
> > appropriately.<br>
> > Seems like the identifier of the table is the "name" column.<br>
><br>
> Yep<br>
><br>
> > In any case, I'll try to get it tomorrow.<br>
><br>
> Fantastic - thanks<br>
><br>
<br>
</div></div>Well, sorry for the long delay, but I have something a bit more ready:<br>
<br>
<a href="http://www.shlomifish.org/Files/files/test_perl5_mailing_lists.dump.gz" target="_blank">http://www.shlomifish.org/Files/files/test_perl5_mailing_lists.dump.gz</a><br>
<br>
I got it by using this code:<br>
<br>
<a href="https://svn.berlios.de/svnroot/repos/web-cpan/perl.org-work/trunk" target="_blank">https://svn.berlios.de/svnroot/repos/web-cpan/perl.org-work/trunk</a><br>
<br>
And running:<br>
<br>
$ perl <a href="http://collect-mailing-lists.pl" target="_blank">collect-mailing-lists.pl</a><br>
$ perl <a href="http://setup.pl" target="_blank">setup.pl</a> # Run once to create the database.<br>
$ perl <a href="http://process-db.pl" target="_blank">process-db.pl</a><br>
<br>
It doesn't populate all the tables yet, but hopefully I'll work on it. You'll<br>
need <a href="http://search.cpan.org/dist/DBIx-Simple/" target="_blank">http://search.cpan.org/dist/DBIx-Simple/</a> for it and YAML-XS naturally.<br>
<br>
Regards,<br>
<br>
Shlomi Fish<br>
<div class="im"><br>
--<br>
-----------------------------------------------------------------<br>
Shlomi Fish <a href="http://www.shlomifish.org/" target="_blank">http://www.shlomifish.org/</a><br>
</div>"The Human Hacking Field Guide" - <a href="http://shlom.in/hhfg" target="_blank">http://shlom.in/hhfg</a><br>
<br>
Bzr is slower than Subversion in combination with Sourceforge.<br>
( By: <a href="http://dazjorz.com/" target="_blank">http://dazjorz.com/</a> )<br>
</blockquote></div><br>