WordPress - WP Post Views Counter plugin - import data from Yuzo Related Posts How to import the view count data of each existing post from Yuzo Related Posts to WP Post Views Counter WordPress Plugin

How to automatically set File System Permissions for a WordPress Web Server with a BASH Script

Today a friend asked me to uninstall the Yuzo Related Post plugin from her WordPress blog because she want to switch to the Jetpack built-in "related posts" feature. She could perform the task by herself, but she also wanted to keep the post view counters for all their posts - an additional feature provided by Yuzo - which would be lost otherwise.

She found a great replacement plugin to handle the post view counting task: the awesome WP Post Views Counter: however, the new plugin doesn't have a built-in feature to import the data collected by Yuzo.

That's why she called me, hoping that I could be help her with such importing/transfering feature.

The first thing I did was comparing the two tables used by the plugins to host their data.

The Yuzo Related Posts table is called wp_yuzoviews and has the following structure:

Field Type Info
ID int (11) NOT NULL
post_id int(15) NOT NULL
views int(14) NOT NULL
last_viewed datetime NOT NULL
modified int(12) NULL

The WP Post Views table is called wp_post_views and has the following structure:

Field Type Info
id bigint (20) NOT NULL
type tinyint(1) NOT NULL
period varchar(8) NOT NULL
count bigint(20) NOT NULL

The main differences between the two approaches is that Yuzo Related Posts hosts a single record per post/page, while WP Post Views creates 4 records per post, each one with a different type: each record type hosts a dedicated counter so that the plugin can keep track of each post's views for each and every day, month, year and, of course, the overall total.

Unfortunately, as we can clearly see, there's no way to import all these detailed data from the Yuzo table, since it only keep track of the total views. The only thing I could do was transfer the total post data with the following query:

Once done, all the usable data collected by Yuzo could be also seen by WP Post Views.

 

About Ryan

IT Project Manager, Web Interface Architect and Lead Developer for many high-traffic web sites & services hosted in Italy and Europe. Since 2010 it's also a lead designer for many App and games for Android, iOS and Windows Phone mobile devices for a number of italian companies. Microsoft MVP for Development Technologies since 2018.

View all posts by Ryan

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.

This site uses Akismet to reduce spam. Learn how your comment data is processed.