+49 (0) 89 - 55 27 77 - 91 support@createctrl.com

CreateCtrl Help-Center

How can we help you?

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    Rule set management dialog

    Rule sets can be used to generate warnings if a content planning is in violation with one of the active rules. The same rules can also be used in the automatic planning (see Automatic planning). The available rules are (see rule set definitions for more details): 

    • Element must be greater than 0
    • No remaining time in the hour
    • Campaign is already planned in the hour
    • Element is already scheduled in the hour
    • Violation of youth protection
    • Type is already scheduled in the hour
    • Violation of period of use
    • Violation of environmental regulations
    • Violation of scheduling between 2 commercial blocks
    • Violation of scheduling between 2 programs
    • Violation of Just a trailer before advertising
    • No scheduling between 1 and 9

    In order to verify if a specific rule is broken, the user has to activate a rule set with the desired rule. Either use a rule set which includes the desired rule add the rule to an existing rule set or create an entirely new rule set. After setting a rule set to default, the user needs to activate the default rule set in the header above the plan. After enabling a rule set, rule breaks of newly planned elements issue a Broken rule warning.

     

    Rule set management

    Click the button to open the Rule set management dialog. Define a rule set as default by clicking the default checkbox in the rule set management dialog. 

    Click the button to create a new rule set. To modify an existing rule set click the Update button or Copy button to create a new rule set based on an existing one. Individual rule sets can be deleted by clicking the Delete button. All rules sets can be deleted by clicking the button.

    Edit rule set

    Click the add button to add a rule to the rule set. 

    Click the remove button to remove a rule from the rule set.

    Click the save button to save the changes.

    Rule set definitions

    1. Duration greater then 0 
      This rule will check if a duration of planned element is null or 0. In that case rule will be broken.  
      Element needs to have valid duration not to break this rule.
    2. Remaining time in the hour 
      Check what is the remaining time in one hour. If planned element will make time smaller then 0, then  
      the rule is broken. Bumper from Channel should be already calculated in remaining time. If not, then  
      consider also Bumper time from channel. Check Attribute “Bumper_KPM” on Channel. 
      “(select * from par_kanal k, mrg_parameter_atribut a, mrg_parameter_atributtyp t 
      where k.kanal_id = a.merge_id and a.parameter_atributtyp_id = t.parameter_atributtyp_id 
      and t.key = 'BUMPER_KMP')”. Bumper time is time defined within Channel attribute, and it is in  
      seconds. It will allow us to plan as rest time – bumpertime.
    3. Campaign already scheduled 
      Check if in current hour, there is already element from same campaign planned. 
      If Campaign has 5 elements. We plan first element in between 09:00-10:00. We take then second  
      element, and we plan also in between 09:00-10:00. Rule is broken. So, in one hour no two elements  
      from same campaign should be planned.
    4. Campaign is Double  
      Check if same element from one campaign is planned in current hour. So, if it is duplicated within  
      hour. Rule is broken then.
    5. Type is double  
      Campaign has several DSG and TRFSG elements. Every element has defined Trailer Version Type /  
      Design Type. If we plan element with same type in one hour, rule is broken.
    6. Protection of Minors  
      Check if parental rating of planned element can be planned in defined time. So every element in campaign have  
      parental rating value. When we make planning, we chose on which channel we plan. Channel has a table  
      REF_FSK_KANAL. In this table there are properties: FreiVon, FreiBis, SperreVon, SperreBis. We first  
      check if planned datum in between SperreVon-SperreBis. If yes, then rule is not broken. If these fields  
      are null or empty, then we check fields FreiVon-FreiBis. If all these 4 fields are empty, or if FSK is not  
      contained in REF_FSK_KANAL, then we take same fields and same check but from PAR_FSK table, for  
      FSK value. If also these fields are null or empty, then rule is not Broken. Rule is broken if planned time  
      is outside of these ranges. In Case that SperreVon is 00:00 and SperreBis is 00:00 that means that rule  
      is automatically broken, because it is locked for 24 hours for planning. Same goes with FreiVon and  
      FreiBis
    7. Period of Usage  
      Planned element have Period of Usage already defined. If planned time does not fit in any period of  
      usage time, rule Is broken.
    8. Environment  
      When we are creating campaign, we can set Content and Genre to Campaign. Later when we do  
      planning, we need to check if planned element is in right environment. So let say we have one  
      Campaign with One Episode of Game of Thrones Serie and one episode of Gold Digger series. If we  
      plan now this element in within hour and there is Serie Game of Thrones planned, planning will be  
      valid, because campaign contains Game of thrones Episode and it is valid environment “Game of  
      Thrones” environment. If we plan then on some other time slot where within hour there is no gold  
      digger or game of thrones planned, rule is broken, because environment is not valid. Same goes with  
      Genre. If we have Action Genre with Campaigns and we plan in between one hour slot, and there are  
      only Comedies planned there, rule is broken, since it is not a good environment. 
    9. Not between 2 commercial breaks  
      Rule is broken if element is planned between 2 commercial breaks.
    10. Not between 2 Programs 
      Rule is broken if we plan element in between 2 Content elements (Program, serie, sequence).
    11. Only one Trailer before Commercials  
      So only one trailer is allowed to be planned before Commercial, If we have 2 element planned, rule is  
      broken.
    12. No Scheduling between 1am and 9am 
      If an element is planned between 01:00 in night and 09:00 in morning, rule is broken