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

 

 

 

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 from media loader TMS 2012SP2------------------*/

Select * from MediaFiles where  FileName like '\%.%'

 

/*------------fix \\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

 

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

 

 

5200 Woodward Avenue│Detroit, MI  48202

313.578.1051 │ [log in to unmask]

 

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.