[78-L] 78 database

[David Palmquist]

Thanks for the tip re xataface, David.  I will have to look into MySQL.

Re the date, you could substitute zeroes for the unknowns, i.e., 1932-03-00

David Palmquist



At 21:05 2010-07-06, you wrote:
>The problem is only in converting the date from text to a real date field if
>it contains non-valid date info (like those '??'s).  Sure, if it remains as
>a text field representing the date, I would choose yyyy-mm-dd as that will
>sort correctly.
>
>I have a web page on my home network, that will handle this data (312610
>rows at this point!). It is built using Xataface, with minimal effort, and
>can be password protected (although I haven't done that yet).  Xataface uses
>php to construct the tables it displays, and they are sortable etc. Quite
>nice.  It's home webpage is here http://xataface.com/
>
>On Wed, Jul 7, 2010 at 10:59 AM, David Palmquist
><davidpalmquist at dccnet.com>wrote:
>
> > 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
> > _______________________________________________
> > 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