DOC-040: How to deploy platforms in InfoSys+ Kantar Media Spain 18/02/2014 INDEX 1 ABSTRACT ............................................................................................................................................. 3 2 PREPARATION OF INFOSYS+ ................................................................................................................. 4 3 CONSIDERATIONS OVER PROGRAMS AND SPOTS ................................................................................ 5 4 3.1 All Programs and Spots are broadcasted in all Region/Platform combination ........................... 5 3.2 Each Program or Spot is associated to one or more specific Region/Platform combination ..... 5 SYSINGREDIENTS .................................................................................................................................. 6 4.1 BasePlatforms ............................................................................................................................. 6 4.2 Platforms ..................................................................................................................................... 6 4.3 LinesPlatforms ............................................................................................................................ 6 4.4 ConfigPlatforms .......................................................................................................................... 7 4.5 LinesConfigPlatforms .................................................................................................................. 7 4.6 BaseSectorsBaseChannels (column CodConfigPlatform) ............................................................ 8 5 ENABLING PLATFORMS IN INFOSYS+.................................................................................................... 9 6 HISTORY .............................................................................................................................................. 10 1 ABSTRACT This is a small guide explaining the steps necessary to deploy platforms in InfoSys+. When implemented, Platforms will be added as another ingredient that you can optionally use in your templates. The platforms monitoring has to be reported within the AUyymmdd.SWD (or SWO) files produced by the data production, following the general format available at http://www.infosysplus.com/formats/Formats%20General/Audience/AU_xSWD_cDefault_with%20Plaform.pdf, or a country specific format if a development has been made in that sense in InfoSys+. 2 PREPARATION OF INFOSYS+ To use platforms with InfoSys+, some changes are necessary in the configuration. The first necessary step is to change the Country.RST Format option for SWD type to one of the propositions acepting platforms like the one shown below: Therefore, should you want to implement platforms in your configuration, please contact with InfoSys+ Support Team to have this restriction modified in your Country.RST. The second prerequisited change to deploy platforms is a change in the AU.SWD.xml file that is found in InfoSys+ Config folder. The platform tag must be added to the XML using the following node: <platform start="27" length="1" /> (in the default format, this node can differ when using a country specific format) Here’s an example of the AU.SWD file where platforms have been implemented: <?xml version="1.0" encoding="utf-8"?> <swd_fields description="New Record design of the viewing statements file"> <individual start="0" length="9" /> <household start="0" length="7" /> <hh_individual start="7" length="2" /> <channel start="9" length="4" /> <start_time start="13" length="6" /> <end_time start="19" length="6" /> <tv_set start="25" length="1" /> <activity start="26" length="1" /> <platform start="27" length="1" /> </swd_fields> 3 CONSIDERATIONS OVER PROGRAMS AND SPOTS The changes described up until now are enough for dayparts process of data containing platforms information. However, when it comes to Programs and Spots, there are two possibilities. 3.1 ALL PROGRAMS AND SPOTS ARE BROADCASTED IN ALL REGION/PLATFORM COMBINATION No additional change is required, the only step left is to implement the platforms in the sysingrediendts.mdb, as described in point 4. 3.2 EACH PROGRAM OR SPOT IS ASSOCIATED TO ONE OR MORE SPECIFIC REGION/PLATFORM COMBINATION Each Region/Platform combination is maintained in a new database, created only to this effect, called EMX.mdb that serves as a repository for each program and spot and provides InfoSys+ with the Region/Platform combinations associated to the event. This quite rare configuration needs to go through a new development request to be implemented if you so desire. Besides, it also involves some changes in the data production, as your producer would need to provide you with MX.CNV files that would fill the Transmission Matrix table of the EMX.mdb. 4 SYSINGREDIENTS Now that InfoSys+ is prepared to process data with platform, we need to define those platforms in the sysingredients.mdb. To implement them, we’ll need to update all of the following tables, in the order displayed below: 4.1 BASEPLATFORMS In this table, we define the CodPlatformBase for each platform, which must be the same ones that your data producer uses to report said platforms: Please note that the CodPlatformBase uses the same character than described in http://www.infosysplus.com/formats/Formats%20General/Audience/AU_xSWD_cDefault_with%20Plaform.pdf to represent BasePlatforms superior to 9. This convention allows for a maximum of 94 platforms, as 0 is not a usable code within InfoSys+. 4.2 PLATFORMS This table allows you to create the platform ingredients which will be selectable from the interface. CodPlatform can be the same than the CodPlatformBase, but it is not mandatory. Note that the CodUser must be set to 1 (sofres) when you create new platforms in the SysIngredients.mdb. 4.3 LINESPLATFORMS This table allows the user to link the CodPlatform from Platforms table with the CodPlatformBase from BasePlatforms table. Note that you can create compound platforms matching the same CodPlatform with different CodPlatformBase, as you can see in the screenshot below. Again, the CodUser must be set to 1 (sofres) for each line during the platform creation process. 4.4 CONFIGPLATFORMS This table allows you to create groups of platforms. Typically, you would only create one platform group as shown below: However, know that the possibility exists to group the platforms in different manners in order to associate those groups with different sectors/channels combinations, effectively creating thus sector/channel/platforms combos. If you want to do so, just create as many groups as necessary to represent the different necessary combinations of available platforms to associate each channel/sector combination with its relevant platforms. 4.5 LINESCONFIGPLATFORMS This table allows you to define the base platforms that compound each group defined in the ConfigPlatforms table. Typically, only one platform group is created and all base platforms are associated to it as depicted below: 4.6 BASESECTORSBASECHANNELS (COLUMN CODCONFIGPLATFORM) This table is used to link the base channels to the relevant base sectors. Thanks to the CodConfigPlatform, the groups of platforms created in the ConfigPlatforms table can be associated to these SectorsCchannels combinations. Typically the CodConfigPlatform will be filled with the only CodConfigPlatform present in the ConfigPlatforms table, 1: 5 ENABLING PLATFORMS IN INFOSYS+ When you’ve finished creating the platforms in the MDB, depending upon your restrictions default, you may need to enable the Platform ingredient for the Client and User groups you see fit, from InfoSys+ Control Panel. To do so, just open the Control Panel, choose Client or User groups, choose the groups to apply the change to, select the Ingredients section and choose whether they can use and/or create platforms and compound platforms: Then choose Visible data option. In the drop down list, choose Base platforms, and then click on the edition button on the right of the displayed list of platforms. You then can choose which to pass from Restricted to Allowed: Once this is done, platforms appear as a new ingredient in InfoSys+ and the list will reflect the choices you made in the restriction files. 6 HISTORY Version Author 1.0 KMSpain Date 25/02/2014 Comments Creation