Andrew: [Paxman voice] Ye-e-e-e-e-e-es …
Quick Logging tutorial:
The START Entry specifies WHAT you want in the line/row written to the log file/database when an item in the Playlist and/or Cartwall is STARTed; the Stop Entry specifies the text for the STOP line/row written when something STOPs (for faded out items, the time logged is the time when the Player/Cart ACTUALLY stops, so it includes the fadeout time.
What you type into those boxes is either text, or more usually, logging variables, which are described here: http://wiki.mairlist.com/index.php/Logging_Variables.
For example, my own Start Entry and Stop Entry are:
Start: %D-%M-%Y %h:%m:%s%tSTART%t%1%t%b%t%a%t%t%i{TALB}%t%i{TRCK}%t%i{TYER}
Stop: %D-%M-%Y %h:%m:%s%tSTOP%t%1%t%b%t%a%t%e%t%i{TALB}%t%i{TRCK}%t%i{TYER}
Copy/paste those into your mAirList Config as a starting point, then run mAirList for a while to see what they write out. The Wiki page cited above should explain everything.
You can then decide WHY you need log files, WHAT you need in them, and then use the Wiki page to ‘modify, test, and implement’ the changed versions to your exact requirements. (Remember: this is mAirList, so ‘… you decide!’)
The resulting log text file from my settings loads very nicely as a Tab Delimited file into Excel (or Calc).
I have an Excel template with macros, Word template, etc. designed to work with this (with documentation yet!!!), which I’d happily send to you if that’s of interest. Basically, the Excel template macro ‘converts’ those log entries into single lines per item, with the ‘actual broadcast duration’ of each. Since the log lines pick up the Artist, Album, Track Number, Title, and Year (if specified in the MP3 files’ tags), it makes PRS returns a bit of a doddle. ;D
I daresay that if the tags contain the Album Number and Label in some consistent form, and armed with a little knowledge of the fields in an MP3 tag, you could write those pieces of info. into the log as well.
PS: You can also use variables in the log file name. Mine is:
C:\Program Files\mAirList\Log%Y-%M-%D.LOG … which results in one log file per day.
(YMD is a better file naming system than DMY, because YMD sorts into the correct order in Windows Explorer ;).)
Hope that helps!
BFN
CAD