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]> 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






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.
https://si-listserv.si.edu/cgi-bin/wa?A3=2102&L=TMSUSERS&E=quoted-printable&P=2137151&B=--_000_MN2PR13MB292765CF44AFA47D0AFFB0FFB4849MN2PR13MB2927namp_&T=text%2Fhtml;%20charset=Windows-1252&pending=
si-listserv.si.edu
CC-MAIN-2023-40
14955
application/http; msgtype=response
sha1:X7SNMRYDIG2ZURQXKIB5O62XYKI7LQZK
<urn:uuid:cf43594f-aac6-4d9a-a0ed-fb7ccab13270>
2023-09-26T10:09:26Z
160.111.252.11
text/html
sha1:FXBB2K4B3YLGL6LD4EQ4HGBWCIQYWSBG
<urn:uuid:e26b540c-bfb9-475f-a780-1d7e7e479b88>
https://si-listserv.si.edu/cgi-bin/wa?A3=2102&L=TMSUSERS&E=quoted-printable&P=2137151&B=--_000_MN2PR13MB292765CF44AFA47D0AFFB0FFB4849MN2PR13MB2927namp_&T=text%2Fhtml;%20charset=Windows-1252&pending=
response
<urn:uuid:3b001e2d-6bde-4876-8dce-c4f54c27c35e>
isPartOf: CC-MAIN-2023-40
publisher: Common Crawl
description: Wide crawl of the web for September/October 2023
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-18
software: Apache Nutch 1.19 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.5-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: https://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/