Update Media Paths #media #paths #multimediatable

I have recently added a new drive to my pc and wanted a quick way to update the media path file. Whilst there is standard tool within RM5 to fix broken media links, it searches through my entire pc which now has 5TB of data – it picks up files from backup directories and generally takes a long time. I also have the option to update the path directly in the MultimediaTable. Some examples below:

• I want to review the records with a particular path

SELECT * FROM MultimediaTable 
  WHERE Mediapath like ('J:\FAMILY_HISTORY\PAXTON\CERT%');

• I want to update this path to the new path

UPDATE multimediatable 
  SET Mediapath = 'S:\New_Family_History\PAXTON\CERT') 
WHERE mediapath LIKE ('J:\FAMILY_HISTORY\PAXTON\CERT%');

• If i want to replace only some of the path and not the entire string i use the REPLACE function

UPDATE multimediatable
 SET Mediapath = REPLACE (Mediapath, 'J:\FAMILY_HISTORY', 'S:\New_Family_History') 
WHERE mediapath LIKE ('J:\FAMILY_HISTORY\PAXTON\CERT%');

Cheers,

Sean

Discussions & comments from Wikispaces site