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.