• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

Reports

Started by danny.oranim, August 31, 2019, 12:04:51 PM

danny.oranim

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

danny.oranim

Its very urgent for me,always I get stop in one of the rotations

shawncochran

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
Pirate Radio America - You NEVER KNOW what you're gonna get!
http://www.pirateradioamerica.us

danny.oranim

I`m using radiodj ver 2.0.0.6 And mariadb ver 10.3

givengo440

GM,

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

danny.oranim

Quote from: 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
I do like you explained and its still showing about 12 hours

danny.oranim

Did some one had an another solution?

danny.oranim

The problem that one of the songs stop my playlist and I need to find this song

Marius

Quote from: givengo440 on September 03, 2019, 12:07:18 PM
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.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

danny.oranim

Quote from: Marius on September 09, 2019, 10:11:53 AM
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 ?

Marius

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.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

stevewa

Quote from: 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

I wish you started your thread with this important information

Look in windows event viewer for an error which caused your rotation to stop.

danny.oranim

Quote from: stevewa on September 09, 2019, 04:46:55 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.

stevewa

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).

bluesbeat

Is it possible a music file is corrupt or odd format and that would crash RDJ?