[Babase] WeatherHawk design review

Karl O. Pinc kop at meme.com
Mon Jul 6 18:28:25 EDT 2009


On 07/06/2009 02:32:07 PM, Niki Learn wrote:
> 
> > There was no data provided for 2300 on 2005-07-02 - that row should
> be
> > deleted.  I was not aware of duplicate date/times occurring.  A
> quick
> > look
> > at t29/05/2009 shows me identical data for the two dates.  I will
> > verify
> > that the others are like the same and then we can delete the extra
> > rows.
> > Problem solved.
> 
> Karl wrote:
> Yay!   700+ rows are a lot to delete manually.  It might be
> easier to delete with a sql delete statement and re-upload.
> 
> Maybe things got uploaded twice?
> 
> Niki wrote:
> Those data are in the original Excel sheet twice.  Each pair is right
> next
> to each other too.  They must have accidentally been pasted in twice
> and
> then at some point the whole lot sorted by date and hour to land them
> next
> to each other like that.  I want to delete them from the Excel sheet
> in any
> case.  But after I verify that they are all identical duplicates it
> may well
> be easier to delete them from babase using SQL.
> 
> 
> Niki further writes:
> Um, well the data being there twice in Excel appears only to be true
> for the
> first date on the duplicate list (2009-05-29).  The August 2008 dates
> are
> not duplicated in my Excel sheet.  I do not know why there are two
> copies in
> the whawks table on babase_copy.

The data's there twice in babase_pending.whawk.  Maybe the spreadsheets
got uploaded twice?  (Except, it seems, for the first of the month.)

select date, time
   from babase_pending.whawk
   where date >= '2008-08-01'
         and date < '2008-09-01'
   order by date, time;

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list