Generate XML file of played audios

[adrinto]

Hello, I asked Marius to create a plugin to export to an XLM file folder all the audio that the radio DJ played.

It would do it automatically for days as is done for automatic backups.

The idea would be to create an XLM or Word file of all the audio played on the day, etc.

I would be grateful .

I would like to ask anyone who understood me if there is any way to make the radio DJ generate the file or if there is any software outside of the radio DJ that performs this function.

The idea is to create a descriptive file, a list of audios played by Radio DJ during a day/week/month

Anyone who has a solution would appreciate it

I'm grateful

[Kiwi]

Have you thought of using RadioDJ's Reports? Utilities/Reports/ General Detailed Report export it as HTML then convert it to XLM using software available on the web? Could be a workaround...

Also ensure you have the "Keep History For" option set to the number of days you desire. Options/Options/Settings/Stream Titles/Others

[stevewa]

this can get you started

copy a report file,
edit the sql inside that file

Code Select Expand

SELECT
concat('<datetime>', date_played, '</datetime>') AS date_played_xml,
concat('<title>', title, '</title>') AS title_xml

FROM history
ORDER BY date_played DESC

also, next time, give more of an explanation of what you are trying to do, how / where the output will be used, etc.