Export contacts.

  • If i try to export the contacts it will only have around 900/3800 people in the CSV file. Any idea why this would happen?

Viewing 1 replies (of 1 total)
  • Plugin Author Devon Ostendorf

    (@devonostendorf)

    Hi sjoerd89,

    I do not know for a fact why this would be happening, as this is the first report I’ve received about an issue with the subscriber export functionality. However, my suspicion is that it relates to PHP timing out mid-process. Which tells me I really need to re-visit the export functionality, particularly in light of the changes I made in v1.2.0 (to account for PHP timeouts in the send post notification functionality). Are you getting any web server errors displayed/logged anywhere that might provide additional context as to the root cause of the problem?

    In the meantime, I don’t suppose you have access directly to your database? Preferably via a tool like phpMyAdmin? If so, you can run the following SQL (substituting in your table prefix, if it is not the default ‘wp_’) to dump a list of all of your subscribers and the categories they are subscribed to:

    SELECT wpns.id, email_addr, first_name, cat_id FROM wp_post_notif_subscriber wpns JOIN wp_post_notif_sub_cat wpnsc ON (wpnsc.id = wpns.id) order by wpns.id;

    SELECT cat_id, name from wp_post_notif_sub_cat wpnsc JOIN wp_terms wt ON (wt.term_id = wpnsc.cat_id) order by cat_id;

    Note that those subscribed to cat_id = 0 are subscribed to “All” categories, rather than individual ones. With some Excel (or similar spreadsheet) tinkering, I hope this will get you what you’re after, until I can get a better idea of why you are only getting a partial set of your subscribers via the export process.

    Thanks,
    Devon

Viewing 1 replies (of 1 total)
  • The topic ‘Export contacts.’ is closed to new replies.