We tried both, but Thor came up with a solution utilizing Crystal around the time I was sending out our cry for help!

It’s still a long list because of the components, but 11,000 results are better than 44,000.

We’re taking the data into excel so we can filter and sort on the different gallery locations to work with the results.  This is a one-off for now, running on an object package, but I think we’ll transition it into an internal report option when we’re done.  Not sure how the parameters will work, but that’s a problem for later!

--Jessica

 


Jessica Milby
Assistant Director for Collection Information

t 215-684-7283
f 215-235-0035

Philadelphia Museum of Art
PO Box 7646, Philadelphia, PA 19101-7646
www.philamuseum.org

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Wednesday, October 28, 2015 3:46 PM
To: [log in to unmask]
Subject: Re: snapshot by location of historical locations...*head spinning*

 

Are you trying to do this as a SQL query or in Crystal Reports?

On Oct 28, 2015 11:34 AM, "Milby, Jessica" <[log in to unmask]> wrote:

Hi everyone,

We are trying to get a snapshot of the locations of objects saved in a package for a specific time period.  I know what was on view at the time, but I’d like to know where everything was.  These might have moved in before or during our date range, might still be there, or might have since moved out.  We’re finding the TransDate isn’t adequate for those reasons, and the DateOut hasn’t proven very useful.  For 6600 objects, the data we have yields over 33,000 results--too many for my project timeline.  

Does anyone have a script/view/report that can help us out?

It seems like a simple question until you dive into the ObjLocations and the available date fields.  I feel like this kind of historical snapshot ought to be available…we’re working on something non-incident related, but I can imagine how a late discovery of a conservation issue, or building incident could lead to needing this sort of thing.  Usually we’d be reporting on current locations, but the crux of this is that it’s historical ones.

Any help…?

Thanks,

Jessica

 

 


Jessica Milby
Assistant Director for Collection Information

t 215-684-7283
f 215-235-0035

Philadelphia Museum of Art
PO Box 7646, Philadelphia, PA 19101-7646
www.philamuseum.org

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.

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.