[Babase] [Fwd: RE: prototype ready on Monday or Tuesday]
Leah Gerber
lgerber at duke.edu
Wed Aug 30 11:20:05 EDT 2006
-------- Original Message --------
Subject: RE: prototype ready on Monday or Tuesday
Date: Mon, 28 Aug 2006 16:21:58 -0400
From: Patrick Chu <patchu at itsyourturn.com>
Reply-To: patchu at itsyourturn.com
To: <alberts at duke.edu>
CC: Leah Gerber <lgerber at duke.edu>, Jeanne Altmann <altj at Princeton.EDU>
OK, I've posted the prototype on one of my servers:
http://papio.itsyourturn.com/main.php
This is running on one of my machines completely separate from the Duke Bio
database, so feel free to play around and import any many data sets as you
want. Also, I have a separate copy of the application AND the database on my
laptop, so there's a completely separate copy. You won't damage anything by
trying to break it (as long as you use the NA0306(a/b) as stated below.
Only one person can edit a data set at a time (but multiple people can be
editing different data sets at the same time). What this means is, if two
people are testing this at the same time, don't use the same name of
"NA0306" to describe your data set. Use "leahtest1" or "susantest1" or
something similar as the name.
>From the main page, click on the "import a data set" link. There are
instructions at the bottom of that page, which I've pasted here:
-----------------------------------------
Notes:
How to use this page:
1. Only the datasets "NA0306(a/b)" work at this time. The other formats will
be added later (this is easy to do)
2. Go into your excel spreadsheet, find the data set that you want to
import, and "select all" and then "copy"
3. "Paste" it into the text box above
4. Enter the name of the file and whether it is an A or B set
5. Click "Add" to save it to the database, or "Cancel" to return to the main
screen
6. You'll need to submit both an A and a B set in order to start the compare
7. You can enter the same data set again (as many times as you want) if you
make a mistake -- it will overwrite the previous import
8. Return to the main screen, and click on "Compare" to edit differences
-----------------------------------------
When you get to the data compare page, you can edit either the A or the B
set-- whichever you like. You can also edit one or all rows, whichever you
like. When you click "submit" the changes are saved to the database (in
temporary tables). You can then leave the application, and when you come
back, you can pick up where you left off.
Right now there's no change tracking on what changes you made and what the
original data was, but I can provide that in a separate table if you like.
Also, let me know if you ever change the dates on the data sets. If not, I
can take the date picker off that page, but if you do, I can leave it on.
The date picker is a handy way to change dates.
Some of the links look weird, but this is the standard Duke Biology CSS web
page formatting that I'm using. I don't like some of the formatting that
they've done. Let me know if you want me to change the appearance of
anything.
Things left to do on this project:
-- handle any type of input, not just the format above
-- Move project to a Duke Bio machine web space area
-- add my working tables to the Babase database
-- An "insert to live database" function that will take data from the
corrected input files and insert them into the "live" tables
I don't see any problems doing any of the above. The user interface is often
the hardest thing to nail down.
Let me know what you think.
-----------------------
Patrick Chu
mailto:patchu at itsyourturn.com
(919) 682-0027
http://www.itsyourturn.com - It's Your Turn, Inc.
60 seconds a day is all it takes.
Play online interactive chess, checkers, backgammon, Stack4,
Battleboats, reversi, and variations with friends and family!
-----Original Message-----
From: Susan Alberts [mailto:alberts at duke.edu]
Sent: Friday, August 25, 2006 12:10 PM
To: patchu at itsyourturn.com
Cc: Leah Gerber; Jeanne Altmann
Subject: Re: prototype ready on Monday or Tuesday
Patrick,
THanks for this update. I am happy that we'll be able to see a
prototype on Monday or Tuesday, this is great. I am also in agreement
with your billing suggestion, I do understand that there are first-
time startup costs and appreciate that you are willing to absorb some
of them.
Susan
More information about the Babase
mailing list