Update Location of Files in Database 1.3 (2012-06-12) [MM2+]

[ZvezdanD]

Description:
This add-on could be used with MediaMonkey v2.x or higher. Its purpose is to update serial number of a drive and/or paths of files stored in the database, for example after upgrading hard disk or moving files from/to some network drive with UNC path. This add-on could change the mentioned data stored in the database only, but it could also copy the media files from the old to the new location.

Its main advantages to some another similar scripts are the possibility to update location of files on network drives and the option to specify old and new paths, e.g. if you want to update c:\Documents & Settings\User\Music\ to d:\Music\.

Download:
http://solair.eunet.rs/~zvezdand/Update ... fFiles.htm



What is new:
v1.3.3 - 2012-06-12
* Fixed: display of old UNC paths on some broken/faulty databases.

v1.3.2 - 2012-06-01
* Fixed: update when the old and new paths are same with the same drive letters, but with different drive serial numbers.

v1.3.1 - 2012-02-26
* Fixed: result of searching for existing paths from SynchLocation table.

v1.3 - 2012-02-24
* Added: Copy files from the old to the new location first option;
* Added: update of paths in SynchLocation table;
* Fixed: update of paths in Playlist table;
* Fixed: update of locations when only for existing files option is turned on, the old path is the root of a drive and the old and new drives are the ones with the drive letter (i.e. they are not UNC/URL).

v1.2 - 2012-02-13
* Added: support for mapped network drives;
* Added: support for URL/UPnP old paths (cannot be specified as new paths);
* Added: selection of the new drive/folder in the tree panel after the update;
* Fixed: display of the updated paths in the tracklist;
* Fixed: Update and Cancel buttons could be clicked when searching for existing files if the Update paths only for existing files option is turned off.

v1.1.1 - 2012-02-04
* Fixed: error with MM3 older than 3.1.0.1235.

v1.1 - 2012-01-31
* Added: Update paths only for existing files option;
* Added: support for MM2;
* Fixed: displayed number of existing tracks.

v1.0.1 - 2012-01-25
* Fixed: wrong old paths with missing "\" after drive letter [MM3];
* Fixed: displayed number of existing tracks.

v1.0 - 2012-01-09
* First public version.

Installation:
* For MediaMonkey 3.0 or higher - just double-click on the UpdateLocationOfFiles-xx.mmip file; if you are on Vista or Win7 and you got "Product installation error", make sure you have MM3 set to Run as Administrator"; if you downloaded the installation package with IE7 and it changed its extension to a .zip, you should first change it back to a .mmip.
* For MediaMonkey 2.x - rename a .mmip extension to a .zip, extract the UpdateLocationOfFiles.vbs file to the MediaMonkey's "Scripts" folder and restart MM program.

Usage:
Select some missing file with the old drive/path in the main tracklist or select missing drive/folder in the Location or My Computer branch of the tree panel and choose "Update Location of Files in Database..." from the Tools | Scripts menu, then in the new dialog box select the new path. The old drive/path could be set in the mentioned dialog box as well.

If the Copy files from the old to the new location first option is turned on, then the files would be copied before updating of the database, otherwise only the data about the location of files in the database would be modified. Only the media/playlist files previously stored in the database could be copied. If you have some extra files beside of the media files in their containing folders, e.g. bitmaps with covers or some txt/html files, they would not be copied using the mentioned option; in that case you should use your preferred program for backup to copy files from the old to the new location before you apply this add-on.

If you want to update location only for files which exist at the new specified location you should turn on the Update paths in database only for files that exist at new location option. In that case you should wait for the add-on to finish with search for files before you click on the Update button. However, if you turn that option off, you could click on the Update button immediately after you specify the old and new paths.

Important:
This add-on is relatively dangerous and could cause some corrupted data in the current database, especially if you forcibly terminate the program during its execution! Please make a backup of the current database before you apply this add-on.

[Orbi]

Very interesting! I have used the 'Change drive ID' script in the past, but this one seems more flexible. I will provide more feedback at some point after using it.

Thanks for this!

[CarvedBLock]

Hello,

Thank you for developing such a (potentially) useful script.

