TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Smith, Allison" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 13 Jul 2006 08:52:13 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (71 lines)
Hi Jeffrey -
I've run this update several times, and haven't had a problem.  We have about 30K records in the database, but only about 15K with dimensions recorded.  The process took about 1/2 hr. - 45 min., if I remember correctly (it was a while ago).
Hope this helps.
Allison
..................................................................
..................................................................
the warhol:
Allison A. Smith
Collection Manager / Database Administrator
117 Sandusky Street
Pittsburgh, PA 15212
T   412.237.8345
F   412.237.8340
E   [log in to unmask] <mailto:[log in to unmask]>
W  www.warhol.org <http://www.warhol.org>
W  www.warholstore.com <http://www.warholstore.com>
 
The Andy Warhol Museum
One of the four Carnegie Museums of Pittsburgh
..................................................................
..................................................................
They always say that time changes things, but you actually have to change them yourself -- Andy Warhol
..................................................................
..................................................................



-----Original Message-----
From: The Museum System (TMS) Users
[mailto:[log in to unmask]]On Behalf Of Jeffrey Smith
Sent: Wednesday, July 12, 2006 5:19 PM
To: [log in to unmask]
Subject: Update Display Dimensions


The Freer and Sackler Galleries are currently in the process of simplifying
the practice of recording object dimensions in TMS, largely by reducing the
number of dimension elements and ensuring that only one dimension is set to
write to the objects dimension field.

At the end of the scrubbing process, we intend to use the "Update All
Display Dimensions" control in the Dimensions Authority.

This control will rewrite the current text in Objects.Dimensions with
whatever dimension elements are checked in the Dimensions Assistant. Kind of
scary!

Gallery Systems has kindly offered to provide a temporary license so this
dramatic update can be tested on a copy of the database, and we will of
course back up the database when running the final update.

My question is: have any other TMS users out there ever run this update? If
so, did you encounter any problems? How long did it take for the size of
your database?

Thanks in advance for any advice, suggestions.



Jeffrey Smith
Assistant Registrar for Collections Information
Freer Gallery of Art & Arthur M. Sackler Gallery
Smithsonian Institution
P.O. Box 37012
Sackler 1040, MRC 707
Washington, D.C. 20013-7012
[log in to unmask]
tel: 202-633-0348
fax: 202-633-9770
http://www.asia.si.edu

ATOM RSS1 RSS2