[Babase] Re: manual census entries

Lacey Maryott Roerish lroerish4 at gmail.com
Wed May 5 16:55:03 EDT 2010


MY UPDATE STATEMENTS ARE

UPDATE RANKS SET SNAME = 'AMO' WHERE SNAME ='BIL';
UPDATE PARTS SET SNAME = 'AMO' WHERE SNAME ='BIL';


On Wed, May 5, 2010 at 4:49 PM, Karl O. Pinc <kop at meme.com> wrote:

> On 05/05/2010 03:39:44 PM, Niki Learn wrote:
> > Yes, you have to be babase_admin to empty members.  I do it every
> > update.
> > Actually I didn't even try NOT emptying members - I just assumed it
> > would be
> > necessary since we were messing with census data.  But then it threw
> > errors
> > when I tried to change the census entries to manual because the
> > latter
> > part
> > of Amok's life had not been rebuilt yet in members so it didn't like
> > him
> > having ranks and stuff when he wasn't listed as being in the group.
> > Do you
> > think we could have skipped the members part.
> >
> > We can't delete Billy's census data until the end, after all his
> > ranks
> > and
> > parts data has been switched over to Amok.  We can't switch that over
> > until
> > Amok is in census.  It is a circle.
>
> There's no restriction on having Amok and Billy be censused in
> the same group.  So I'd expect you'd add Amok's census entries
> first, then move all the data by deleting stuff from Billy
> and adding it to Amok, then delete Billy's census entries
> last.
>
> The basic principle would be to delete in an order that's
> opposite from the order in which you add.
>
>  I guess if there is a way to do
> > all
> > three simultaneously then we wouldn't need as many steps.  But I got
> > rid of
> > most of the manual census entries anyway so whatever.  This worked so
> > we are
> > happy.
>
> Yes.  You don't care so much about deleting Billy's members because
> you know he's going away so you don't care about errors.  It's
> just a little spooky having to be babase_admin.  Sort of like
> resorting to a hammer.  Nothing wrong with a hammer though,
> it's a fine tool.  :-)
>
> >
> > -----Original Message-----
> > From: Karl O. Pinc [mailto:kop at meme.com]
> > Sent: Wednesday, May 05, 2010 4:26 PM
> > To: Niki Learn
> > Subject: Re: manual census entries
> >
> > On 05/05/2010 03:20:10 PM, Niki Learn wrote:
> > > I guess we should make sure each office has a full list of the
> > steps
> > > in case
> > > we ever have to do this again.  Most of them aren't in here though.
> > > Shall
> > > we compile a list of the steps and send that to the list for
> > > archiving?
> > > Here's what I have:
> > >
> > > Empty members
> >
> > Wouldn't you have to be babase_admin to do this?
> >
> > As an alternative why not delete all the
> > census rows?
> >
> >
> >
> >
> > Karl <kop at meme.com>
> > Free Software:  "You don't pay back, you pay forward."
> >                  -- Robert A. Heinlein
> >
> >
> >
> >
>
>
>
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                 -- Robert A. Heinlein
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>



-- 
- -
Lacey K. Maryott Roerish
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100505/cf23a8ec/attachment.html


More information about the Babase mailing list