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
You could do this externally via the file list report.
Before your trip:
[list]Select all files in your big playlist. [/list]
[list]Select File > Reports > File List[/list]
[list]Ensure that the list of fields to export includes "Played #", and [/list]
[list]export that to a CSV file (a text format compatible with Excel)[/list]
This will give you a file recording your starting playcounts.
During your trip:
[list]Enjoy your music and watch your playcounts going up. [/list]
After your trip:
[list]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)[/list]
[list]Selct all files in your big playlist.[/list]
[list]Export the file list to CSV format again.[/list]
[list]Open both before and after CSV files in Excel. [/list]
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