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

Kelly,

You can also paste the column of object numbers from Excel into a blank
Word document. Once there, just click somewhere in the set you've pasted,
and choose 'Convert to Text' from the Layout tab.


Then simply do a Search & Replace against the text, replacing ^p with
whatever you'd like between each number (a space, a comma space, etc.). To
Chad's point, if you have spaces or commas within your object numbers, you
can search for ^p and replace with ' ' to wrap all but the first object
number in quotes. Then just copy/paste into an Object Number query in TMS.





Hope that helps!

Ian







On Wed, May 9, 2018 at 9:22 AM, Chad Petrovay <[log in to unmask]> wrote:

> If your object numbers include spaces or commas, then you might want to
> wrap them in quotations.
>
> Remember to use the OR option in Query Assistant (which is usually the
> default)  otherwise your search will fail.
>
> On Wed, May 9, 2018, 9:14 AM Im, Caroline <[log in to unmask]> wrote:
>
>> Just letting you know that if you do want to use textjoin, it’s only
>> available from excel 2016 and higher! I love textjoin, I have a macro
>> specifically for it
>>
>>
>>
>> *From:* The Museum System (TMS) Users <[log in to unmask]> *On
>> Behalf Of *Brad Hubley
>> *Sent:* Tuesday, May 08, 2018 8:22 PM
>> *To:* [log in to unmask]
>> *Subject:* Re: adding object to an object package
>>
>>
>>
>> Hi Rodger;
>>
>>
>>
>> I did this very thing today for the first time with 1,444 object numbers
>> in Excel.  You need to use the textjoin function in Excel to put all of the
>> numbers into one cell with each number separated by a comma.  In my case, I
>> had my object numbers in column A from row 1-1444.  In cell B1 I entered =
>> textjoin(",", True, A1:A1444).  Then I copied the contents of B1 and Pasted
>> Special as Value into cell B2 in Excel.  Then I copied and pasted the
>> contents of B2 into a Query Assistant while searching for Object Number.
>>
>>
>>
>> Let me know if you need more detailed instructions.
>>
>>
>>
>> Brad Hubley
>>
>> Royal Ontario Museum
>>
>> Department of Natural History - Entomology
>>
>> Toronto ON Canada
>>
>>
>> On May 8, 2018, at 6:06 PM, Kelly, Rodger S <[log in to unmask]> wrote:
>>
>> Colleagues,
>>
>>
>>
>> Is there a way to create an object package based on a list of numbers in
>> Excel or Word?  We often have lists of objects we want to move, create new
>> thumbnails for, etc.
>>
>>
>>
>> It would be so helpful if we could paste a list of number into the object
>> package. If this isn’t doable I hope it will be considered for development.
>>
>>
>>
>> Thanks,
>> Rodger
>>
>>
>>
>> *RODGER KELLY*
>>
>> *Deputy Director of Operations  /  TMS (The Museum System) Administrator*
>>
>> National Music Museum
>>
>> University of South Dakota
>> 414 E. Clark St., Vermillion SD 57069
>> <https://maps.google.com/?q=414+E.+Clark+St.,+Vermillion+SD+57069&entry=gmail&source=g>
>> http://nmmusd.org
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__nmmusd.org_&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=jgbbXtz53zbaPWUmbVmB-QsFYiW_YyIzVFhhrvn6iRU&e=>
>>
>> [log in to unmask]
>>
>> (605) 677-5306
>>
>> <image001.png>
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.nmmusd.org_&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=tPnxp7YWXIdPJnsy7zEsPkudRgojbZIg8_d3uKoCPsc&e=>
>>
>> <image002.gif>
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.facebook.com_NationalMusicMuseumUSA&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=5L_3tl1M3qd63Ub3cbsZ2_wJMIkuDtB3xfOvtsGvy-g&e=>
>> <image003.gif>
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_NMMUSD&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=wqq_AJGf1ABvYl3As5j8IsjORhP_3wTYfoXuifLMEcA&e=>
>> <image004.gif>
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.youtube.com_NMMUSD&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=ZXmBlnC_5o5ful1rNZC_u2kpdxvzBWLqeoJFkfNTDkc&e=>
>> <image005.gif>
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.pinterest.com_NMMUSD&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=xDb0doSJSavmp97rtr6Tmo18kuSKYp1hlzx_WpaKxU8&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.
>>
>> *ON NOW*
>> Evidence Room
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.rom.on.ca_evidence&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=YD-zcXOuZWmvLDZc6C6VFDtcAM18JtZ2iQR12CtTGm0&e=>
>>
>> *COMING SOON*
>> 2 June | Iris van Herpen: Transforming Fashion
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=mzgDkb2tDo4-zccojlVZDwIeihoJKoczzfOFPtfYxgk&e=>
>> 2 June | Philip Beesley: Transforming Space
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=mzgDkb2tDo4-zccojlVZDwIeihoJKoczzfOFPtfYxgk&e=>
>> 16 June | Spiders: Fear & Fascination
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.rom.on.ca_en_exhibitions-2Dgalleries_exhibitions_spiders&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=vt7YEvG9_y4aYjMh-j73g1vBwWIBCpe8SyappTJG2to&e=>
>> ------------------------------
>>
>> *À L’AFFICHE*
>> La Chambre des preuves
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__rom.on.ca_fr_chambre-2Ddes-2Dpreuves&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=jrV1hm_xzqr3cvUMPgHGq7SnmX2fWTrmfUojBFMrtz8&e=>
>>
>> *À VENIR*
>> 2 juin | Iris van Herpen : Transformer la mode
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_fr_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=WBx3D1drNFMKM-BXTqvBxNVFdciKPR_OFlaukYdJGVc&e=>
>> 2 juin | Philip Beesley : Transformer l’espace
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_fr_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=WBx3D1drNFMKM-BXTqvBxNVFdciKPR_OFlaukYdJGVc&e=>
>> 16 juin | Les araignées : Peur et fascination
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.rom.on.ca_fr_expositions-2Det-2Dgaleries_expositions_les-2Daraignees-2Dpeur-2Det-2Dfascination&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=gIN2ArBWr0K3fH1JWe2ZHy5APvQ7s8XuLJEsGwlwThY&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.
>> 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.
>



-- 
*Ian Eckert*
Manager, Collection & Exhibition Technologies (CE-Tech)
*The Museum of Modern Art*
11 West 53rd Street  New York, NY 10019

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.