Export All Site

Discussion in 'General Help' started by softdevsalon, May 8, 2019.

  1. softdevsalon
    • Licensed

    softdevsalon Member

    Is there a way to export all site registered with this format

    SITENAME-CATEGORY-TOT_PV_OVERALL-ALEXA-RANK

    What to do?
  2. Basti
    • Staff

    Basti Administrator Staff Member

    Not with visiolist itself, no. We only export full sql in admin.

    Also not using phpmyadmin, since it only does exports using columns from same table ( not cross table like you need ) as far as i know.
    For that you need to write a custom mysql dump/export php script

    May i ask for what reason you only need those values?
  3. softdevsalon
    • Licensed

    softdevsalon Member

    Because I want to get all the data every month, because we have ranking per month who is the best site on this month.
  4. Basti
    • Staff

    Basti Administrator Staff Member

    Just had a look in phpmyadmin, and notices, actually you can export quite easily there

    So go to phpmyadmin -> select your database -> click the "SQL" tab
    In there you paste
    Code:
    SELECT title, category, tot_pv_overall, alexa_rank FROM VL_sites sites, VL_stats stats WHERE sites.username = stats.username
    When you run that code, it shows you the results sets, below that results you have a link called "Export".
    Click that and will just export what you selected with your query ( you can csv or whatever you need )
    Mark likes this.
  5. softdevsalon
    • Licensed

    softdevsalon Member

    AWESOME! Thank you.
    Mark likes this.

Share This Page