[Babase] Re: The promised 'final' version of the weather data

kfenn kfenn at princeton.edu
Tue Mar 31 12:55:51 EDT 2009


Karl O. Pinc wrote:
>
> On 03/31/2009 10:59:11 AM, kfenn wrote:
>> Karl O. Pinc wrote:
>>>
>>> On 03/27/2009 03:28:59 PM, Karl O. Pinc wrote:
>>>>
>>>> On 03/27/2009 02:34:25 PM, kfenn wrote:
>>>>> Otherwise I guess we can talk more about the upload process on 
>>>>> Tuesday when I'm back.  I'm fine with all the columns and 
>>>>> populating the TRUE FALSE info.  I'll just need you to handle 
>>>>> bringing the date and time together.
>>>>
>>>> Bringing the date and time together means making another view
>>>> for you to use with the upload program.
>>>
>>> I changed my mind and decided that another view is more
>>> complicated than adding WRdate and WRtime columns to
>>> the MIN_MAXS (like) view(s).  So I went ahead and added
>>> the columns and a few more warnings in the docs
>>> about inserting into MIN_MAXS.
>>>
>>
>> I looked at some online excel help forums today and I found a way to 
>> bring these two together in one column.  On Friday, silly me looked 
>> at using things like datetime custom formatting and concatenate 
>> functions, but it turns out all I have to do is add a "+" to my excel 
>> function.  How stupid is that?
>>
>> So.....would you like to go back to the beginning, have me change the 
>> file to include a datetime stamp, and format all future uploads with 
>> the datetime stamp?  Would that save users from themselves?
>
> At this point it's up to you what you'd like.  I'm inclined to get
> rid of the cruft, but you're on the front lines.
>
Let me make reformat the file and send it to you off -list.  If the data 
in my datetime column look OK to you in terms of formatting, andif they 
go into Babase without creating problems, I'm quite happy to cut out the 
cruft too.

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list