Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
The script doesn't throw the error, it's MediaMonkey debugs version build in error messages that pop up. I do assume that the script is causing these error messages (but it always could be something else) as I'm only running the script at the moment they appear.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
How that error message looks exactly? Could you send me your databases to try to reproduce the problem?Lowlander wrote:The script doesn't throw the error, it's MediaMonkey debugs version build in error messages that pop up.
● 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: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
I'm trying to install this, but it gives me a popup saying "product Installation error" and doesn't install.
Edit: I'm on Win7 64bit, and only have the MagicNodes and LastFM scrobbler installed so far.
Edit2: never mind. I had to run mediamonkey as an administrator first, then it installed.
Edit: I'm on Win7 64bit, and only have the MagicNodes and LastFM scrobbler installed so far.
Edit2: never mind. I had to run mediamonkey as an administrator first, then it installed.
-
- Posts: 285
- Joined: Sat Oct 24, 2009 7:58 am
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
Hi. Script sounds great. Would it be possible to use it for something slightly different?
Somehow all my "disc#" field info has disappeared.
Would it be possible to adapt this script to add/merge "disc#" field information from an old DB to the current DB.
I do not want to add any other information.
Cheers
Somehow all my "disc#" field info has disappeared.
Would it be possible to adapt this script to add/merge "disc#" field information from an old DB to the current DB.
I do not want to add any other information.
Cheers
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
Yes, it is possible. I am already thinking to add a possibility for users to choose which field(s) they want to restore beside of the Date Added, but I cannot say when it will be finished. In the meantime, you could try one fast and dirty hack: open c:\Program Files\MediaMonkey\Scripts\RestorePlayHistory.vbs file into Notepad and choose Edit/Replace/Find what: DateAdded, Replace with: DiscNumber, save file and restart MM program. It is recommended to make a backup of the current database before you start this add-on and choose Restore option.richiefinger wrote:Would it be possible to adapt this script to add/merge "disc#" field information from an old DB to the current DB.
However, it is not possible to merge fields from the Songs table (DateAdded or DiscNumber), you could only restore them - all current values entered in that field will be overwritten with backup values if you choose that option. Only Play history and Playlists could be merged (for now, at least). Maybe I could add one more option "Restore field(s) from Songs table only if current value is empty" with the next version...
● 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
-
- Posts: 285
- Joined: Sat Oct 24, 2009 7:58 am
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
Thats great. I'll try that. I only want to restore rather than merge so that's fine.
I'll let you know how it goes.
I'll let you know how it goes.
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
I forgot to mention, this add-on updates only database file, but not tags in audio files. If you want to restore Disc Number in tags as well, you should choose Tools/Advanced Tag Management/Synchronize Tags after the execution of this add-on.richiefinger wrote:I only want to restore rather than merge so that's fine.
● 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
-
- Posts: 285
- Joined: Sat Oct 24, 2009 7:58 am
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
I tried the hacked script.
Some of the disc numbers came back some did not?
Only 75% of the database matched up, so that is probably why.
So I am in a better position than when I started. Thanks:)
I did note that when the disc numbers came back they appeared as 1.0 rather than 1. Not a problem because its easily changed.
I did not use the sync tags as you mention above. I will try this later and see what happens.
Some of the disc numbers came back some did not?
Only 75% of the database matched up, so that is probably why.
So I am in a better position than when I started. Thanks:)
I did note that when the disc numbers came back they appeared as 1.0 rather than 1. Not a problem because its easily changed.
I did not use the sync tags as you mention above. I will try this later and see what happens.
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
Exactly, only matched tracks could be updated. You have changed location and artist/album tags of those 25% tracks after making backup.richiefinger wrote:Some of the disc numbers came back some did not?
Only 75% of the database matched up, so that is probably why.
Yeah, that is because DateAdded is treated as decimal value. Open script file into Notepad again, go to 496 line and write BackupAdded INTEGER instead of BackupAdded REAL. However, If you have some additional string beside of numbers, e.g. if you have tracks from vinyl/cassettes with disc numbers as A1, B1... then you should write BackupAdded TEXT instead.richiefinger wrote:I did note that when the disc numbers came back they appeared as 1.0 rather than 1.
● 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
-
- Posts: 285
- Joined: Sat Oct 24, 2009 7:58 am
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
I used the sync tags command but it didn't gain any extra matches.
Must have done it already with it a restart etc.
Much thanks though for getting back the ones that it did.
Must have done it already with it a restart etc.
Much thanks though for getting back the ones that it did.
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)MM3]
Sorry, but I think that you didn't understand. I didn't say that you would get any extra matches using Synchronize Tags command. I said that this add-on updates only database file, but not tags in audio files. If you open some audio file in another program you would see old value for Disc Number, not restored value from database. You need mentioned command to updates tags in audio files to match those values in database.richiefinger wrote:I used the sync tags command but it didn't gain any extra matches.
You cannot get any additional matches because you changed location (paths) and artist/title tags for those 25% unmatched tracks after you made the last backup. If you want to use this add-on to restore Disc Number for those tracks, the only solution is to revert back location or artist/title/album tags that you changed, but it is pointless because it is easier to enter manually Disc Number for those tracks. My suggestion for the future is to generate checksums for audio files by expanding of Files To Edit / Duplicate Content node before you make a backup - after that this add-on would find matched tracks even if you change location and/or tags.
● 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
-
- Posts: 312
- Joined: Mon Apr 03, 2006 9:11 am
- Location: Denver, CO
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)
ZvezdanD,
Just wanted to reiterate my love for this script. I was recently having huge problems with my database, so i did a fresh install (keeping a recent backup database in a separate folder). This script made my reconstruction so easy and painless! Label me totally impressed. I have a new favorite must-have script with this one!
Cheers!
Just wanted to reiterate my love for this script. I was recently having huge problems with my database, so i did a fresh install (keeping a recent backup database in a separate folder). This script made my reconstruction so easy and painless! Label me totally impressed. I have a new favorite must-have script with this one!
Cheers!
MM Gold since 2006
-
- Posts: 312
- Joined: Mon Apr 03, 2006 9:11 am
- Location: Denver, CO
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)
Hey there, quick question (I hope!).
I'm trying to restore just a few tracks, but I can't seem to get the "Restore data for filtered tracks only" selection to be clickable. It's greyed out. Is there a setting somewhere to enable this?
[EDIT] I figured it out. You actually have to create a Filter. Is there a way instead to just select tracks and restore those? That might be a nice addition to this script.
I'm trying to restore just a few tracks, but I can't seem to get the "Restore data for filtered tracks only" selection to be clickable. It's greyed out. Is there a setting somewhere to enable this?
[EDIT] I figured it out. You actually have to create a Filter. Is there a way instead to just select tracks and restore those? That might be a nice addition to this script.
MM Gold since 2006
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)
Yeah, I already though about that, but nobody asked for it and in general this script is not widely accepted, so I am not sure that I want further to spend my time for something which would be used by one person only. Sorry.martialartsguy wrote:Is there a way instead to just select tracks and restore those? That might be a nice addition to this script.
● 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
-
- Posts: 312
- Joined: Mon Apr 03, 2006 9:11 am
- Location: Denver, CO
Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-11-16)
No worries. Maybe more people will see how cool this script is (especially when resolving database issues) and get behind this!
MM Gold since 2006