TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML 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:
Re: Batch-Change Departments
From:
"Williams, Scott" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 18 May 2015 17:09:33 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2459 bytes) , text/html (8 kB) 
Hi Eddy --

I've got to do something similar this week and the only way I know how is via SQL.  As far as I know Department is not an eligible field in the Find/Replace utility.

-Scott


From: "The Museum System (TMS) Users" on behalf of Eddy Almonte
Reply-To: "The Museum System (TMS) Users"
Date: Monday, May 18, 2015 at 1:00 PM
To: "[log in to unmask]<mailto:[log in to unmask]>"
Subject: Batch-Change Departments

Hey everyone,

Does anyone know of an easy way to move a group of objects records to another department? I have an object package of 250+ records that have to be changed from one department to another, hopefully with no SQL scripts involved.

Thanks!!
Eddy

Eddy Almonte
Assistant Registrar
Colección Patricia Phelps de Cisneros
2 East 78th Street
NYC 10075
T 646.448.8324<tel:212.717.6080>
www.coleccioncisneros.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.coleccioncisneros.org_&d=AwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=zwQPLMCD5_JKy8h0XocgN7IVg2aC-R72JCofhbskx7o&m=prL7HIhcEUcr-780FNi-DE3YFXHV_Psu2ppfbc5QUd0&s=vJ5KIFPQQuYLMHwGrlMmUSMZ0q1rXrQ6p77iq8eR5XA&e=>
www.orinoco.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orinoco.org_&d=AwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=zwQPLMCD5_JKy8h0XocgN7IVg2aC-R72JCofhbskx7o&m=prL7HIhcEUcr-780FNi-DE3YFXHV_Psu2ppfbc5QUd0&s=nghduNtUEHptjpWNGcChbml4AOpUSHe2FbOSYFAAdmM&e=>
conversaciones/conversations<https://urldefense.proofpoint.com/v2/url?u=http-3A__vimeo.com_62726873&d=AwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=zwQPLMCD5_JKy8h0XocgN7IVg2aC-R72JCofhbskx7o&m=prL7HIhcEUcr-780FNi-DE3YFXHV_Psu2ppfbc5QUd0&s=QkChsrpjjiBxEOxAH_R0jQ_zyKwnugIhjZwD4AUGwEg&e=>
find us on facebook<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.facebook.com_cisneroscollection&d=AwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=zwQPLMCD5_JKy8h0XocgN7IVg2aC-R72JCofhbskx7o&m=prL7HIhcEUcr-780FNi-DE3YFXHV_Psu2ppfbc5QUd0&s=FADhaKdGvMHWJxHTWJ_qrwIaBr08P1oIllXMedCGCwo&e=>

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.

ATOM RSS1 RSS2