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

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

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

by ZvezdanD » Fri Nov 22, 2019 7:20 am

There is a new very important update of this add-on v3.1.8 that has fixed a serious bug:
* Fixed: error on export/import playlists to/from MM4.1+ databases when the option Clear Playlists & PlaylistSongs tables first is turned off.

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

by ZvezdanD » Sun Jul 16, 2017 2:04 am

Mekare wrote:I receive the following error messages when trying to run this script
Thanks for the report and sorry for the late replay, but I got the e-mail notification about your post just now. There is available the new fixed version of the add-on.

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

by Mekare » Sun Jun 18, 2017 10:51 am

Good morning,

I receive the following error messages when trying to run this script (after selecting my backup database, and it states that all 2,121 tracks match). The second error comes up after I hit OK on the first error. My version of MediaMonkey is 4.1.16.8136. I cleared my database first and reimported all the tracks. They play fine (nothing grayed out). Path names are the same, since the files were not moved. I left the default options checked. After I hit okay on the second error, nothing noticeable happens. No data is restored, and according to Task Manager, Media Monkey is using 0% CPU. I'm using the latest free version of this add-on.

https://www.dropbox.com/s/8ol8usbc0gmna ... 1.png?dl=0
https://www.dropbox.com/s/zuyrhvz2vc9f9 ... 2.png?dl=0

As I test, I copied my database from before I cleared it, and put that back in the Roaming folder and started up Media Monkey, and everything was normal - all tracks were available and all play data was there. So I know that there is valid play data for the add-on to restore.

The reason I'm trying to re-create my database is because I bought an SSD for my C: Drive and then had to reformat the drive with my music on it, in order to recover the space from the partition that was my C: Drive. And now if i hit the Add/Rescan tracks, it re-finds all my music, adds duplicates of every one, and then over the course of a few minutes somehow determines that they're duplicates and removes them all. But this never used to happen before I formatted, so I thought starting my database over would be a good idea. I even tried using a database from before I formatted (which had less music, but the add-on did match the 2079 files), and that database also didn't work with this add-on. So I'm not sure if the add-on is the problem, or my database.

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

by ZvezdanD » Thu Dec 22, 2016 4:49 pm

Image
There is a new donation-only version v4.0:
* Added: option Add unmatched files which allows import/export of database records about files that are missing in the current/backup database;
* Added: option Only if physically exist that determines which records of unmatched files will be imported/exported;
* Added: option Copy media files which allows to physically copy unmatched files from/to the specified Backup/Current location;
* Added: option Overwrite files that determines if files with the same names will be overwritten in the target location when copying media files;
* Added: option Restore data only for - Unmatched files that is enabled if Add unmatched files option is turned on, so the data in matched files will not be restored;
* Added: Matched criteria combo box that allows choosing of criteria that was available in the previous versions only through the manual edit of MediaMonkey.ini file using the ExtraMatchTests key;
* Added: criterion only corresponding files at specified locations to match files between backup and current database;
* Added: Backup/Current location of files text boxes which could be used to specify source and destination base folders if they are different;
* Renamed: option Clear Played table & Playcount/LastTimePlayed fields first to Clear existing playhist. of matched files first;
* Added: option Use Played table to get Play counter which determines how the Play Counter field will be calculated when restoring play history;
* Renamed: option Clear Playlists & PlaylistSongs tables first to Clear all pls. first;
* Added: option Replace equiv. pls. that should be set if you want to replace playlists with the same names (within the same parent playlist) when restoring playlists;
* Added: option Only on last level that should be set if you want to replace playlists with the same names only if they are on the last (rightmost) level of playlists, i.e. they don't have child playlists;
* Renamed: option Clear Filters table first (also Views & NodeViews for MM4 db) to Clear related tables first;
* Added: option Replace equivalent collections with the same names that should be set if you want to replace collections with the same names;
* Added: combo box All which could be used to tick on/off all check boxes for metadata (Title, Artist, ...);
* Added: button with combo box which allow showing/selecting of matched/unmatched files in the main filelist;
* Changed: dialog box that is now resizable;
* Improved: speed of many SQL operations;
* Improved: restoring data of duplicate source files combining their playing history into the target files.

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

by willyvds » Sun Nov 20, 2016 3:04 pm

I have uninstalled MM completely (keeping of course DB and INI), and reinstalled it from scratch. All is fine now, and also your add-on works as expected.
Thanks for you advise!
Regards, Willy

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

by ZvezdanD » Sun Nov 13, 2016 4:32 pm

