Separate play counts

Get answers about the current version of MediaMonkey 5

Moderator: Gurus

MPG
Posts: 428
Joined: Tue May 13, 2008 11:22 pm

Separate play counts

Post by MPG »

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?
TIA
MPG
Triumph - Hold On: Music holds the secret, to know it can make you whole.
MPG
Posts: 428
Joined: Tue May 13, 2008 11:22 pm

Re: Separate play counts

Post by MPG »

With no suggestions, I guess it isn't possible?
TIA
MPG
Triumph - Hold On: Music holds the secret, to know it can make you whole.
Peke
Posts: 17861
Joined: Tue Jun 10, 2003 7:21 pm
Location: Earth
Contact:

Re: Separate play counts

Post by Peke »

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?
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
Image
How to attach PICTURE/SCREENSHOTS to forum posts
MattTown
Posts: 336
Joined: Sun Mar 15, 2009 5:09 pm
Location: Australia

Re: Separate play counts

Post by MattTown »

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
MM 2024.0.0.3061 debug (WEF 7 Oct 2024, Portable Mode), Gold lifetime license, user since 2009.
Currently 27K files. Library and music files are on a separate partition (E:\) on external USB drive.
Windows Surface Book (Original), i5, 8GB RAM, 250GB SSD.
Win10 Home 64 bit, update: 23H2 22631.3880
MMA 2.0.0.1103, Android 13 on Nokia XR20, music files on SD card.
MPG
Posts: 428
Joined: Tue May 13, 2008 11:22 pm

Re: Separate play counts

Post by MPG »

Hey Matt,
Great suggestion! I'll do exactly that. Just for curiosity sake. LOL. Ah, the important things in life. LOL.
TIA
MPG
Triumph - Hold On: Music holds the secret, to know it can make you whole.
Barry4679
Posts: 2446
Joined: Fri Sep 11, 2009 8:07 am
Location: Australia
Contact:

Re: Separate play counts

Post by Barry4679 »

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?
Want a dark skin for MM5? This is the one that works best for me .. elegant, compact & clear.
rodrigueza
Posts: 1
Joined: Tue Sep 24, 2024 1:20 am

Re: Separate play counts

Post by rodrigueza »

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?
MPG
Posts: 428
Joined: Tue May 13, 2008 11:22 pm

Re: Separate play counts

Post by MPG »

Use the Path as the unique identifier. Each song can only exist in one location on the storage device.
TIA
MPG
Triumph - Hold On: Music holds the secret, to know it can make you whole.
Post Reply