[78-L] 78 database

[David London]

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
>