MediaMonkey iTunes plugin (d_itunes4.dll)

[treponem]

Nope, not here. I had to set Win to US to get beyond the validDate error. After changing "Library" to "Mediathek" in registry, one-way sync from MM to itunes worked but no files were updated, they were added everytime; no playlists synced.
So I set itunes to US (Mediathek->Library...) and the plugin worked without errors. I set MM also to US just to be sure.

[markstuartwalker]

Nope, not here. I had to set Win to US to get beyond the validDate error. After changing "Library" to "Mediathek" in registry, one-way sync from MM to itunes worked but no files were updated, they were added everytime; no playlists synced.
So I set itunes to US (Mediathek->Library...) and the plugin worked without errors. I set MM also to US just to be sure.

OK, I've eliminated the occurrences of hardcoded 'Music' and 'Library'. Further, the names for these are derived programatically so internationalisation should work. Please delete the 'Library' register entry before running MM to collect the correct value.

All in the new version.

8/3/2010
* Changed registry location from '\Software\Songs-DB\Device\iTunes\' to '\Software\MediaMonkey\Device\iTunes\';
* Used QuotedStr(MMInterf.Localize(floatToStr(double(diff)))) to solve internationalization issues
* UI addded for setAllPlaylistsToShuffle
* Lyrics shown in track browser window
* Indirect ID3tag changing updates iTunes sympathetically (title, artist, gentre etc)
* DateUploaded made DateTime (was just Date, whoops!)
9/3/2010
* Improved reading and error trapping on ID3tag refreshing
* Additional message for the first uploaded track with debug=0
* 'Music' and 'Library' usage automated to the first source and first playlist.

[markstuartwalker]

9/3/2010
* Improved reading and error trapping on ID3tag refreshing
* Additional debug message for every 1000th uploaded track with debug=0
* 'Music' and 'Library' usage automated to the first source and first playlist.
10/3/2010
* Now possible to have no '<MM>' folder so playlists are created in the root of iTunes
* Differences of composer lists handled correctly (MM='; ' and iTunes='/')
11/3/2010
* iTunes Tree browser uses source names in place of hard coded 'Library'
* 'Playlists' node moved below 'Library'

[markstuartwalker]

Everything seems to have gonbe quiet on this. I know that there have been 13 downloads of the 11/3/2010 update. Are they all working fine in your scenarios? I'm hoping that this is the case

Mark

[treponem]

Thanks, everything's working great here. The Validdate bug still persists, but I set to US for syncing.
I only have big problems with my ipod now, I think the multiple genres result in over 14.000 single genres on the ipod so that it doesn't boot up any more... Else it's broken

[Shinken]

I used the 11/3/2010 update and things appear to be working correctly for me. Ratings, play count info, and flac files are being transcoded into mp3 files. Just haven't had time to dig deeper into it see if anything is not working correctly.

Thank you for all the work in putting this plug-in together.

[nynaevelan]

I too have not gone any deeper because I only need the playcounts transferred. But I do get each version.

[markstuartwalker]

Thanks, everything's working great here. The Validdate bug still persists, but I set to US for syncing.
I only have big problems with my ipod now, I think the multiple genres result in over 14.000 single genres on the ipod so that it doesn't boot up any more... Else it's broken

The validdate report might be caused by a bad date being persisted into the database SONGS or DEVICETRACKS tables while working in the 'wrong' region or using a release with the bug in it. Try and identify the track in question and it's ID (12345 in examples below) and use

select * from devicetracks where ID=12345
select * from songs where ID=12345

To look at the data in raw format and confirm the corruption.

Unless you want to craft some SQL to do some DB surgery the easiest solution is to delete the track from the database and then add it back into MM. This will lose playcount histories, ratings etc. so be sure you're OK with this.

Mark

Later edit ....

After a little investigation I can confirm that the corruption will be in the SONGS table in the LASTTIMEPLAYED or (less likely) FILEMODIFIED columns. If you use MM to view all tracks and sort by last played you'll probably find some with extreme dates e.g. in the 1800's. They're the culprits.

By playing the track(s) in question, MM will update the LASTTIMEPLAYED according to the current locale. Problem solved!

[markstuartwalker]

New version.

Quite alot has happened internally in preparation for updating the iTunes databases on other machines rather than just the one on the local machine. Each machine will appear as a separate MM device (like having lots of USB sticks), each device having it's own configuration and synchronise lists. None of this is complete yet but it has been proven to work.

'doNotCreatePlaylistsFor' is to allow the tracks from a playlist to be synchronised but NOT to create the playlist itself. This may seem odd but I have a practice of creating playlists to build a large bulk of files which are then accessed through random playing hence the playlist itself is never played so why waste the CPU time creating and maintaining it? The parameter is a unix -style regular expression e.g. Fred*|Harry* which would match any playlist beginning Fred or Harry.

