Support » Plugin: Top 10 - Popular posts plugin for WordPress » Import Data from WordPress Popular Posts

  • Hello,

    Is it possible to import my popular data from the WordPress Popular Posts plugin?

    Thanks,

    A Jorge

Viewing 1 replies (of 1 total)
  • Plugin Author Ajay

    (@ajay)

    From what I can see WPP has two tables summary and data. I don’t have the exact data that the plugin stores, but you could try the following query to track the overall posts. You’ll need Top 10 to track the daily views.

    Please backup your database before you try anything. This is to be run after Top 10 was activated.

    
    INSERT INTO wp_top_ten (postnumber,cntaccess,blog_id) 
        SELECT postid,pageviews,1 FROM wp_popularpostsdata
    

    and this might work for daily

    
    INSERT INTO wp_top_ten_daily (postnumber,cntaccess,dp_date,blog_id) 
        SELECT postid,pageviews,view_datetime,1 FROM wp_popularpostssummary
    
Viewing 1 replies (of 1 total)
  • The topic ‘Import Data from WordPress Popular Posts’ is closed to new replies.