LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

That was an important set of data when we converted to TMS, and the thing that pulls all of those records together is that the location was created on the date that the conversion was run. In order to find them, I do an Advanced Query for Current Location with Transaction Date = the date the conversion was run. You can see when the record was created in the Record Info area. (We are still on TMS 2012.) Here is a screenshot:

I hope this is helpful. --Suzanne

Suzanne Voce Stephens

Senior Associate Registrar

TMS Database Administrator

Birmingham Museum of Art

2000 Rev. Abraham Woods Jr. Blvd.

Birmingham, Alabama 35203

Phone 205.254.2975

Fax 205.323.6093

On Mon, Sep 17, 2018 at 1:12 PM Mathieu, Marie Élaine <[log in to unmask]> wrote:

Dear TMS users,

When we migrated our data to TMS, some of our objects had no location and in TMS the Home Location field remained empty. We would like to search for these records.

[log in to unmask]">
[log in to unmask]" alt="/cgi-bin/wa?A3=1809&L=TMSUSERS&E=base64&P=604828&B=--000000000000dc923705761563e4&T=image%2Fpng;%20name=%22google_map_f4767b68-e35b-45ec-b794-31247a1ff7b6.png%22&[log in to unmask]">
I tried many requests with the Advanced Query assistant, but I must do something wrong since the result is always incorrect. And it seems we cannot search empty records with the Query Assistant.

Any ideas? Maybe with a SQL request?

Thank you,

Marie-Élaine

Marie-Élaine Mathieu - T. 418 643-2158, poste 825
Bibliotechnicienne
Direction des collections
MUSÉE DE LA CIVILISATION
9, rue de la Vieille-Université, Québec (QC) G1R 5K1 Canada

mcq.org

Avis : Ce message est confidentiel et ne s’adresse qu’aux destinataires. Si vous le recevez par erreur, veuillez le supprimer et nous en aviser.
Politique de confidentialité | Se désabonner | Inscription à l'INFO-MUSÉE

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.