The inability to add attributes to batches of records, whether simple
Object related attributes, or exhibition statuses to a selection of
objects related to an exhibition, is one of the biggest gripes that
users have. When attempting to implement and support TMS to support
activities, such as organising an exhibition, this is the sort of thing
that can make a big difference in terms of users accepting and using
TMS, or not - the sort of single issue that's given as a reason for not
using TMS, there being a whole variety of others, many not having
anything actually to do with the system viewed in narrow terms! Perhaps
reflects a tendency to build up batches of data entry rather than
updating info as changes become known, which might not be the best way
to tackle the job in an ideal world, but this tends to be how people use
the system - something comes into the organisation on paper, and then on
a Friday afternoon TMS is updated (probably reflecting a continued
reliance on local, paper-based systems, to manage activity?!)

Jon

Jon Thristan
Collections Information Manager
Tate
Millbank
London SW1P 4RG

t:  +44 (0) 20 7887 8983
e:  [log in to unmask]
w: www.tate.org.uk

The information in this e-mail is confidential and may be legally
privileged. It is intended for the addressee only. Access to this e-mail
by anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted to
be taken in reliance on it, is prohibited and may be unlawful. This
e-mail does not constitute an offer or a contract



-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Ella Rothgangel
Sent: 05 September 2006 19:12
To: [log in to unmask]
Subject: Re: Copying Attributes from one media record to another


I have used SQL Enterprise to insert an attribute into a batch of
objects through an object package.  I use SQL first to look up the
term's term ID, Thesxreftype ID, and the object package ID.  I then
insert those IDs into the following statement:

Insert into ThesXrefs (ThesXrefTypeID,ID,TableID, TermID,
ThesXrefTableID, DisplayOrder, Remarks, Active, LoginID, EnteredDate,
RemovedLoginID, RemovedDate) Select 4, ObjPkgList.ObjectID, 108,
2035380,343, Null, NULL, 1, 
'Ella', GetDate(), Null, Null
From ObjPkgList Where ObjectPackageID = 4598

It works well for me, but then I have not used it to try and
batch-correct, just batch add.

Hope this helps.

Ella

Ella Rothgangel
Collections Database Administrator
Saint Louis Art Museum
[log in to unmask]




-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Christine Droll
Sent: Tuesday, September 05, 2006 10:35 AM
To: [log in to unmask]
Subject: Re: Copying Attributes from one media record to another

Hi Jeri,

That's great if you want "all" the records changed.  But I want only a
selection from the Objects module.  Unless I'm missing something. . .

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Jeri Moxley
Sent: Tuesday, September 05, 2006 10:03 AM
To: [log in to unmask]
Subject: Re: Copying Attributes from one media record to another

Hi Christine,

Did you know that in cases where you want to update *all* instances of
links to a thesaurus term, you can do that in Configuration through a
batch update to thesaurus links? i.e., if you want *all* links to
Costume to be changed to Clothing...

It's under Configuration: Edit menu > Search and Replace > Linked
Thesaurus Terms


Best,
Jeri
 

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Christine Droll
Sent: Tuesday, September 05, 2006 10:41 AM
To: [log in to unmask]
Subject: Re: Copying Attributes from one media record to another

My beef with Attributes is not being able to do a batch update on
several hundred records at a time.  If I want to change Costume to
Clothing, I have to do so with each record.  How lovely it would be to
place them all in an Object Package and change them in one go.

Of course, this would only work with the Objects module.

I would like to see the other modules have the capability to group
records into packages for similar batch updating.

Christine Droll | Collections Database Administrator | The Nelson-Atkins
Museum of Art | Kansas City, MO  

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Peter Manuelian
Sent: Tuesday, September 05, 2006 7:34 AM
To: [log in to unmask]
Subject: Copying Attributes from one media record to another

Hi all,

In the Media module, I'm watching my poor staff add tons of Attributes
to a media record (thesaurus terminology), and then they have to add all
those very same Attributes again, one by one, to the next media record,
even if it is more or less a dupe. 

How wonderful it would be in the next version of TMS to "copy all
attributes" from one record and "paste" them into another record. Anyone
else struggling with this time-waster?

Thanks,

Peter

Peter Der Manuelian
Giza Archives Project Director
Museum of Fine Arts, Boston
www.mfa.org/giza, www.gizapyramids.org