14/3/2010
* remoteName added to see how difficult to update iTunes on a remote machine
15/3/2010
* iTunes is launched and closed if configured to start automatically
* Exceptions trapped around COM accesses to make more robust
16/3/2010
* Additional 'break' after updating track ID3 information correctly
* Composer lists checked and corrected one more time
* DeviceStartEx() adopted to make a selection of devices (caption='iTunes <remoteName>')
* Configuration sheets made dependent of the device selected
* DeviceList added in preparation for multiple iTunes databases
* Config re-read at the start of each synch
* Additional validation on MMvalidDate(Iter.ValueByName['UPLOADTIME'])
17/3/2010
* doNotCreatePlaylistsFor so that certain playlists are not created e.g. Fred*|Harry*

Enjoy!
Mark

[gvala]

Congratulations Mark for this awesome plugin.
Unfortunately I have a small problem and a big one that makes the plugin useless for me.
First of all I would like to mention that I use the plugin in two different configurations, one at the office (as a test environment) and one at home.
At the office I run WinXP and the latest iTunes and at home Windows 7 x64 and the latest iTunes. At both environments I installed the latest plugin version with the same settings.
The small problem appears in both computers and it has to do with playlist sync, when I change the song sequence. The changes I make in MM don't get transfered in iTunes.

The second, and more serious one, appears at home. When I sync with iTunes, ratings and play-count that have changed in iTunes don't get transfered in MM. Of course the previous mentioned problem exists. Also, when I close MM, iTunes doesn't close
I don't know if this problem has something to do with the fact that the OS is 64 bit, but I don't believe so.

Any help appreciated

Thanks a lot

John

[markstuartwalker]

Congratulations Mark for this awesome plugin.
Unfortunately I have a small problem and a big one that makes the plugin useless for me.
First of all I would like to mention that I use the plugin in two different configurations, one at the office (as a test environment) and one at home.
At the office I run WinXP and the latest iTunes and at home Windows 7 x64 and the latest iTunes. At both environments I installed the latest plugin version with the same settings.
The small problem appears in both computers and it has to do with playlist sync, when I change the song sequence. The changes I make in MM don't get transfered in iTunes.

The second, and more serious one, appears at home. When I sync with iTunes, ratings and play-count that have changed in iTunes don't get transfered in MM. Of course the previous mentioned problem exists. Also, when I close MM, iTunes doesn't close
I don't know if this problem has something to do with the fact that the OS is 64 bit, but I don't believe so.

Any help appreciated

Thanks a lot

John

First. As a performance optimisation the plugin will only update a playlist if the lengths in iTunes and MM are different. Consequently simply re-ordering the tracks will not trigger an update as the length remains the same. The simple work around to this is to delete a track off the playlist in iTunes and then re-sync. This will force an update.

Second part a. Are you using the Auto-sync mechanism to update iTunes? This is the only way that playcounts and ratings are synchronised. Adhoc right-click 'synchronise' does not do this.

Second part b. Have you got the 'Launch iTunes Automatically' switch on?

I test using Windows 7 and XP 32 bit. I know of other users that have 64 bit and operate successfully.

I hope these comments help.
Mark

[markstuartwalker]

Revamp of the first page of this thread http://www.mediamonkey.com/forum/viewto ... =2&t=45713

[gvala]

First. As a performance optimisation the plugin will only update a playlist if the lengths in iTunes and MM are different. Consequently simply re-ordering the tracks will not trigger an update as the length remains the same. The simple work around to this is to delete a track off the playlist in iTunes and then re-sync. This will force an update.

Second part a. Are you using the Auto-sync mechanism to update iTunes? This is the only way that playcounts and ratings are synchronised. Adhoc right-click 'synchronise' does not do this.

Second part b. Have you got the 'Launch iTunes Automatically' switch on?

I test using Windows 7 and XP 32 bit. I know of other users that have 64 bit and operate successfully.

I hope these comments help.
Mark

Thanks for your reply!
For the second part a. I use auto-sync!
part b. Yes.

Now, it does not autosync at all even at the office. Only manually. I'll give it a try and I'll try to create a debug log. I'll let you know

Thanks

[gvala]

