[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