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

Table with all the scheduled commercials from weekdays to weekend

Started by PresidentOfACPJ, February 09, 2023, 04:14:21 AM

PresidentOfACPJ

Hello guys!

Is it possible with RadioDJ or anything else, to see something like a table with all the commercials scheduled for everyday/weekdays and weekends for example:


06:20 Supermarket LIDL - CAR WASH CLEAN HOUSE - PETSHOP SUPER DOG - ELETTRONIC STAR.
06:20 HOUSE OF CONSTRUTION - GO UP SEXUAL CLINIC - SCHOOL FOR ENGINEERS - WORLD DRUGSTORE.
06:40 Supermarket LIDL - PETSHOP SUPER DOG - WALMART - AMERICAN SHOP - CAT FISH.
07:00 SUPERMOTO - MECHANICAL NEW CAR - AMERICA MALL - LINE - MARRIAGE HOUSE.
07:20 GO UP SEXUAL CLINIC - WORLD DRUGSTORE - AMERICAN SHOP - CAT FISH.
07:40 ETC - ETC.
08:00 ETC...


Do you know how to generate it?


KBMZ RADIO:

radiorockfm.com.br/
twitter: @radiorockfmreal/
fb: @radiorockfmreal

studioflashback.com.br
twitter: @radiosflashback
fb: @radiostudioflashback

BR The Classic Rock:
radiorockfm.com.br/br
twitter. @classicrockbr
fb: @classicrockbr

ZTOP:
radiorockfm.com.br/ztop
twitter: @ztop
fb: @ztop

stevewa

how are they scheduled?
in the events system?
or inside rotations?
or inside playlists?


PresidentOfACPJ

Quote from: stevewa on February 09, 2023, 04:47:03 PM
how are they scheduled?
in the events system?
or inside rotations?
or inside playlists?
How they are generated is not important here, the important thing here is to get or to generate the list of all the commercials in a commercial block, made thru events, rotations, or anything else.

Please;

Note the Is it in the begining of the sentence.

I mean, wut i would like to have, wut i want is the table, the list, the grafic , call as you want, of all the comercials schedule in a commercial block, just selection on of them, or al of them, like shown earlier..
KBMZ RADIO:

radiorockfm.com.br/
twitter: @radiorockfmreal/
fb: @radiorockfmreal

studioflashback.com.br
twitter: @radiosflashback
fb: @radiostudioflashback

BR The Classic Rock:
radiorockfm.com.br/br
twitter. @classicrockbr
fb: @classicrockbr

ZTOP:
radiorockfm.com.br/ztop
twitter: @ztop
fb: @ztop

Jhonny

Started  with radiodj  0.1.5.8..
Now on::
RadioDj v 2.0.4.5
With.
MariaDB v 11.6.1 server (crappy)
Got back to.
MariaDB v 10.6 (64) server
Scripting server:
wampserver3.3.6 (x64) with PHP 8.3.13

stevewa

Quote from: PresidentOfACPJ on February 18, 2023, 03:44:21 AM
How they are generated is not important here

of course it is important! you can't know how to query the database to produce a report if you don't give that detail.

PresidentOfACPJ

Quote from: stevewa on February 22, 2023, 03:47:08 PM
of course it is important! you can't know how to query the database to produce a report if you don't give that detail.
But i dont want to query, i would live to have avaliable in radiodj newer version, unless it is already avaliable.
KBMZ RADIO:

radiorockfm.com.br/
twitter: @radiorockfmreal/
fb: @radiorockfmreal

studioflashback.com.br
twitter: @radiosflashback
fb: @radiostudioflashback

BR The Classic Rock:
radiorockfm.com.br/br
twitter. @classicrockbr
fb: @classicrockbr

ZTOP:
radiorockfm.com.br/ztop
twitter: @ztop
fb: @ztop


PresidentOfACPJ

Quote from: mebo870 on May 27, 2023, 12:22:19 AMDo you mean something like this

Yeah, i think its usefull, i thought it will be better in line, but, if theres only this way, lets get started...
KBMZ RADIO:

radiorockfm.com.br/
twitter: @radiorockfmreal/
fb: @radiorockfmreal

studioflashback.com.br
twitter: @radiosflashback
fb: @radiostudioflashback

BR The Classic Rock:
radiorockfm.com.br/br
twitter. @classicrockbr
fb: @classicrockbr

ZTOP:
radiorockfm.com.br/ztop
twitter: @ztop
fb: @ztop

PresidentOfACPJ

KBMZ RADIO:

radiorockfm.com.br/
twitter: @radiorockfmreal/
fb: @radiorockfmreal

studioflashback.com.br
twitter: @radiosflashback
fb: @radiostudioflashback

BR The Classic Rock:
radiorockfm.com.br/br
twitter. @classicrockbr
fb: @classicrockbr

ZTOP:
radiorockfm.com.br/ztop
twitter: @ztop
fb: @ztop