Merging MM 2.5.5 and MM 3.0 Beta data

Big_Berny · Post by **Big_Berny** » Tue Sep 04, 2007 8:15 am

Hi,
I have done a script for MM 2.5.5 which exports Playcounter, DateAdded and Lastplayed into the customfields (1-3) and a script which imports the the data from the customfields back into the database of MM 3.0.

EDIT: I forgot to say that the idea is, that the data gets merged and not just overwritten! This is useful for people like me who used MM 2.5.5 and 3.0 together.

Someone interested?
Big_Berny

kemie · Post by **kemie** » Wed Sep 05, 2007 2:44 am

definitely interested!

Big_Berny · Post by **Big_Berny** » Wed Sep 05, 2007 4:47 am

Ok, here they are:
http://www.berneker.ch/Merge255and30.zip

How to use it:
1. Extract Export255.vbs into the script folder of MM 2.5.5 and add folowing lines to the scripts.ini-file:

Code: Select all

[Export255] 
FileName=Export255.vbs 
ProcName=Export255
Order=1
DisplayName=Export255
Description=Export255
Language=VBScript 
ScriptType=0

2. Start MM 2.5.5, select all your songs you want to merge (normally all) and create a playlist by clicking on "File/Export to playlist" and then run the script by clicking on Tools/Scripts/Export255. This process may take a while as you can see on the progressbar. (NOTE: The Customfields 1-3 will get overwritten!). When it's finished close MM 2.5.5.
3. Extract Merge30.vbs into the script folder of MM 3.0 and add folowing lines to the scripts.ini-file:

Code: Select all

[Merge30] 
FileName=Merge30.vbs 
ProcName=Merge30
Order=1
DisplayName=Merge30
Description=Merge30
Language=VBScript 
ScriptType=0

4. Start MM 3.0 Beta and rescan all your songs. This way MM 3.0 will recognize the new data in the customfields.
5. Open the Playlist you have created before, select all songs inside it and run Tools/Scripts/Merge30. The informations will now get merged which also can take a while.
6. Done!

Hope it works!

Big_Berny

nynaevelan · Post by **nynaevelan** » Wed Sep 05, 2007 7:53 am

Hi Berny:

I gave your script a run and I am having one problem. When the merge is completed for those songs that do not have a last played date, the script is not updating the field from the 2.5 database. Should this be updating the field?? Also, for the added date, is the earlier date the one the script is using as the correct field to put in the Added field?

Nyn

Big_Berny · Post by **Big_Berny** » Wed Sep 05, 2007 10:14 am

Hi nynaevelan,
sorry I don't understand you correcty.

I understood it like this:
Song A has never been played in MM 3.0 but in MM 2.5.5. In this case it will import the LastPlayed-date of MM 2.5.5. Right? This works here...
If Song A has been played in MM 3.0 but never in MM 2.5.5 the data of MM 2.5.5 should not be imported. This works here too.

Right?

Summary: For the DateAdded the script should automatically choose the older date but for LastPlayed it should automatically choose the newer date.

Is there a problem?

nynaevelan · Post by **nynaevelan** » Wed Sep 05, 2007 11:27 am

Bernie:

My LastPlayed is not getting updated. It was never played in MM3 so it should be updating the info from 2.5 but it is not.

Nyn

Big_Berny · Post by **Big_Berny** » Wed Sep 05, 2007 11:33 am

Could you send me the information which is in the custom-fields, please? And if possible also the informations which are in MM 3.0 (DateAdded).

Thx, I'll have a look!

nynaevelan · Post by **nynaevelan** » Wed Sep 05, 2007 11:39 am

Bernie:

Sorry I do not know how to post an image on the page.

Nyn[/img]

Big_Berny · Post by **Big_Berny** » Wed Sep 05, 2007 5:18 pm

Try http://imageshack.us/ or post just the text.

Regards
Big_Berny

nynaevelan · Post by **nynaevelan** » Thu Sep 06, 2007 5:02 am

Hi Bernie:

Here is the link to the images, http://img171.imageshack.us/my.php?imag ... oreoe4.jpg.

Nyn

Big_Berny · Post by **Big_Berny** » Thu Sep 06, 2007 5:23 pm

Sorry, the image is much too small! Have you selected "resize" on imageshack?

A possible problem could be that you don't have the same date-format. My script needs dd/mm/yyyy. Maybe this problem can be fixed...

nynaevelan · Post by **nynaevelan** » Thu Sep 06, 2007 5:54 pm

Hi Bernie:

I tried posting again but the image is still small, so I will just tell you what I have and what happens:

Before Merge

Played = 0
Custom 1 = 8
Last Played = blank
Custom 2 = 6/23/2007 1:19:48 PM
Date Added = Today 5:15 AM
Custom 3 = 7/31/2007 7:04:40 PM

After Merge

Played = 8
Custom 1 = 0
Last Played = blank
Custom 2 = 6/23/2007 1:19:48 PM
Date Added = Today 5:15 AM
Custom 3 = 7/31/2007 7:04:40 PM

BTW, I did not change the dates anywhere but the dates are in the same format in all the relevant fields as dd/mm/yyyy.

Nyn

Big_Berny · Post by **Big_Berny** » Thu Sep 06, 2007 6:37 pm

Thx a lot!
I think I have the problem. The first is that LastPlayed is empty and the second is "Today" instead of the date.

I'll have a look! But I don't know when yet because I'min holidays right now.

Big_Berny

nynaevelan · Post by **nynaevelan** » Thu Sep 06, 2007 7:12 pm

Bernie:

There is no rush to get this done, the most important field, PlayCount, is being updated, so anything you do will be helpful. Enjoy your holiday.

Nyn

Big_Berny · Post by **Big_Berny** » Thu Sep 20, 2007 6:32 pm

Hi,
I'm just workin on a new version which solves your problem.
Can you send me the Custom2 of a Song which you never played in MM 2.0? I need to know what MediaMonkey stores in this case. In my MM it stores "00:00:00" but probably it's not the same on your american system.

Thanks!
Big_Berny