{groups} [HPFGU-Catalogue] Re: Having two databases

[Paul Kippes]

Alright, I've worked out a way that should be fine assuming there is
very good communication between Carolyn and Kelly.  Carolyn must
always communicate the ID of the new category to Kelly.  And Kelly
must always use that ID when creating a new category.

Kelly's computer will show an extra field when creating categories to
allow her to override the category ID.  This is only during the
creation phase.  So once the category has been created, the IDs must
match.  If not, the best thing would be for Kelly to delete the newly
created--yet incorrect--category and create again (with the correctly
ID).

I'll remove those TBD categories, redump the database, and reupload
the new dump.  No sense having several procedures to do this.


--- a_reader2003 <carolynwhite2 at aol.com> wrote:

---------------------------------
--- In HPFGU-Catalogue at yahoogroups.com, "kippesp" <paul-groups at w...> 
wrote:
> If everything works with installing the DB on Kelly's computer, 
> we'll need to adjust how a few things are done.
> 
> I've added some place holder categories (see end of cateogy list). 

> Since all the database relations are kept using a numeric ID, there

> is the potential for problems if the two databases get out of sync.
> 
> This should be the basic scenerio for adding a category:
> 
> Reviewer: "I need a category 'confusing issues'"
> Carolyn: "Okay, TBD1 will be renamed 'confusing issues' and moved 
to 
> be a sub category of TEXT ANALYSIS"
> Carolyn: "Kelly, you need to update your category list!"
> Kelly: "Okay, TBD1 will be renamed 'confusing issues' and moved to 
> be a sub category of TEXT ANALYSIS"
> 
> The important thing to not is that neither database will have added

> a category, only renamed an existing one.  If 9 is not enough, its 
> too late unless I make a copy for Kelly again--possible, just 
> worried about having enough time.

Carolyn:
Um..no, not sure I entirely follow what I am supposed to do. However,

if the nine place holder categories at the end of the list are some 
kind of temporary stand-ins to help reconcile Kelly's dbase and ours 
when she gets back from her trip, I would guess that they would not 
be enough. For example, there are 6 new categories this week alone, 
and its a quiet week! But I have probably misunderstood their
purpose.

BTW Kelly, are you ok with me emailing the weekly update to you, or 
would you like that text shortened or changed in any way. Don't want 
to embarass you if the text can be read by the whole ship ! (On the 
other hand, you could recruit the whole crew to help..)




---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/HPFGU-Catalogue/
 
   To unsubscribe from this group, send an email to:
HPFGU-Catalogue-unsubscribe at yahoogroups.com
 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.




	
		
__________________________________
Do you Yahoo!?
Yahoo! Domains  Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer