by frankz » Thu Aug 10, 2017 7:13 pm
I'll be as detailed as I can.
When you do a sync between MMA and MMW, MMA copies its play data back to your MMW library, but it is incomplete (in your MMW database).
What's supposed to happen is that it should copy all plays into a table called "Played" in your MMW database and then update the "Songs" table with the most recent play and the number of plays (displayed as "Last Played" "Play Count in MMW") if your most recent MMA play of a song is more recent than your most recent MMW play of a song. This is what happens in Ipod/iPhone.
What actually happens is that it does not copy any of your MMA plays into MMW's "Played" table at all. It only updates MMW's "Songs" table with the most recent played and increments the Play Count there.
Which means that you could have 10 plays of a song in MMA, but your actual play history (if you look at it with "Add/Remove Playstat") does not contain this history. It only contains your MMW plays.
When MMA updates metadata to MMW, it should:
1. Copy each play of each track you've listened to into MMW's "Played" table.
2. Look at which play (MMA or MMW) is most recent and then update MMW's "Songs" table (LastPlayedTime field) if the most recent MMA play is more recent than the last MMW play.
3. Increment MMW's "Songs" table ("PlayCount" field) to add the number of plays it has added to the song's history.
As it stands now, it's only doing #2, which means none of the MMA plays are added to the song's actual history, and only its most recent play is added to the song's displayed data. The PlayCount in the "Songs" table (displayed in the interface) does not match the number of plays in the history, and the number of plays in the history isn't accurate because it doesn't contain the MMA plays.
So, yes, the displayed "LastPlayed" and "PlayCount" will match between MMW and MMA, but "Play Count" is certainly inaccurate as is the MMW database history of plays.
I'll be as detailed as I can.
When you do a sync between MMA and MMW, MMA copies its play data back to your MMW library, but it is incomplete (in your MMW database).
What's supposed to happen is that it should copy all plays into a table called "Played" in your MMW database and then update the "Songs" table with the most recent play and the number of plays (displayed as "Last Played" "Play Count in MMW") if your most recent MMA play of a song is more recent than your most recent MMW play of a song. This is what happens in Ipod/iPhone.
What actually happens is that it does not copy any of your MMA plays into MMW's "Played" table at all. It only updates MMW's "Songs" table with the most recent played and increments the Play Count there.
Which means that you could have 10 plays of a song in MMA, but your actual play history (if you look at it with "Add/Remove Playstat") does not contain this history. It only contains your MMW plays.
When MMA updates metadata to MMW, it should:
1. Copy each play of each track you've listened to into MMW's "Played" table.
2. Look at which play (MMA or MMW) is most recent and then update MMW's "Songs" table (LastPlayedTime field) if the most recent MMA play is more recent than the last MMW play.
3. Increment MMW's "Songs" table ("PlayCount" field) to add the number of plays it has added to the song's history.
As it stands now, it's only doing #2, which means none of the MMA plays are added to the song's actual history, and only its most recent play is added to the song's displayed data. The PlayCount in the "Songs" table (displayed in the interface) does not match the number of plays in the history, and the number of plays in the history isn't accurate because it doesn't contain the MMA plays.
So, yes, the displayed "LastPlayed" and "PlayCount" will match between MMW and MMA, but "Play Count" is certainly inaccurate as is the MMW database history of plays.