Import Librivox editions (and updates)

From Chris:
Attached is a mysqldump of our database. I've excluded one table,
because it includes email addresses of our volunteers; that table has
the form:

CREATE TABLE `People` (
  `PeopleID` int(8) NOT NULL auto_increment,
  `Name` char(80) character set utf8 default NULL,
  `Nickname` char(80) character set utf8 default NULL,
  `EMail` char(80) default NULL,
  `URL` char(150) default NULL,
  `MaxMC` int(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`PeopleID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=3334 DEFAULT CHARSET=latin1;

If you want any help interpreting the data, let me know! One unobvious
bit of information which will help: in the Files table, a FileNumber
of 0 is used to hold project level information. You'll also find
duplication or near-duplication between the Projects table and the
Files table; this is an artifact of the way the system has developed.
The Files table is probably generally to be preferred.

Hi Chris,

Can you illuminate the arcane process of LibriVox --> Archive.org data transfer? See Edward's question below, asked in context of getting LibriVox data into Openlibrary.

I've copied Kara too, who might be able to comment more specifically on the more hands on parts of things.

Hugh.

----------------------------------------------------
Hugh McGuire
librivox.org | hughmcguire.net
@hughmcguire
tel: +1.514.464.2047| skype: h.mcguire
-----------------------------------------------------

On Sep 27, 2010, at 4:09 PM, Edward Betts wrote:

> > Hi Hugh,
> >
> > We're going to start loading LibriVox books into Open Library but we want the data to arrive via archive.org
> >
> > Some of the metadata in your database doesn't make it into archive.org specifically, language and copyright date.
> >
> > Here is an example:
> >
> > LibriVox data: http://home.us.archive.org/~edward/librivox/47.html
> > And: http://www.archive.org/details/count_monte_cristo_0711_librivox
> >
> > Can you change your process to include language and copyright date when you upload books to archive.org
> >
> > Thanks.
> >
> > --
> > Edward.