Unfortunately, it does not seem to be doing anything for me. I run win7, MM 3.2.5.1306.
My old computer died, but I had a copy of the database file and the music files.

So I copied the database file into the new PS's MM directory, installed the script and ran it.

It all remains gray no matter what I try. It does not produce error, and finishes within fractions of a second.

Any help would be greatly appreciated! I DJ sometimes, and some of the metadata is very valuable to me.

Best!
CarvedBlock

[ZvezdanD]

It all remains gray no matter what I try.

Could you be more specific what have you tried? What have you specified for Old drive/path and New path? Could you write an example of some file with the old and new paths? Have you got the number of the files existing at the new location which is displayed between Backup and Update buttons?

[cyberlarson]

I am trying it now. I, too, am getting a greyed out screen. In task manager, it says it is not responding. I am going to wait to see if it clears up.

[cyberlarson]

I think I solved the problem.

Open MM as Administrator

When you open the script, under "old path", it lists the drive letter only, it should be the drive letter AND the path that MM files are listed. (F:\mediamonkey)

New path should be the new drive and path (L:\mediamonkey)

Before you click on the Update button, the script searches the new location and gives you a status of how many of the files that it found and how many missing. Then you click on update.

The screen shot that you posted is misleading, it shows 0 exists

The screen does grey out, just let it be. Task Manager will show it not responding. I shut down all other programs and the process took about 4-5 minutes to process.

Excellent script!!!! Good work

[ZvezdanD]

Open MM as Administrator

Are you sure that it needs to be opened as Administrator? I cannot try it since I have it in XP, but it should work like any other MM script without such requirement.

When you open the script, under "old path", it lists the drive letter only, it should be the drive letter AND the path that MM files are listed. (F:\mediamonkey)

The Old path is a combo box with a list of all base paths in your database, which means that you could choose any one from it if you click on the arrow button. For example, if I have one track in the database which has the path C:\Music\Pink Floyd\Money.mp3, there would be listed 3 items: C:\, C:\Music\ and C:\Music\Pink Floyd\.

However, I forgot to write that you could also select the old drive/path before you open that dialog box - just select some missing file in the main tracklist which has the old drive/path or select the missing drive/folder in the Location or My Computer branch of the tree panel and when you open the dialog box it would be automatically selected.

I didn't also write that the old and new paths are in fact the base folders. I think that it is obvious, but I will try to explain it further. For example, if I specify C:\Music\, all files which have that as the base path would be updated, like C:\Music\Pink Floyd\Money.mp3, but not files like C:\My Documents\Pink Floyd\Money.mp3 since it has different base folders.

If you specify just x:\ where "x" is some drive letter, that means that you want to update location for all files residing on that drive. So, if you specify the old path x:\ and the new path y:\, this add-on would behave like Change Drive-ID script with only drive-id and/or drive serial number changed.

Before you click on the Update button, the script searches the new location and gives you a status of how many of the files that it found and how many missing. Then you click on update.

You don't need to wait for the add-on to finish with the searches for files, you could click on the Update button immediately after you choose old and new paths. That searching for files is executed in another thread just for checking purpose and would be canceled if you click on the Update button. However, it is recommended to wait for add-on to finish with searching because it would display how many files from the database are found on the new specified location.

The screen shot that you posted is misleading, it shows 0 exists

Why is it misleading? It shows how many files I had existing on the new location, which was 0 since it was not my database, but from some another user.

Task Manager will show it not responding. I shut down all other programs and the process took about 4-5 minutes to process.

The actual update should finish for only few seconds, but searching for files could lasts a little longer indeed. However, as I said, you don't need to wait for add-on to finish searching, just press Update and it would finish much faster.

[cyberlarson]

I certainly didn't mean to insult you. The script worked very well.

I tried it about 4 times, taking notes. The notes are from the last time that worked. I have Win7 Pro.

About the file count prior to clicking on update, The only time it worked properly, was when I waited for the file count to complete and then click Update. The file count was the quickest of all the processes. My library is about 100,000.

The "Run as Admin" comment is based on other scripts that I have installed in MM. For whatever reason, installing scripts in MM seem to work smoothly when I run as admin.

