RadioDJ - Free Radio Automation Software Forum

RadioDJ v2 => RadioDJ v2 Support Forum => Topic started by: manishboyradio on January 04, 2019, 10:07:14 PM

Title: LAST PLAYED
Post by: manishboyradio on January 04, 2019, 10:07:14 PM
is there anyway to make radio dj create a last played text file as it is playing live?, so it updates a text file with the most recent songs played?
Title: Re: LAST PLAYED
Post by: plauri on January 05, 2019, 12:34:00 AM
It's what the program does since the early versions. Just say to your encoder to look into your NowPlaying.txt which should be located in radiodj directory. 
Title: Re: LAST PLAYED
Post by: manishboyradio on January 05, 2019, 01:45:46 AM
I am talking about files that have played, not currently playing which is what the now playing text file is. I want a text file as radio dj is playing to create record of what has played, no currently playing
Title: Re: LAST PLAYED
Post by: plauri on January 05, 2019, 02:45:18 AM
Look at Jhonny site, he has scripts that can make it https://radiodj.info/ (https://radiodj.info/)
Title: Re: LAST PLAYED
Post by: Jhonny on January 05, 2019, 10:37:09 AM
You can use reports to make a txt file.
With this template file - General - Last Played Tracks on date.html.
Put it in the c:\RadioDJv2\templates\reports\ folder.
Only tested on last 5 days.
Title: Re: LAST PLAYED
Post by: manishboyradio on January 12, 2019, 01:49:38 AM
Is there anyway to setup a query to run within radio dj to generate a file that shows what has played within the last 20 min?
Title: Re: LAST PLAYED
Post by: manishboyradio on January 13, 2019, 04:37:53 PM
I am sorry but i am not familiar with all the scripting for that, what would be the query string i would need to run to get the last, lets say 15 tracks played. Then put that into a text file or a html file?

Thanks in advance
Title: Re: LAST PLAYED
Post by: Calypso on January 14, 2019, 08:33:30 AM
I am sorry but i am not familiar with all the scripting for that, what would be the query string i would need to run to get the last, lets say 15 tracks played. Then put that into a text file or a html file?

Thanks in advance

You could use a query like

Quote
select date_played,artist, title from history where date_played>date_sub(now(), interval 15 minute);

Title: Re: LAST PLAYED
Post by: manishboyradio on January 14, 2019, 06:11:14 PM
Could you please give a full example? with the query creating a text or html file, Again i appreciate your help

Thanks,
Andrew
Title: Re: LAST PLAYED
Post by: manishboyradio on January 14, 2019, 06:55:31 PM
Awesome, this helps a bunch, i am looking to use this to integrate this into my twitch stream, so that OBS streaming software reads that text file generated to show what had played recently. unless you know of another way to have OBS streaming software to read last played information from Radio DJ. or integrate into twitch

Thanks again