Debug log:
0000206 3.90397072 [3268] iTunes Plugin 3:05:07 μμ Log initialised
00000207 3.90407038 [3268] iTunes Plugin 3:05:07 μμ Read configuration \Software\MediaMonkey\Device\iTunes\
00000208 3.90416241 [3268] iTunes Plugin 3:05:07 μμ Open registry
00000209 3.90430784 [3268] iTunes Plugin 3:05:07 μμ Open registry done
00000210 3.90444088 [3268] iTunes Plugin 3:05:07 μμ Read values \Software\MediaMonkey\Device\iTunes\
00000211 3.90471625 [3268] iTunes Plugin 3:05:07 μμ Read values done
00000212 3.90486979 [3268] iTunes Plugin 3:05:07 μμ Close registry
00000213 3.90501022 [3268] iTunes Plugin 3:05:07 μμ Close registry done
00000214 3.90516996 [3268] iTunes Plugin 3:05:07 μμ Read configuration done
00000215 3.90523672 [3268] iTunes Plugin 3:05:07 μμ Read configuration \Software\MediaMonkey\Device\iTunes\
00000216 3.90533042 [3268] iTunes Plugin 3:05:07 μμ Open registry
00000217 3.90544367 [3268] iTunes Plugin 3:05:07 μμ Open registry done
00000218 3.90553570 [3268] iTunes Plugin 3:05:07 μμ Read values \Software\MediaMonkey\Device\iTunes\
00000219 3.90573192 [3268] iTunes Plugin 3:05:07 μμ Read values done
00000220 3.90582299 [3268] iTunes Plugin 3:05:07 μμ Close registry
00000221 3.90591836 [3268] iTunes Plugin 3:05:07 μμ Close registry done
00000222 3.90600920 [3268] iTunes Plugin 3:05:07 μμ Read configuration done
00000223 3.90623641 [3268] iTunes Plugin 3:05:07 μμ ItunesInit 23/3/2010 10:29:54 πμ
00000224 4.43675852 [3268] iPhone: LoadLibrary() finished
00000225 4.43693018 [3268] iPhone: iTunesMobileDeviceSupport loaded
00000226 4.43772411 [3268] iPhone: AMSInitialize : 0
00000227 4.44331312 [3268] iPhone: AMDeviceNotificationSubscribe : 0
........
........
0000411 17.34580612 [3268] 2828 DB exec SQL: UPDATE Devices SET LastAutoSynch=40260.628716551 WHERE ID=7
00000412 17.34595108 [3268] 2828 DB lock successful.
00000413 17.39150238 [3268] 2828 DB lock finished, took 90762630.
00000414 17.39410782 [3268] iTunes Plugin 3:05:21 μμ ItunesSyncStart 71050256
00000415 17.42111206 [3268] iTunes Plugin 3:05:21 μμ iTunesScanContent
00000416 17.43946266 [3268] 2828 DB open SQL: select dt.ID,dt.IDTRACK,dt.DEVICEPATH,dt.PLAYCOUNT,dt.RATING dtRATING,dt.UPLOADTIME,s.RATING sRATING,s.PLAYCOUNTER,s.SONGTITLE,s.ARTIST,s.BITRATE,s.SONGPATH,s.LASTTIMEPLAYED,s.FILEMODIFIED from devicetracks dt,Songs s where dt.IDTRACK=s.ID and dt.STATUS=1 and dt.IDDEVICE=7
00000417 17.44010544 [3268] 2828 DB lock finished, took 866140.
00000418 17.44030762 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942261574
00000419 17.44049072 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604700824074
00000420 17.44075394 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942326736
00000421 17.44095039 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604681542709
00000422 17.44121552 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942424421
00000423 17.44139099 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604676687037
00000424 17.44162560 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942503935
00000425 17.44179726 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604682011111
00000426 17.44207382 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942711921
00000427 17.44224548 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604685944329
00000428 17.44249153 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942740857
00000429 17.44266319 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 40260523626632
00000430 17.44292450 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942764352
00000431 17.44309807 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 40260523630069
00000432 17.44335938 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942793287
00000433 17.44353104 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 40260523635127
00000434 17.44377708 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942856597
00000435 17.44394875 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 40260523639109
00000436 17.44418716 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942871065
00000437 17.44436073 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 40260523643264
00000438 17.44461441 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 402604942887384
00000439 17.44478607 [3268] iTunes Plugin 3:05:21 μμ MMvalidDate Integer overflow 40260523647245
00000440 17.44734573 [3268] iTunes Plugin 3:05:21 μμ ItunesSyncEnd 71050256
00000441 17.44746780 [3268] iTunes Plugin 3:05:21 μμ Report scanned=0 uploaded=0 deleted=0 existing=0 converted=0 filenames=0 missing=0 new=0 sqlTss=0 sqlSongs=0 synced=0 ignored=0 ID3tags=0 Period=12:00:00 πμ
00000442 17.47976875 [3268] Going to make final callback 2828

After that I changed Local Settings into English(United States) (I use Greek).
And it worked!

To try it a bit further, I re-changed Local Settings back to Greek. And it still works fine!

[markstuartwalker]

Debug log:

After that I changed Local Settings into English(United States) (I use Greek).
And it worked!

To try it a bit further, I re-changed Local Settings back to Greek. And it still works fine!

Several people have reported that regional setting can cause failures and I've added alot of exception handling to isolate the problems. It is rooted in Delphi's storage of dates as floats - in some regions it uses ',' and others '.' as the separator. Once these get persisted into the DB the problem persists. Once they get updated correctly the problems vanish.

I thought I'd nailed all the exception areas. Please can you confirm the date of the exe that you are using?

Mark