[ZvezdanD]

I certainly didn't mean to insult you.

I tried it about 4 times, taking notes. The notes are from the last time that worked.

About the file count prior to clicking on update, The only time it worked properly, was when I waited for the file count to complete and then click Update.

You didn't insult me. I just wanted to clarify some facts that you mentioned which could mislead other users. If you are sure about them, then that would be bugs of the add-on. Could you upload your database file to some file server like Mediafire packed previously with Zip, so I could try to reproduce those problems by myself?

The "Run as Admin" comment is based on other scripts that I have installed in MM. For whatever reason, installing scripts in MM seem to work smoothly when I run as admin.

The "Run as Admin" requirement is only for installing the add-ons in MM3 (and MM4 if you decide to install the add-on to all users on the computer) as I already mentioned in the Installation section of the first post. The later usage of the scripts, e.g. after the restart of the program, doesn't require such thing.

[swjm]

Hmm, I seem to be having problems as well, unfortunately. No matter what level I select for either side, it simply tells me that all files are missing, and non have been updated.

Right now I have:

Windows 7, MM 3.2.5.1306,

Old Drive: HD:MyBook, ID#######, Not Accessable
Old Path: ?:MusicLibrary\ (I can also select any artist ?:MusicLibrary\MyMusic\Artistshere)
New Path: Where it should be is C:\User\Username\MusicLibrary\MyMusic\Artistshere

Whether I select either side to be at MusicLibrary level or MyMusic level, neither works?

I get a '17002 files, 0 exists, 17002 missing'.

Nothing I do changes the number of missing files...

[ZvezdanD]

Old Path: ?:MusicLibrary\ (I can also select any artist ?:MusicLibrary\MyMusic\Artistshere)

Is it ?:MusicLibrary\ or ?:\MusicLibrary\? You have one missing "\" there. I suppose that your Old path should be ?:\MusicLibrary\MyMusic\ and New path should be C:\User\Username\MusicLibrary\MyMusic\.

OK, here is what you could try:
- find some track in the My Computer branch which is missing from the Library and copy its Path;
- find the same missing track in the Library/Location branch and select it in the main tracklist;
- open the Update Location dialog box and check out if the Old path of that track is correctly displayed;
- paste copied Path excluding the filename and extension in the New path text box (make sure that it ends with "\");
- wait for the add-on to search for file;
- make a screenshot of the dialog box and post it here if you still have displayed 0 existing files.

[swjm]

Old Path: ?:MusicLibrary\ (I can also select any artist ?:MusicLibrary\MyMusic\Artistshere)

Is it ?:MusicLibrary\ or ?:\MusicLibrary\? You have one missing "\" there. I suppose that your Old path should be ?:\MusicLibrary\MyMusic\ and New path should be C:\User\Username\MusicLibrary\MyMusic\.

Hmm. I wonder if that could be the issue? Because as you can see...



.... there is no \ before MusicLibrary in the old path.

and following (I think... It's possible I did something wrong?) your instructions I got this:



Moving either dialogue box up a level or two seemed to make no difference

[swjm]

Also, this may have something to do with the 'no \' issue?

Currently the full old filepath for that exact file is listed as:

'[My Book]\Music Library\My Music\38 Special\_38 Special_ Anthology\.38 Special - Chain Lightnin'.m4p'

Now, it definitely used to say 'G:' instead of [My Book]. I think this may have happened when I originally ran the script, although I'm not at all sure, and could've been cause with my fiddling around with my Terabyte trying to get it not to die.

Basically, I think if that's the issue that this was the cause?

[ZvezdanD]

Is it ?:MusicLibrary\ or ?:\MusicLibrary\? You have one missing "\" there.

Hmm. I wonder if that could be the issue?

Thanks for the report, that was a bug of the add-on in MM3. There is the new release: v1.0.1 - 2012-01-25
* Fixed: wrong old paths with missing "\" after drive letter [MM3];
* Fixed: displayed number of existing tracks.

Please let me know if it is working now as it should.

[swjm]

<_<

I'm really sorry if it turns out I'm blind, but did you update the add-on download somewhere I'm not seeing?

Edit: Aha, thanks!