Hi all —

The issue of CrateType still showing in Home Location column in the GUI after the HomeCrateID value has been zeroed out in ObjComponents table has been confirmed by Gallery Systems as a bug affecting both 2010 and 2012. It has been logged for a fix in a future release.

Thanks,
Scott



From: <Williams>, Scott Williams <[log in to unmask]>
Reply-To: "The Museum System (TMS) Users" <[log in to unmask]>
Date: Thursday, May 15, 2014 at 4:33 PM
To: "[log in to unmask]" <[log in to unmask]>
Subject: Un-setting home locations

Hi all — 

We need to un-set the Home Locations for a group of objects without changing their current locations. I have an idea about how to go about this but was curious if other institutions have run into this problem or if there might be another way to do it. The most obvious method AFAIK would be to zero out the Home locations columns in ObjComponents. 

UPDATE oc
SET oc.HomeCrateID = NULL,
oc.HomeLevel = NULL,
oc.HomeLocationID = -1,
oc.HomeSublevel = NULL,
oc.SearchHomeContainer = NULL
FROM ObjComponents oc 
WHERE /* whatever */

The alternative to this would be move the objects, via SQL, (I do not believe you can update the Home Location without changing the Current Location) to a “Virtual Home” location. This "Virtual Home” is simply a place holder that should never be used as a Current Location which means we would then have to write a notification job that would alert us if any object that were accidentally “returned to home” to the Virtual Home. This isn’t a huge problem but it is one more daily notification that would need to be tracked and managed by collections staff.

The major issue I have run into while testing the first option is the Crate Type text not being cleared from the Home Location column after the ObjComponents home location data was zeroed out. For example, if I run the above SQL on an object whose Home Location includes a Crate then what we see after the update is this: 


And I cannot figure out why or how the Crate Type value is still being populated into the Home Location column.  Has anyone ever needed to unset Home Locations? How did you go about doing it? 

We are running TMS 2010 and SQL Server 2008. 

Thanks,
Scott

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.