RadioDJ tutorials


    Screen update v.1.8.1 bottom of the page. [Go to it]

    Track Rotations.

    Use to set Up Auto Play rotations.




    Note: You can select from a playlist event only if there are manual events are made!


    So Playlist event is greyed out.

    If Track From Category is selected.

    This button are the same as in the search screen.

    (Main Category, Sub Category and Genre.)

    These two buttons are for each rotation rule you want to add on the line


    .

    (LINE NUMBER, CATEGORY, SUBCATEGORY, GENRE, SELECTION TYPE, SWEEPER and REPEAT RULES),


    .

    The Rules when or what to play.

    If you choose By Priority, make the settings correct and the priority for the track will be lowered.

    Where to put a sweeper.

    After a selection:

    Push the GREEN + button to add the rotation you have selected.

    Push the RED – button to delete a rotation (make sure it is highlighted first)

    When you have added all the different rotations that you want, you can save your Rotation Rules

    by Pushing the Save button (Second >> Button at the Top Right of the “Track Rotations” popup)

    Popup:

    Give a rotation name or replace a rotation or deleted a rotation.

    NOTE: Make sure you have sufficient songs (a minimum 500 is oke) for the different rules you select , so that there are no problems with selections being over-ruled by RadioDJ's Auto DJ setup rules.

    Sweepers to Rotations.

    If you like a sweeper to a rotation, you must select the box showing Without and select in the drop down box where to put the sweeper.

    A rotation setup of tracks from category without sweepers.

    By the lines 1, 2 and 4 you can see that when it is from the main category Music the box repeat Rules is enabled and will be used as you have set in radiodj settings.

    With the mouse pointer on the line number you can drag and drop the lines to change the order of the lines.

    As shows, if it is a Jingle then the repeat rules box is disabled. and me played more offend.

    Same applies for a sweeper or event, but you can enable the box if you like, so that the repeat rules work for them to.

    There is also the possibility to change a line in the rotation.

    Select a line.

    In this case the category is BPM and the subcategory is 70.

    The two button are

    Now double click on the line, and the two buttons change to

    And are as showed in the screen.

    By using the pull down menus you can change the category and the subcategory and the other pull down menus.

    After the change press on the floppy on the right site

    To save the changes in the rotation.


    Screen update v.1.8.1.

    There is a extra button for duplicate a rotation line.


    Select a line and click on the button.

    Under the selected line will be placed a duplicate line.
    This allows you to select the duplicated line and move down or up in the rotations.

    SQL query editor.



    In the screen you see a circle on the intervals.

    You can use them after the SQL NOW() Function.

    Like: (TIMESTAMPDIFF(MINUTE, `artist_played`, NOW()) > $ArtistRepeatInterval$)

    So it use the rotations rules of RDJ.

    Track From SQL Querty.

    The use of it by Marius:

    Since not all users are familiar with SQL language, i will try to leave here some query examples.
    First, open the rotation editor and add a "Track from SQL Query" entry to the rotation. Now double click that entry.
    The SQL editor should appear.



    The example is something that was asked recently:

    PLAY TWO TRACKS FROM THE SAME ARTIST.

    Paste the following query to the editor and save it.

    SELECT `ID`, `artist` FROM `songs` WHERE `artist`=(
    SELECT `artist` FROM `songs` 
    WHERE `enabled`=1 
    AND `song_type`=0 
    AND ((`start_date` <= Now()) AND (`end_date` >= NOW() OR `end_date` = '2002-01-01 00:00:01'))
    AND ((TIMESTAMPDIFF(MINUTE, `date_played`, NOW()) > $TrackRepeatInterval$) AND (TIMESTAMPDIFF(MINUTE, `artist_played`, NOW()) > $ArtistRepeatInterval$)) 
    GROUP BY `artist` 
    HAVING COUNT(*) > 1 
    ORDER BY `date_played` ASC LIMIT 1) 
    AND `enabled`=1 
    AND `song_type`=0 
    AND ((`start_date` <= Now()) AND (`end_date` >= NOW() OR `end_date` = '2002-01-01 00:00:01'))
    AND ((TIMESTAMPDIFF(MINUTE, `date_played`, NOW()) > $TrackRepeatInterval$) AND (TIMESTAMPDIFF(MINUTE, `artist_played`, NOW()) > $ArtistRepeatInterval$)) 
    ORDER BY `date_played` ASC 
    LIMIT 2;

    Like:


    Press the button

    The query will search for enabled tracks that are song type and where artists has more than one tracks available. It also applies the user repeat rules to the results.
    This can be a separate rotation, loaded using an event for example when you want to play this kind of format, or it can be added to an existing rotation.

    As a rule, please remember that any query you add as a rotation entry MUST return at least the track ID.

    If the query is not ok than you get a error.

    Else:

    Closes the screen by pressing on.

    And save the rotation.

Back to top
©  JWL  2013 | 2017