[78-L] 78 database

[David London]

58,000 - that's a lot of 78s!

For an exercise today, I converted the abrams text files that I just
downloaded, into csv format, then imported them into mySQL, each file to a
separate table.

I can therefore export them as SQL dumpfiles from phpmyadmin to load into
nearly any database, or just back to csv format for spreadsheets etc.  if
that's of any use to anybody.

 I haven't really altered the data except to remove any quotes or
backslashes that were screwing up the import. One data field that needs
attention is the date field. In the text files they are entered in various
ways, including with question marks if part of date was missing e.g.
7/??/39.  I'll have to think about what to do with that.

I also, copied each table into one large table,  but it's large and a bit
slow on my little test server.  I am working on the best way to handle so
much data.





On Tue, Jul 6, 2010 at 1:07 PM, Steven C. Barr <stevenc at interlinks.net>wrote:

>
> >
> Well, I currently own around 58,000 78's (probably a very few duplicates
> among them?)...it's now a race to see how many of those I can list in MS
> Access files...?! I'm currently working on around 200 that Lennick dropped
> off last week (now I need more milk boxes...?!). My current plans are to
> get artist/title data from the Abrams-file listing, adding/correcting as
> needed. Note that I also have around 300 or so 78's in my accumulation
> I haven't yet entered...?!
>
> Steven C. Barr
>
> _______________________________________________
> 78-L mailing list
> 78-L at klickitat.78online.com
> http://klickitat.78online.com/mailman/listinfo/78-l
>