Exporting subscribers

Hi,

I have hundreds of subscribers to my blog with the help of "Subscribe by Email" , but what if I want to download the user database, so i can use it also in another service.

Lets say i want to mail my subscribers, but i dont want to create a post for that.

Is it possible to export the users?

  • DavidM
    • DEV MAN’s Mascot

    Hi adalid,

    There's not an option for exporting within the plugin interface but you can export the data from the database. If you take a look at the sql.txt file in the plugin folder, you'll see the following regarding the database table and structure used by the plugin:

    CREATE TABLE'wp_x_subscriptions' (
      'subscription_ID' bigint(20) unsigned NOT NULL auto_increment,
      'subscription_email' TEXT NOT NULL,
      'subscription_type' varchar(200) NOT NULL,
      'subscription_created' bigint(20) NOT NULL,
      'subscription_note' varchar(200) NOT NULL,
      PRIMARY KEY  ('subscription_ID')
    ) ENGINE=MyISAM;

    You could easily export that data into various formats from phpMyAdmin.

    Hope that helps!

    -David

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.