willyvds wrote:I have a lot of addons. They are all installed by admin for all users.
I was specific, I am interested only in type 0 scripts that could be found in the Tools / Scripts menu. Could you name at least one that you are using which is not included with the program? Could you post the content of the Scripts.ini file from your Scripts sub-folder of the program?
willyvds wrote:What I mean is that when I run MM as admin, MM doesn't show my music in the normal way. All songs are listed in a grey color (normal is black).
This is not normal behavior and I think that you have some serious problem with your configuration beside of this add-on. Greyed/inaccessible state of the tracks should not be different when you run the program as admin.

Are you sure that you are starting the same instance of the program when run as admin? Are you sure that you are opening the program with the same database when run as admin?

Here is one short script which could tell you the location of the active database during startup, just save that code to the Test.vbs file and put it in the Scripts\Auto sub-folder of the program:

Code: Select all

Sub OnStartUp()
    SDB.MessageBox SDB.Database.Path, mtInformation, Array(mbOK)
End Sub

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

by willyvds » Sun Nov 13, 2016 3:14 pm

I have a lot of addons. They are all installed by admin for all users.
What I mean is that when I run MM as admin, MM doesn't show my music in the normal way. All songs are listed in a grey color (normal is black). It means you cannot play the song.
This usually happens when the drive is not accessable. I don't know why this happens too when I run MM as admin.

Well anyway, this is what I did. I installed MM on an old laptop, with your add-on, I also copied the corrupt database as well as the most recent backup correct DB to that laptop. The music is on a network drive so that works fine.
I then ran MM as admin starting with the backup DB and imported all playhistory and playlists from the corrupt (but more recent) DB. And it worked!
Somehow the MM DB got corrupted but your add-on can still read it. This is what I hoped!

I still don't understand why it doesn't work on my normal PC. If I have a bit of time I may dive into that. For the moment, I am over the moon!
Thanks for looking into this, and for your marvelous add-on!
Regards, Willy

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

by ZvezdanD » Sun Nov 13, 2016 3:21 am

Do you have only this add-on in the Scripts menu installed as admin for all users?
Is the same problem happening when you install it "for the current user only"?
What do you mean by "all my music is grayed out"? What has that with this add-on?
Could you get it to work when started as admin at least?
Could you install the another instance of MM program in portable mode and install this add-on to it just to see if the same happens?

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

by willyvds » Sat Nov 12, 2016 8:08 pm

Only with this add-on. I don't see it at all in the scripts menu as normal user. By the way: it is in the overview of extensions, and I can look for an update. When I run mm as admin, the add-on is in the menu, as it should. But all my music is grayed out.
I think I have the problem for quite some time, but first I thought it was my mistake. But now I really need the add on because my database is corrupt. And now I notice that I cannot get it to work anymore.

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

by ZvezdanD » Sat Nov 12, 2016 6:42 pm

willyvds wrote:when I run MM as normal user - I simply don't see the add-on.
Do you have that problem only with this add-on?
Do you see its item in the Scripts menu when run as normal user?
Do you see it at all when run as admin?

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

by willyvds » Sat Nov 12, 2016 6:01 pm

I have a question. I have used this add-on many times but now it doesn't work anymore.
First, I simply did not see the add-on. I only saw it when I ran MM as admin.
So I uninstlled the add-on and installed it again (as admin) making sure it was installed for all users.
But still, when I run MM as normal user - I simply don't see the add-on.

As I said, this has worked in the past for many years. What am I doing wrong???
Thanks for your attention.

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

by ZvezdanD » Thu May 05, 2016 6:03 am

Yes, of course. The mentioned metadata include title, artist, album etc. Please read the first message of this thread and you will see what data you could import/export.

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

by StephenSmith » Thu May 05, 2016 4:58 am

Thanks for that, when you say their data do you mean, title, artist, album etc

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

by ZvezdanD » Wed May 04, 2016 2:34 pm

StephenSmith wrote:Am I right in thinking that this will merge two DB's into one. The reason I am asking is that my main DB is on my laptop at my place of work, but there are times that I have time at home to add some newer files and what I would like to do is then take the home DB and merge it into my main DB.
http://www.mediamonkey.com/forum/viewto ... 58#p413758
"This add-on currently cannot import tracks from the backup into the active database, but only their data (metadata, playlists, playing history...)."

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

by StephenSmith » Wed May 04, 2016 11:14 am

Hiya

Am I right in thinking that this will merge two DB's into one. The reason I am asking is that my main DB is on my laptop at my place of work, but there are times that I have time at home to add some newer files and what I would like to do is then take the home DB and merge it into my main DB.

If so what settings would I need to do that please

Thanks in advance

Steve

Top