Brilliant! It works perfectly. Thanks so much for this information.
Jeffrey Smith
Registrar for Collections Information
O: 202.633.0348
C: 202-340-4896
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Brad Hubley
Sent: Monday, April 24, 2023 11:10 AM
To: ListServ tmsusers <[log in to unmask]>
Subject: Re: Search for string of object numbers
External Email - Exercise Caution
This works for me.
Create your sequence of Object Numbers in Excel in one column, e.g.,
Search for a website that converts a column of numbers to a comma-separated string, e.g.,
https://capitalizemytitle.com/tools/column-to-comma-separated-list/ and paste your Excel column of Object Numbers into it.
In TMS, use Query Assistant to search on Object Number and paste your comma-separated string of Object Numbers (from the website) into it and you should get the results you’re after.
Brad
|
|
Brad Hubley
|
|
ROM acknowledges that this museum sits on the ancestral lands of the Wendat, the Haudenosaunee Confederacy, and the
Anishinaabek Nation, which includes the Mississaugas of the Credit First Nation, since time immemorial to today. |
|
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Sara Smith
Sent: Monday, April 24, 2023 11:00 AM
To: [log in to unmask]
Subject: Re: Search for string of object numbers
[EXTERNAL EMAIL]
DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.
External Email - Exercise Caution
Dear Iris,
Thank you for your suggestion. Yes, I attempted this with no result sadly.
The package is an option but I have several moderately sized groups to update. Alas.
Sara
Sara C. Smith
Director of Collections
The Leiden Collection
t: +1.646.532.2847 m: +1.917.593.2019
w: www.theleidencollection.com
e: [log in to unmask]
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Blochel-Dittrich, Iris
Sent: Saturday, April 22, 2023 14:38
To: [log in to unmask]
Subject: AW: Search for string of object numbers
External Email - Exercise Caution
Hi,
did you try
2009.1.1.1*–*2009.1.1.56
?
Or look for “2009.1.1.” and drag&drop the needed ones into a package… not the best way, but it might work
Arrows is a known bug it is said to be fixed in 9.93
Best, Iris
Iris Blochel-Dittrich
museum documentation
Stiftung Jüdisches Museum Berlin
Lindenstrasse 9-14
10969 - Berlin
Tel. : +49 30 25993-442
Fax. : +49 30 25933-409
**** CURRENT EXHIBITIONS ****
Paris Magnétique. 1905–1940
until 1 May 2023
Jewish Life in Germany: Past and Present
The core exhibition
www.jmberlin.de/en/core-exhibition
**** FOR CHILDREN ****
ANOHA – The Children's World of the Jewish Museum Berlin
Von: The Museum System (TMS) Users <[log in to unmask]>
Im Auftrag von Sara Smith
Gesendet: Freitag, 21. April 2023 21:00
An: [log in to unmask]
Betreff: Search for string of object numbers
External Email - Exercise Caution
Hello!
I’m having great difficulty trying to search for a string of records using object numbers:
2009.1.1.1 – 2009.1.1.56
Just need those, I cannot figure out how to get it to work with the advanced query or in the quick find, ultimately for a batch update.
2009.1.1.1*2009.1.1.56
“2009.1.1.1”*”2009.1.1.56”
Also my arrow keys don’t work in the quick find field. Anyone else experiencing that?
Please help.
Sara
Sara C. Smith
Director of Collections
The Leiden Collection
t: +1.646.532.2847 m: +1.917.593.2019
w: www.theleidencollection.com
e: [log in to unmask]
Unless expressly stated otherwise, this message is confidential and may be privileged or otherwise protected from disclosure. It is intended for the addressee(s) only.
Access to this e-mail by any other person is unauthorized. If you are not an addressee, any disclosure, dissemination, distribution or copying of the contents of this e-mail or the information herein or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee or have received this e-mail in error, please immediately inform the sender, delete this message from all mailboxes, empty this e-mail from your trash, and destroy all copies.
This communication is for informational purposes only. It is not intended as an offer or commitment for any transaction, except as otherwise expressly stated herein. All business terms and conditions, data and other information are not warranted as to completeness
or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of The Electrum Group, LLC, its affiliates, principals or related persons.
Tigris Group Inc. (“Tigris”) is a family office and is not a registered investment adviser. Tigris does not provide investment advisory services to the public. Any investment advisory services will be provided by The Electrum Group LLC, a registered investment
adviser.
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.
Unless expressly stated otherwise, this message is confidential and may be privileged or otherwise protected from disclosure. It is intended for the addressee(s) only.
Access to this e-mail by any other person is unauthorized. If you are not an addressee, any disclosure, dissemination, distribution or copying of the contents of this e-mail or the information herein or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee or have received this e-mail in error, please immediately inform the sender, delete this message from all mailboxes, empty this e-mail from your trash, and destroy all copies.
This communication is for informational purposes only. It is not intended as an offer or commitment for any transaction, except as otherwise expressly stated herein. All business terms and conditions, data and other information are not warranted as to completeness
or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of The Electrum Group, LLC, its affiliates, principals or related persons.
Tigris Group Inc. (“Tigris”) is a family office and is not a registered investment adviser. Tigris does not provide investment advisory services to the public. Any investment advisory services will be provided by The Electrum Group LLC, a registered investment
adviser.
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.
On now at ROM,
T. rex: The Ultimate Predator explores the mighty T. rex – from Baby to Beast. Book tickets at
rom.ca.
À l'affiche du ROM,
T. Rex : Le prédateur suprême. Une exposition qui vous fera découvrir le tyrannosaure... du tout-petit au colosse. Réservez vos billets sur
rom.ca/fr.
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.