External Email - Exercise Caution
Thanks to all so far for your suggestions on bulk renaming software.  If I use this software to rename the files on our own server, would I have to do it again in TMS or reimport those images with the correct filenames?

For TMS, I know very little SQL so how much time would it take update the MediaFiles table?  Are there further steps after that is done?

Thanks!

Amanda

________________________________
From: The Museum System (TMS) Users <[log in to unmask]> on behalf of Jonathan Benoit <[log in to unmask]>
Sent: Friday, February 19, 2021 11:04 AM
To: [log in to unmask] <[log in to unmask]>
Subject: Re: Bulk renaming image digital files


External Email - Exercise Caution

Hi Amanda,

There are two parts to this

  1.  Renaming the files
     *   There is software out there that you can use to rename files.
     *   Alternatively, use a programming language like python.
  2.  Updating the MediaFiles table in TMS.
     *   This can be tricky because you need to avoid replacing the extension period separator (ie. '.jpg')
     *   This is done using SQL.

I can help you with this if needed.

Jonathan




On Fri, Feb 19, 2021 at 6:53 AM Amanda Shields <[log in to unmask]<mailto:[log in to unmask]>> wrote:

External Email - Exercise Caution

Hi all,

Our institution has included our object ID as the filename for many years including the punctuation_2018.4.jpg etc.  As we are starting to institute digital preservation policies and procedures, it was recommended to remove periods and add in an underscore and only have periods as part of the file extension.  This would mean renaming the thousands of files on our servers and files in TMS.  Has anyone performed a similar update or have any other recommendations?

Thanks,

Amanda


Amanda Shields

Associate Registrar







BRANDYWINE

RIVER MUSEUM

OF ART



P.O. Box 141

Chadds Ford, PA 19317



610.388.8134

Brandywine.org<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.brandywine.org%2F&amp;data=04%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C3368ff63a9dc4aca8c6508d8d514b686%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637493632220404803%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=7jkgwfdwph6s7Kx%2Fs7%2BR3myxbW%2FC8aNopRbNkDYPY%2B8%3D&amp;reserved=0>


[X]


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.