Hi Ariel

You could use the "search and replace" after you load the batch in the objects midule. Select the field (description, medium, etc.)and replace the empty contents with what you wanted to enter.

Before entering a new object, I use the Importer tool, enter everything you want into the excel spreadsheet and import.

I'm happy to help if you need further assistance

Hamutal Gabayev
Registrar
Bible Lands Museum Jerusalem
[log in to unmask]

Hamutal Gabayev
Registrar
Bible Lands Museum Jerusalem

________________________________
From: The Museum System (TMS) Users <[log in to unmask]> on behalf of Chad Petrovay <[log in to unmask]>
Sent: Tuesday, August 27, 2019 10:57:55 PM
To: [log in to unmask] <[log in to unmask]>
Subject: Re: Batch Cataloging/Applying Fields to Selection

Unless you use SQL, you will have to touch each of the existing records. Since Description is a free-text field, you can easily use function keys, to quickly and easily add the text with a single keystroke. This only works for free-field fields.

If the records do not exist, you can create a single shell record with all the commonly shared field values, then copy that record across a range of numbers. Afterwards, you can revisit each record and update the record with unique information.

If you are not planning to create all the records in a single go, you can create a template record that contains the shell information. Then you can create new records, as needed from the template.

Function keys, copying records, and template records are all documented in the TMS help file.

On Tue, Aug 27, 2019 at 2:38 PM Ariel Caruso <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hello,

Does anyone have a trick for cataloging a large batch of objects without doing it in SQL? Specifically, I have a set of 250 pieces of glassware with the same description. The records were already created before we converted to TMS, so now there are 250 individual object records. Is there a faster way to update all of them then copy/paste for the description, dimensions, materials etc.?

What is the best solution for this kind of issue moving forward BEFORE the records have each been created in TMS?

Thanks!

To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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.