WordPress.org

Ready to get started?Download WordPress

Forums

WP SlimStat
[resolved] Importing Data from "count per day" plugin (4 posts)

  1. tempor
    Member
    Posted 3 years ago #

    Hi,

    is there a way to import stat data from other stat plugins (like count per day)?

    Thanks

    http://wordpress.org/extend/plugins/wp-slimstat/

  2. camu
    Member
    Plugin Author

    Posted 3 years ago #

    What other plugins are we talking about here? In general, however, the answer is no. Because WP SlimStat needs much more information that what most other plugins can collect. Plus the DB structure is typically different, so you would have to write an importer yourself.

    Camu

  3. tempor
    Member
    Posted 3 years ago #

    Hi,

    but I was thinking of writing an importer myself. I was asking for some guidelines concerning your DB ways to do that.

    Anyway thanks.

  4. camu
    Member
    Plugin Author

    Posted 3 years ago #

    Hi there,

    sorry for the misunderstanding. That would be awesome, indeed. Okay, I took a look at Count per Day's DB structure, and the information it collects is a subset of what is needed by WP SlimStat. You would be able to write an importer, but some fields would be empty, thus distorting the stats generated by WP SlimStat.

    Count per day, for example, groups all the 'archive' pages (monthly archives, search pages, etc) as a common category (with ID = 0), and it does the same for all the categories and tags. Also it does not differentiate between visits and visitors, does not keep track of screen resolutions, browser version, extensions etc.

    Having said this, here's the mapping (assuming you have wp_cpd_counter and wp_slim_stats, wp_slim_browsers):

    • cpd_counter.ip -> wp_slim_stats.ip
    • cpd_counter.client -> wp_slim_browsers.browser + wp_slim_browsers.version + wp_slim_browsers.platform + wp_slim_browsers.css_version(would have to be parsed with browscap.php to get all the information)
    • cpd_counter.date -> wp_slim_stats.dt
    • cpd_counter.page -> lossy process, but with some work could be associated to posts and pages' URLs (wp_slim_stats.resource)
    • cpd_counter.referer -> wp_slim_stats.referer

    Its other tables contain information that is not used by WP SlimStat. Please feel free to contact me on my support forum if you have any questions! Thank you for doing this.

    Camu

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic