Add Swiffy html5 banner to Revive AD Server

Since Google announced that flash content will be autopause there is a tool you can use to convert Flash banners to html5, it’s called Swiffy. But the problem is the Revive server 64Kb code banner limit.

Revive AdServer problem with Swiffy banners

By default revive server stores the Code banners into rv_banners table in columns htmltemplate and htmlcache but they are TEXT columns which are limited to 64Kb which is a bit low for Swiffy banners.

I’ve decided to use MEDIUMTEXT columns which is limited to 16Mb witch is a bit more for Swiffy html5 banners but this are the options that we have.

According to MySQL documentation:

      Type | Maximum length
-----------+-------------------------------------
  TINYTEXT |           255 (2 8−1) bytes
      TEXT |        65,535 (216−1) bytes = 64 KiB
MEDIUMTEXT |    16,777,215 (224−1) bytes = 16 MiB
  LONGTEXT | 4,294,967,295 (232−1) bytes =  4 GiB

revive-banners-default

Revive AdServer modifications

I’ve made this change on my servers and I don’t see any problems so far. If you want to use command line you can alter the columns with this command:

ALTER TABLE `rv_banners` CHANGE `htmltemplate` `htmltemplate` MEDIUMTEXT;
ALTER TABLE `rv_banners` CHANGE `htmlcache` `htmlcache` MEDIUMTEXT;

Or if you are using PHPMyAdmin go to rv_banners table, click on Structure and Change on htmltemplate and htmlcache

revive-srtucture-change

Then change Type from TEXT to MEDIUMTEXT

revive-type-mediumtext

Create Swiffy html5 banners

Go to Googles Swiffy Upload page and convert your Flash banners into Swiffy html5 banners, then open the html code and paste it into Revive AdServer as Generic HTML Banner

Revive AdServer: http://www.revive-adserver.com/
Google Swiffyhttps://developers.google.com/swiffy/convert/upload

Nikola Stojanoski

System Administrator and Developer. Giving back to the community by blogging about my problems, solutions and practical howto's.