[78-L] 78 database

[David Palmquist]

Hi David

Rhetorical question:  What is this date?  12/09/11

For dates, I suggest using 4 digits for the year and 2 digits for the 
month and date to facilitate sorting.  If you plan to share 
information, using the metric format might be wise: 1939-07-??

The mm/dd/yy format is primarily an American form; other English 
speaking countries use dd/mm/yy, or flipflop between the two, so your 
database may not be shareable with us foreigners.  You'll receive 
information in various formats, increasing the work involved in 
importing the data.

For the missing information, just an alphabetical character would do 
instead of a question mark or asterisk:  1939-07-dd  or 1939-07-xx.

If you only know the year, and not the month or date, you could go 
with 1939-mm-dd.

I haven't figured out how to get a usable huge database onto a 
webpage yet.  If you've got thousands of rows of data, html sortable 
tables don't work well.  I don't know how to upload a user-friendly 
database that can't be interfered with by visitors.  Any ideas?

David Palmquist




At 04:30 2010-07-06, you wrote:
>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
> >
>_______________________________________________
>78-L mailing list
>78-L at klickitat.78online.com
>http://klickitat.78online.com/mailman/listinfo/78-l