Separate play counts

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: Separate play counts

Re: Separate play counts

by MPG » Tue Sep 24, 2024 8:58 am

Use the Path as the unique identifier. Each song can only exist in one location on the storage device.

Re: Separate play counts

by rodrigueza » Tue Sep 24, 2024 1:27 am

Before your trip:
Select all files in your big playlist.
Select File > Reports > File List
Ensure that the list of fields to export includes "Played #", and
export that to a CSV file (a text format compatible with Excel)
This will give you a file recording your starting playcounts.

During your trip:
Enjoy your music and watch your playcounts going up.
How can users ensure that the song names in both CSV files match up correctly, especially if there are variations in naming conventions or if songs have been modified in the library?

Re: Separate play counts

by Barry4679 » Sat May 18, 2024 10:39 pm

An alternate suggestion would be to freeze the tracks' playcount to one of the Custom columns (eg. custom9).
After the holiday you could calculate and store the playcount change into another custom column.

You could do both operations using the SQL Editor MM5 addon.
You would need to know sql syntax to be able to write the two commands. PM me if you need assistance.

There is a MM5 addon named Copy & Swap Fields, but it doesn't seem to handle play counts. ... as a suggestion perhaps the addon could be enhanced to allow for this?

Re: Separate play counts

by MPG » Wed May 15, 2024 2:46 pm

Hey Matt,
Great suggestion! I'll do exactly that. Just for curiosity sake. LOL. Ah, the important things in life. LOL.

Re: Separate play counts

by MattTown » Mon May 06, 2024 8:09 pm

You could do this externally via the file list report.

Before your trip:
  • Select all files in your big playlist.
  • Select File > Reports > File List
  • Ensure that the list of fields to export includes "Played #", and
  • export that to a CSV file (a text format compatible with Excel)
This will give you a file recording your starting playcounts.

During your trip:
  • Enjoy your music and watch your playcounts going up.
After your trip:
  • Sync your portable device back to MMW and ensure that the metadata is returned to your library (that will get the playcounts back off your mobile device)
  • Selct all files in your big playlist.
  • Export the file list to CSV format again.
  • Open both before and after CSV files in Excel.
A simple subtraction formula in Excel will give you the change in playcount for each file. You will probalby need some extra coding to make sure that you're matching the same song names for the subtractions, but simple lookups will do that for you.

Cheers

Matt

Re: Separate play counts

by Peke » Mon May 06, 2024 6:15 pm

Hi,
No it is not possible :(

I was trying to make backup of MM5.DB in second portable MM and create Auto Playlists to compare last played dates of tracks to filter, but unfortunately there is no way you can tell if one track was 9 times during travel and others plated only 3 times.

It could be a good stat for tracking liked tracks eg. something these tracks are played after last sync and show how much each one is played after last sync.

Did I catch it correctly or?

Re: Separate play counts

by MPG » Mon May 06, 2024 9:42 am

With no suggestions, I guess it isn't possible?

Separate play counts

by MPG » Wed May 01, 2024 5:34 pm

Hi,
I am going on a 3 month trip this summer and I have a Playlist that I'll be using. The playlist is synced to my phone. While traveling I'd like to see what songs I listened the most and which ones were never played. I've been using the Playlist for awhile so I don't really want to lose the current play count. The Playlist is over 10K songs so it's not like I can take a snapshot. Any suggestions?

Top