Hi Jessica and Christina,

You might consider making this script a stored procedure and create a job so that it runs automatically. This would prevent you from having to re-run the script every time you use the media loader and save you a little time.

There are a couple of fields in media that we wanted to be able to update in batch but they were excluded from the Media Loader tool (example: MediaStatusId). As a workaround, we repurposed a field used in the tool that we don't use in TMS (ArchSubDir) and wrote a script to update the field we wanted with the imported data.

This is very unique to how we use media at PAM, but you get the idea.

CREATE PROCEDURE [dbo].[UpdateMediaStatusToImageType]
      -- Add the parameters for the stored procedure here
AS

Update [TMS].[dbo].[vListViewMediaPAM3]
  Set MediaStatusID = 1
  where ArchSubDir = 'Professional collection photography'
  and MediaStatusID = 0

Best,
Laura

Laura Wenzel
Associate Registrar
Direct:  602.307.2063
Email: [log in to unmask]<mailto:[log in to unmask]>

Phoenix Art Museum
1625 N. Central Avenue
Phoenix, AZ 85004

phxart.org<http://www.phxart.org/>


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Milby, Jessica
Sent: Wednesday, April 22, 2015 1:31 PM
To: [log in to unmask]
Subject: Re: Media Loader File Names and Unwanted Backslashes

We have the problem too.  Brian from GS gave me a script to run on the server to fix it.  You basically have to run it every time you create renditions using the Media Loader, so it's not a long term solution.  I can't find the email, but I think I remember his saying that it's a bug that has been fixed for the TMS2014 version (here's hoping!).
--Jessica


/*-----------find \\s<file:///\\s> from media loader TMS 2012SP2------------------*/
Select * from MediaFiles where  FileName like '\%.%'

/*------------fix \\s<file:///\\s> from media loader TMS 2012SP2------------------*/
Update MediaFiles
Set FileName = right(FileName, (LEN(FileName)-1))
Where FileName like '\%.%'
And LoginID = 'MediaLoader'
GO


Jessica Milby
Assistant Director for Collection Information

t 215-684-7283
f 215-235-0035

Philadelphia Museum of Art
PO Box 7646
Philadelphia, PA 19101-7646
www.philamuseum.org<http://www.philamuseum.org>


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christina Gibbs
Sent: Wednesday, April 22, 2015 3:36 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Media Loader File Names and Unwanted Backslashes

Dear List Serve,

Media Loader is apparently inserting a backslash on the front of our filenames, e.g. \filename.jpg. Did anyone else have this issue and have found a solution? We are on TMS 2012. Our file paths also end with back slashes. I tested uploading to a path without a slash at the end and receive the same undesired results. Everything else is in working order, including thumbnailer and retrieving images. So it's not an issue until we export file names and have inconsistent extra characters.

Thank you,
Christina

Christina Gibbs
Collections Database Manager

[Black Small Medallion]
5200 Woodward Avenue│Detroit, MI  48202
313.578.1051 │ [log in to unmask]<mailto:[log in to unmask]>

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.