Update Location of Files in Database 1.3 (2012-06-12) [MM2+]
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
just copied archive from sysem to data drive, updated usign this tool
everything worked perfectly ^^
180Gb more space *Yay*
everything worked perfectly ^^
180Gb more space *Yay*
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
New, and new.damixx wrote: To run the script, should I launch the MM software on the old or new drive?
Should the script be ran on the old or new drive?
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
Thanks again for this very useful script.
Some suggestions for improvement.
1) Update does not refresh the track window, so it leaves it showing the old paths. The script author has explained this is due to MM API limitations http://www.ventismedia.com/mantis/view.php?id=9138. I suggest that until this is fixed, http://www.mediamonkey.com/forum/viewto ... =2&t=63823 "Usage" should have a note giving warning and a workaround (e.g. exit and relaunch).
2) If I select Media Tree, Entire Library, and then run the script, by default the script operates only on the path of the first track in the entire library track list, rather than on the entire library. http://i.imgur.com/CjG1O7G.png . Presumably it is not possible for the script to operate on all paths in the entire library if there are has multiple drives, but nevertheless I suggest it should do so if it can e.g. when there is only one drive. Workaround: if there is one drive, first select the drive: http://i.imgur.com/Ee81RIS.png .
3) Perhaps New Path should accept a bare drive designator http://i.imgur.com/x9Oahr5.png. EDIT: Currently \ is needed.
Some suggestions for improvement.
1) Update does not refresh the track window, so it leaves it showing the old paths. The script author has explained this is due to MM API limitations http://www.ventismedia.com/mantis/view.php?id=9138. I suggest that until this is fixed, http://www.mediamonkey.com/forum/viewto ... =2&t=63823 "Usage" should have a note giving warning and a workaround (e.g. exit and relaunch).
2) If I select Media Tree, Entire Library, and then run the script, by default the script operates only on the path of the first track in the entire library track list, rather than on the entire library. http://i.imgur.com/CjG1O7G.png . Presumably it is not possible for the script to operate on all paths in the entire library if there are has multiple drives, but nevertheless I suggest it should do so if it can e.g. when there is only one drive. Workaround: if there is one drive, first select the drive: http://i.imgur.com/Ee81RIS.png .
3) Perhaps New Path should accept a bare drive designator http://i.imgur.com/x9Oahr5.png. EDIT: Currently \ is needed.
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
As I explained in Mantis, the add-on refreshes the tracklist correctly in MM2 and MM3 and sometimes in MM4. Unfortunately, there are situations in MM4 when that is not possible because of the bug in the program itself introduced in MM4.chrisjj wrote:1) Update does not refresh the track window, so it leaves it showing the old paths.
There is simple logic behind GUI - you select one old path and you select one corresponding new path. I bet that many users would disagree that the script should update all drives in the Library to the single new drive if they have the Entire Library node selected before entering the script.chrisjj wrote:2) If I select Media Tree, Entire Library, and then run the script, by default the script operates only on the path of the first track in the entire library track list, rather than on the entire library.
The "\" on the end of the path is not needed.chrisjj wrote:3) Perhaps New Path should accept a bare drive designator http://i.imgur.com/x9Oahr5.png. Currently / is needed.
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
Which bug? I saw no mention in that Mantis report.ZvezdanD wrote: Unfortunately, there are situations in MM4 when that is not possible because of the bug in the program itself introduced in MM4.
The problem is that I didn't select the old path. The script did. And its selection was entirely arbitrary.ZvezdanD wrote:There is simple logic behind GUI - you select one old path and you select one corresponding new path.
Good then that no-one is suggesting such a thingZvezdanD wrote:I bet that many users would disagree that the script should update all drives in the Library to the single new drive if they have the Entire Library node selected before entering the script.
I find it is. Without it, Update is disabled.chrisjj wrote:The "\" on the end of the path is not needed.
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
Quote: "such solution doesn't work in MM4 always ... MM2 and MM3 didn't have that problem"chrisjj wrote:Which bug? I saw no mention in that Mantis report.
You didn't, but you could - you have the Old Path combo box for that. The automatic selection is not arbitrary, it depends of the selected node in the Tree panel and/or the selected file in the tracklist. I already told you about that: http://www.mediamonkey.com/forum/viewto ... 81#p392481.chrisjj wrote:The problem is that I didn't select the old path. The script did. And its selection was entirely arbitrary.
I just checked and you are right, it is not working without "\" on the end if you have the "only for files that exist" option turned off. Thanks for the report, it will be fixed.chrisjj wrote:I find it is. Without it, Update is disabled.
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
If that is due to a bug, rather than a documented cut-back, then still I'd be interested to hear what is the bug.ZvezdanD wrote:Quote: "such solution doesn't work in MM4 always ... MM2 and MM3 didn't have that problem"chrisjj wrote:Which bug? I saw no mention in that Mantis report.
Agreed. The improvement I am suggesting would obviate the need for that.ZvezdanD wrote:You didn't, but you could - you have the Old Path combo box for that.
The selected file in the tracklist is arbitrary. It is what ever appears at the top of the list when you click Entire Library.ZvezdanD wrote: The automatic selection is not arbitrary, it depends of the selected node in the Tree panel and/or the selected file in the tracklist.
You said (and thank you): "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..."ZvezdanD wrote: I already told you about that: http://www.mediamonkey.com/forum/viewto ... 81#p392481.
and such selection does not help at all when the tracks are in folders within the library root, and is the MM default.
Thanks.ZvezdanD wrote: I just checked and you are right, it is not working without "\" on the end if you have the "only for files that exist" option turned off. Thanks for the report, it will be fixed.
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
If program refuses to display the Properties dialog box for some existing drive, then it is a bug.chrisjj wrote:If that is due to a bug, rather than a documented cut-back, then still I'd be interested to hear what is the bug.
No, it would not. As I said, nobody would agree with such solution which you suggested.chrisjj wrote:The improvement I am suggesting would obviate the need for that.
No, it is not if you follow my instruction: "Select some missing file with the old drive/path in the main tracklist".chrisjj wrote:The selected file in the tracklist is arbitrary.
Sorry, but I really don't know what you want to say.chrisjj wrote:such selection does not help at all when the tracks are in folders within the library root, and is the MM default.
Anyway, I think I will remove option for automatic selection of the old path based on the selected node/selected file and to force users to select such path in the Old path combo box. IIRC, some users already had problem with that option.
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
That's not the issue I reported. The issue I reported is "1) Update does not refresh the track window, so it leaves it showing the old paths."ZvezdanD wrote:If program refuses to display the Properties dialog box for some existing drive, then it is a bug.
You're mistaken there. Read again.ZvezdanD wrote:No, it would not.chrisjj wrote:The improvement I am suggesting would obviate the need for that.
The suggestion you reported didn't come from me. The one that did is clear in this thread.ZvezdanD wrote:As I said, nobody would agree with such solution which you suggested.
You're mistaken. Your script has no effect on which track is selected. And the problem with your suggestion is that there is normally no track with the missing path in the tracklist because, as I said, tracks are normally in subfolders.ZvezdanD wrote:No, it is not if you follow my instruction: "Select some missing file with the old drive/path in the main tracklist".chrisjj wrote:The selected file in the tracklist is arbitrary.
Have a look at the paths for a typical library and you'll see. Theer is none in the root.ZvezdanD wrote:Sorry, but I really don't know what you want to say.chrisjj wrote:such selection does not help at all when the tracks are in folders within the library root, and is the MM default.
Thanks.ZvezdanD wrote:Anyway, I think I will remove option for automatic selection of the old path based on the selected node/selected file and to force users to select such path in the Old path combo box. IIRC, some users already had problem with that option.
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
I understand very well what is the issue that you have reported, but you didn't understand that that issue is a consequence of the bug in MM4: "there are situations in MM4 when that is not possible because of the bug in the program itself introduced in MM4".chrisjj wrote:That's not the issue I reported. The issue I reported is "1) Update does not refresh the track window, so it leaves it showing the old paths."
I read it again and I still think that you are mistaken here. Your suggestion is not an improvement.chrisjj wrote:You're mistaken there. Read again.
I really don't know what you want to say. What suggestion that I reported you are talking about? Yes, your suggestion is clear - you suggested that I modify script to allow update of all drives in the Library if user has the Entire Library node selected and I told you that nobody would want that. Do you want that we start a poll about your suggestion?chrisjj wrote:The suggestion you reported didn't come from me. The one that did is clear in this thread.
Of course that my script has no effect on which track is selected and that is why I told you that it is you who should make that selection.chrisjj wrote:You're mistaken. Your script has no effect on which track is selected.
So what? If you select the root of the drive in the Media Tree that drive would be auto-selected in the Old path combo box. And if it is not auto-selected, you always could make your selection using that combo box.chrisjj wrote:Have a look at the paths for a typical library and you'll see. Theer is none in the root.
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
You're right. I don't understand that this is due to a bug in MM4. That's because you've not IDed the bug you say is the cause. Please do post a link to the Mantis entry IDing this bug.ZvezdanD wrote:I understand very well what is an issue that you have reported, but you didn't understand that that issue is a consequence of the bug in MM4
You're mistaken. That must have been someone else's suggestion. Mine was for one drive. See it here: http://www.mediamonkey.com/forum/viewto ... 45#p396645ZvezdanD wrote:Yes, your suggestion is clear - you suggested that I modify script to allow update of all drives in the Library if user has the Entire Library node selected
So your suggestion "Select some missing file with the old drive/path in the main tracklist" does not work.ZvezdanD wrote:So what?chrisjj wrote:Have a look at the paths for a typical library and you'll see. Theer is none in the root.
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
http://www.ventismedia.com/mantis/view.php?id=9138chrisjj wrote:Please do post a link to the Mantis entry IDing this bug.
Who wrote this: "If I select Media Tree, Entire Library, and then run the script, by default the script operates only on the path of the first track in the entire library track list, rather than on the entire library"?chrisjj wrote:You're mistaken. That must have been someone else's suggestion.
Did you read the whole suggestion of mine, including: "or select missing drive/folder in the Location or My Computer branch of the tree panel"?chrisjj wrote:So your suggestion "Select some missing file with the old drive/path in the main tracklist" does not work.
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
I see "Severity feature" request: "Method to update tree and tracklist after SQL modifications to Medias table needed"ZvezdanD wrote:http://www.ventismedia.com/mantis/view.php?id=9138chrisjj wrote:Please do post a link to the Mantis entry IDing this bug.
No bug.
I did. That's not a suggestion. Read my suggestion and you will see why you are mistaken:ZvezdanD wrote:Who wrote this: "If I select Media Tree, Entire Library, and then run the script, by default the script operates only on the path of the first track in the entire library track list, rather than on the entire library"?chrisjj wrote:You're mistaken. That must have been someone else's suggestion.
"I suggest it should do so if it can e.g. when there is only one drive."
Your second suggestion works. Thanks.ZvezdanD wrote:Did you read the whole suggestion of mine, including: "or select missing drive/folder in the Location or My Computer branch of the tree panel"?
Chris
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
The mentioned request contains description of the bug introduced in MM4.chrisjj wrote:I see "Severity feature" request: "Method to update tree and tracklist after SQL modifications to Medias table needed"
No bug.
You are complaining why the script is applying "only on the path of the first track" "rather than on the entire library". That sounds like suggestion to me.chrisjj wrote:I did. That's not a suggestion.
If you tried my whole suggestion at first place, we would not have this unnecessary discussion.chrisjj wrote:Your second suggestion works. Thanks.
Anyway, here is the algorithm that I could implement for auto-selection of the Old path combo box:
- if the selected file from the tracklist is from missing drive -> that drive and path would be auto-selected;
- if the tree panel is active before opening the script's dialog box and if the selected node contains some missing drive/path -> that drive and path would be auto-selected;
- if the tree panel is active before opening the script's dialog box and if the selected node doesn't contain some missing drive/path, but the selected file in the tracklist is from missing drive -> that drive and path would be auto-selected;
- if none of previous conditions is satisfied then the root of the first missing drive from the Library would be automatically selected;
- if the Library doesn't contain missing drives at all then the drive and path of the selected file would be auto-selected.
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
Re: Update Location of Files in Database 1.3 (2012-06-12) [M
I don't see any mention there of a bug. If you have filed this bug as a Mantis entry, please do show that entry.ZvezdanD wrote:The mentioned request contains description of the bug introduced in MM4.
You're mistaken. I described the current behaviour. That is not a complaint. That is not a suggestion. The suggestion is only "I suggest it should do so [operate on all paths in the entire library] if it can e.g. when there is only one drive"ZvezdanD wrote:You are complaining why the script is applying "only on the path of the first track" "rather than on the entire library". That sounds like suggestion to me.
I did try your whole suggestion. Even before you made it. Your first part did not work on a normal library structure and your second added nothing to the workaround I had already posted: "Workaround: if there is one drive, first select the drive: http://i.imgur.com/Ee81RIS.png".ZvezdanD wrote:If you tried my whole suggestion at first place, we would not have this unnecessary discussion.
My suggested fix would make the workaround unnecessary.
Sounds good. Thanks. It would certainly meet my suggestion #2. Provided:ZvezdanD wrote: Anyway, here is the algorithm that I could implement for auto-selection of the Old path combo box:
- if the selected file from the tracklist is from missing drive -> that drive and path would be auto-selected;
- if the tree panel is active before opening the script's dialog box and if the selected node contains some missing drive/path -> that drive and path would be auto-selected;
- if the tree panel is active before opening the script's dialog box and if the selected node doesn't contain some missing drive/path, but the selected file in the tracklist is from missing drive -> that drive and path would be auto-selected;
- if none of previous conditions is satisfied then the root of the first missing drive from the Library would be automatically selected;
- if the Library doesn't contain missing drives at all then the drive and path of the selected file would be auto-selected.
1) When rule #1 is matched, execution of the rule list doesn't stop. This is because the case of my suggestion #2 (select Entire Library, run script http://i.imgur.com/CjG1O7G.png ) matches rules #1 and #2 and only rule #2 will give the desired outcome.
2) Rule #2 "contains some missing drive/path" means "contains some missing tracks". This is to handle the case where the drive is present but the tracks are missing.
3) Rule #2 uses the shortest leading drive/path spec segment that is common to the tracks meeting the condition. This is to handle the default MM library structure where tracks are in album folders, so that tracks C:\My Music\my first album\artist\title.wma and C:\My Music\my second album\artist\title.wma with give Old Path C:\My Music\.
Chris