Logo Home    Page list

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:

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

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


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

Cheers,

Sean

Discussions

ve3meo

Inline comment: "a quick way to update the media path file"

ve3meo 04 September 2018 03:34:47

ve3meo Jan 12, 2012

Good examples of Search, Update and Replace. Also see the page Search & Replace for more examples. Of course, RootsMagic own Search & Replace function on "Multimedia filenames" in the "Field to search" selection does much the same, with the ability to confirm each replace.

www.000webhost.com