Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

B.B
Posts: 15
Joined: Tue Aug 28, 2007 3:59 pm

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by B.B » Wed Aug 26, 2009 8:25 am

Can't get this thing to work.

I read somewhere that MM does the UNC tango better than the mapped drive slow fox, and since my database have been with me since...well..forever..i decided it is time to start over with a fresh DB.

Previously the path to my music where mapped as Z:\ . I renamed the DB and reinstallede MM to get a fresh database, this time i added the tracks from the UNC path (\\192.168.1.99\music\) . Pointing the script to the old database brings this picture up:

Image

Nothing is imported.

Am i missing something?

EDIT...Well..it turns out that i were missing something..

"The requirement is that Path fields <......> are same in the backup and current database files"

Bummer....i guess ill be staying with the old DB..
------
B.B.Lauritzen

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by nynaevelan » Wed Aug 26, 2009 8:51 am

If you still have the old db available, move the files to the new path that you want. Or if you don't, move them to the old file path and then you can move them back when you restore your data. Ever since I created a new db, my MM has been much faster, I guess I had a lot of junk in mine that was slowing it down.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

ZvezdanD
Posts: 3087
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by ZvezdanD » Wed Aug 26, 2009 10:27 am

B.B wrote:EDIT...Well..it turns out that i were missing something..

"The requirement is that Path fields <......> are same in the backup and current database files"
Well, I could add some more criteria for matching tracks, but I suppose it would slow down the execution. For example, I could add the matching for Artist, Title, Album, FileLength, Bitrate, ... and Filename.ext without full path. What do you think about that? Which metadata should be alternately compared if previous fails? By the way, I suggest generating of checksums (Files to Edit / Duplicate Content).
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by nynaevelan » Wed Aug 26, 2009 10:55 am

I would suggest filename.ext after checksum.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

ZvezdanD
Posts: 3087
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by ZvezdanD » Wed Aug 26, 2009 11:19 am

nynaevelan wrote:I would suggest filename.ext after checksum.
Yes, but it is not enough, because there could be many tracks with same filename.ext. It should be a combination of several metadata.
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by nynaevelan » Wed Aug 26, 2009 11:26 am

What combination would make it unique?? For example, I have exact copies of all my tracks in wma, mp3 and m4a. They all have the same bitrate. I supposed file size would work. :-?
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

ZvezdanD
Posts: 3087
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by ZvezdanD » Wed Aug 26, 2009 12:04 pm

nynaevelan wrote:What combination would make it unique??
I don't know, I expected to hear that from you.
nynaevelan wrote:For example, I have exact copies of all my tracks in wma, mp3 and m4a. They all have the same bitrate.
Are you sure about that? Are you using CBR? If you are using VBR it is very unlikely that they have the same bitrate. What is a point of your switch from mp3 collection to the wma or m4a if you keep the same bitrate? Those audio formats have advantage over mp3 because you could get smaller bitrate (and file size) for the same quality.
nynaevelan wrote:I supposed file size would work. :-?
Maybe, but you suggested filesize.ext, not file size. By the way, there is also a possibility to have two different tracks with same file size, so it should be also in combination with some another metadata. Maybe filename.ext and file size.
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by nynaevelan » Wed Aug 26, 2009 12:16 pm

ZvezdanD wrote:
nynaevelan wrote:For example, I have exact copies of all my tracks in wma, mp3 and m4a. They all have the same bitrate.
Are you sure about that? Are you using CBR? If you are using VBR it is very unlikely that they have the same bitrate. What is a point of your switch from mp3 collection to the wma or m4a if you keep the same bitrate? Those audio formats have advantage over mp3 because you could get smaller bitrate (and file size) for the same quality.
It is my intention to switch from mp3 to another format, but I haven't gotten around to testing the sound quality of them yet. And I do not know enough about bitrates and CBR/VBR to use something different yet. To tell you the truth, this isn't high on the priority list, so until I get around to it I am making duplicate copies of all tracks until I am ready for it.
ZvezdanD wrote:
nynaevelan wrote:I supposed file size would work. :-?
Maybe, but you suggested filesize.ext, not file size. By the way, there is also a possibility to have two different tracks with same file size, so it should be also in combination with some another metadata. Maybe filename.ext and file size.
I was thinking filename and filesize, that should be unique enough.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

ZvezdanD
Posts: 3087
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by ZvezdanD » Wed Aug 26, 2009 12:46 pm

nynaevelan wrote:It is my intention to switch from mp3 to another format, but I haven't gotten around to testing the sound quality of them yet. And I do not know enough about bitrates and CBR/VBR to use something different yet.
Yes, I did understand that your intention is to switch from mp3 to another format, but I don't understand why you are doing that if it is not because of audio quality or file sizes. I think you should first decide which audio format and bitrate you want to keep considering its quality, then you could go making duplicates.
nynaevelan wrote:I was thinking filename and filesize, that should be unique enough.
It just comes to my mind that some users make duplicates for different albums (e.g. official and compilations) by simply copying files, so those two criteria (filename and filesize) could not be enough. Maybe in addition of album name and track number.
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Restore Play History/Date Added 1.2 (2009-08-23) [MM3]

Post by nynaevelan » Wed Aug 26, 2009 12:51 pm

Audio quality is not the only factor, the file format also has to be compatible with my portable player, because I am not interested in doing any on-the-fly conversions and my player is based on playlists. So it is still a work in progress....
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

ZvezdanD
Posts: 3087
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore Play History/Date Added 1.3 (2009-08-26) [MM3]

Post by ZvezdanD » Wed Aug 26, 2009 2:59 pm

There is a new update: v1.3 - 2009-08-26
- Added: extra matching test for FileName/FileLength/Album/Year/TrackNumber fields, i.e. track from current database is same with the track from backup database if all those fields are same, even if their paths and checksums are different.
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

B.B
Posts: 15
Joined: Tue Aug 28, 2007 3:59 pm

Re: Restore Play History/Date Added 1.3 (2009-08-26) [MM3]

Post by B.B » Thu Aug 27, 2009 2:28 am

30.000 tracks, 14.31 sec. later everything is restored...I'm impressed


Rock On....

Image
------
B.B.Lauritzen

ZvezdanD
Posts: 3087
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-08-26)MM3]

Post by ZvezdanD » Fri Aug 28, 2009 2:32 pm

There is a new update: v1.4 - 2009-08-28
- Added: option to restore playlists (both auto-playlists and static ones);
- Added: option to merge playlists (if Clear Playlists... option is turned off);
- Added: extra matching test for FileName/SongLength/Artist/Album/Year/TrackNumber fields (useful if audio format of tracks is different between backup and current database).
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-08-26)MM3]

Post by Teknojnky » Fri Aug 28, 2009 2:43 pm

Excellent, I will have to give this a try this weekend after I rescan a new library db.

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Restore PlayHistory/DateAdded/Playlists 1.4 (2009-08-26)MM3]

Post by nynaevelan » Fri Aug 28, 2009 5:05 pm

ZvezdanD wrote:There is a new update: v1.4 - 2009-08-28
- Added: option to restore playlists (both auto-playlists and static ones);
- Added: option to merge playlists (if Clear Playlists... option is turned off);
- Added: extra matching test for FileName/SongLength/Artist/Album/Year/TrackNumber fields (useful if audio format of tracks is different between backup and current database).
Wow, I am going to have to play with this with a new database, you just combined three steps into one. :D :D :D
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Post Reply