RadioDJ - Free Radio Automation Software Forum

RadioDJ v2 => RadioDJ v2 Support Forum => Topic started by: danny.oranim on August 31, 2019, 12:04:51 PM

Title: Reports
Post by: danny.oranim on August 31, 2019, 12:04:51 PM
Hey,
I`m trying to get a report for what played in the last 24 hours,but when I do a general report from 24-25/08/19,I get a report only for a about 12 hours in that days.I need to get a full report but its not works.
I try to change from ascending to descending but its not helping.
https://oranimlive-my.sharepoint.com/:i:/g/personal/danny_tveria_oranim_ac_il/EcBL4f6GKeBJpF1yMjtr_YMBzNeuNC6g2RszXq6j7xMRFg?e=ldWMYk

https://oranimlive-my.sharepoint.com/:i:/g/personal/danny_tveria_oranim_ac_il/EXZZhs9mLB1OpqctA3od83EBCkPwK9E40Pztk4k4H6PZcA?e=oe34iZ
Title: Re: Reports
Post by: danny.oranim on September 01, 2019, 09:21:51 AM
Its very urgent for me,always I get stop in one of the rotations
Title: Re: Reports
Post by: shawncochran on September 02, 2019, 05:30:53 PM
What version of software are you running and what database are you running (e.g. MariaDb)?

Have you tried to set the report template to "general-detailed report" and selected track type "all tracks" then selected the dates above from/to giving you a 24 period? I just did this with my sort by "date played" and "ascending"

I attached my report so you can see what my system did:

https://drive.google.com/open?id=1DzgncPSe-zd_exed2Rav4oljEc_zpyGD
Title: Re: Reports
Post by: danny.oranim on September 03, 2019, 10:19:07 AM
I`m using radiodj ver 2.0.0.6 And mariadb ver 10.3
Title: Re: Reports
Post by: givengo440 on September 03, 2019, 12:07:18 PM
GM,

I also need reports that show not only Spins but also Performances
Title: Re: Reports
Post by: danny.oranim on September 04, 2019, 08:48:08 PM
What version of software are you running and what database are you running (e.g. MariaDb)?

Have you tried to set the report template to "general-detailed report" and selected track type "all tracks" then selected the dates above from/to giving you a 24 period? I just did this with my sort by "date played" and "ascending"

I attached my report so you can see what my system did:

https://drive.google.com/open?id=1DzgncPSe-zd_exed2Rav4oljEc_zpyGD
I do like you explained and its still showing about 12 hours
Title: Re: Reports
Post by: danny.oranim on September 09, 2019, 06:59:04 AM
Did some one had an another solution?
Title: Re: Reports
Post by: danny.oranim on September 09, 2019, 08:05:48 AM
The problem that one of the songs stop my playlist and I need to find this song
Title: Re: Reports
Post by: Marius on September 09, 2019, 10:11:53 AM
GM,

I also need reports that show not only Spins but also Performances

Performaces can only be reported if the database contains the number of listeners.
Title: Re: Reports
Post by: danny.oranim on September 09, 2019, 12:07:28 PM
Performaces can only be reported if the database contains the number of listeners.
And if I need just to see a full report of the songs that played ?
Title: Re: Reports
Post by: Marius on September 09, 2019, 03:15:06 PM
As long the history is enabled, that can be generated using the "General - Detailed Report". If you need to see all the entries, don't select any period.
Title: Re: Reports
Post by: stevewa on September 09, 2019, 04:46:55 PM
The problem that one of the songs stop my playlist and I need to find this song

I wish you started your thread with this important information

Look in windows event viewer for an error which caused your rotation to stop.
Title: Re: Reports
Post by: danny.oranim on September 09, 2019, 06:13:26 PM
I wish you started your thread with this important information

Look in windows event viewer for an error which caused your rotation to stop.
I looked for a events,I didn`t saw  something wrong.
I suspect for one of the songs in a specific rotation.Did you have some recommend how to find him?
Maybe one of the operators from the radio station put a Manuel event that sets pause on the end of the track in the edit of the track.
Title: Re: Reports
Post by: stevewa on September 09, 2019, 11:53:18 PM
for that you would need to use a database tool like HeidiSQL to directly query data tables, and find tracks that have events assigned to them, and using that same tool you could read the history data table and see what the last song that was played before there was a long gap with no music (the crash).
Title: Re: Reports
Post by: bluesbeat on September 10, 2019, 05:07:33 AM
Is it possible a music file is corrupt or odd format and that would crash RDJ?
Title: Re: Reports
Post by: danny.oranim on September 10, 2019, 06:59:58 AM
for that you would need to use a database tool like HeidiSQL to directly query data tables, and find tracks that have events assigned to them, and using that same tool you could read the history data table and see what the last song that was played before there was a long gap with no music (the crash).
The rdj not crashing,I have a manual event that making a pause for the events.It`s possible that 1 of the radio operators put in the end of the song that manual event by mistake,cause of that the stop button is on the events not changing.
And how I using  HeidiSQL to find the song?
Title: Re: Reports
Post by: stevewa on September 10, 2019, 12:31:09 PM
I’m sorry I don’t have time to teach you Heidi sql, you’re needing to learn it from YouTube
Title: Re: Reports
Post by: danny.oranim on September 10, 2019, 02:23:03 PM
I’m sorry I don’t have time to teach you Heidi sql, you’re needing to learn it from YouTube
In which table I can see that according the screenshot I attached?
https://oranimlive-my.sharepoint.com/:i:/g/personal/danny_tveria_oranim_ac_il/EdYUFaNVTKFOv6pMTA1shsYBMfMWxycSxmEmOsYt8NBMeQ?e=DVQa5l
Title: Re: Reports
Post by: stevewa on September 10, 2019, 02:37:18 PM
edit your post so it is a link that we can click on,
Title: Re: Reports
Post by: stevewa on September 10, 2019, 02:41:12 PM
lol, you are smart enough to use vnc, AND launch MySQL Workbench, BUT you can't browse thru the data tables to find which one has the playback history in it?
OR which table has song data in it, and which column has event codes?

shake my head. i'm trying to embarrass you so you don't make these silly mistakes next time. apes gave you a brain. use it.
Title: Re: Reports
Post by: DJ Garybaldy on September 10, 2019, 02:44:37 PM
OK can we try being a little less rude when replying to someone's problem we want the user to feel they're part of a community try not to belittle people. We all had to start somewhere.
Title: Re: Reports
Post by: Jhonny on September 10, 2019, 03:06:11 PM
edit your post so it is a link that we can click on,
There is a search button in the top bar of Heidi .
Title: Re: Reports
Post by: bnickles1961 on September 10, 2019, 03:13:16 PM
I agree Gary, people should feel confident when asking for help and should not have to be subject to people being rude.  This is a help and support forum.
Title: Re: Reports
Post by: Jhonny on September 10, 2019, 03:26:18 PM
Ok select the table history and look in the column date_played for a big divers in time zo you can find the track .
Title: Re: Reports
Post by: stevewa on September 11, 2019, 01:38:51 PM
Yeah I’ll chill out
Title: Re: Reports
Post by: danny.oranim on September 11, 2019, 08:56:20 PM
Ok select the table history and look in the column date_played for a big divers in time zo you can find the track .
I trying to find the date 24-25/08/19 but the history table showing me only from 01/09/19 until 04/09/19
There a way to change the database to show more dates?
I attached a screenshot
https://oranimlive-my.sharepoint.com/:i:/g/personal/danny_tveria_oranim_ac_il/Ebskb1QIwrhDmIMU70SnXy8BbFN18ZRf7av2FyMmplMuqw?e=wVtJpF