WordPress.org

Ready to get started?Download WordPress

Forums

BFT Autoresponder and Newsletter
[resolved] [closed] Deleting an imported CSV file (10 posts)

  1. MLHCo
    Member
    Posted 6 months ago #

    What file do you delete in the WordPress install to remove just the imported CSV addresses?

    http://wordpress.org/plugins/bft-autoresponder/

  2. prasunsen
    Member
    Plugin Author

    Posted 6 months ago #

    The addresses are in the database, you can't delete them by deleting a file. You can go to phpMyAdmin to delete them there.

  3. Peter Butschek
    Member
    Posted 3 months ago #

    I went to phpmyadmin but cannot figure out what to alter to delete the csv imported addresses...

    What exactly do I need to do?

    Thanks much and Merry Christmas !

  4. prasunsen
    Member
    Plugin Author

    Posted 3 months ago #

    Find table wp_bft_users, go to SQL and run

    TRUNCATE TABLE wp_bft_users;

    Note that this will delete ALL subscribers. If you want to delete only the imported ones you need to know the date when they were imported and run something like:

    DELETE FROM wp_bft_users WHERE date='2013-12-27'

  5. Peter Butschek
    Member
    Posted 3 months ago #

    Ok.... Thanks for the explanation. The reason I asked is that I had a small list of 500 people and then I imported 500 more from another list and forgot to change the columns. Now I have 500 that need to be deleted and am doing it one by one.... :-)

    To bad I was testing this out importing both sets on the same day... :-)

    Is there a better way to fix this error without resending all mails to everyone by deleting and reimporting everyone?

  6. prasunsen
    Member
    Plugin Author

    Posted 3 months ago #

    OK, here's another way. Find the first email in the imported file. Go to phpmyadmin, table wp_bft_users and search for it. Not the "id" field number. Let's for example say it's 501. Assuming 501, run the following query:

    DELETE FROM wp_bft_users WHERE id > 501;

  7. Peter Butschek
    Member
    Posted 3 months ago #

    Hmmmm.... I'm sorry but I do not understand what you are instructing me to do. I am not experienced in working in this area but am learning.

    Here's a thought. I went to phpmyadmin and found table wp_bft_users and "viewed" id. I then clicked on the email table and exported it to a excel csv file. This file contains about 8 columns of stuff. I was able to delete all the "names" rows from the "email" column rather quickly and now have just the emails in my csv file. Looking good...

    But... I have not imported it back yet as I'm not sure of the settings to use when I look at the import screen in phpmyadmin. I think I import it as a "csv" ";" delimited file? Hmmm...

    Worst case scenario ? If I screw this import up in phpmyadmin than the best option would be to empty the table and then reimport back in wordpress BFT Autoresponder and live with the restarting of the email sequence for everyone?

    I hope this makes some kind of sense to you... and I do appreciate you patience and help.

  8. prasunsen
    Member
    Plugin Author

    Posted 3 months ago #

    Um, sorry, hard to follow what you are doing. My idea was to delete the unnecessary data right into the DB table (in phpMyAdmin) rather than exporting anything. But to know which is the first wrongly imported address you need to look into that old file that you imported before.

  9. Peter Butschek
    Member
    Posted 3 months ago #

    Sorry I don't speak the techno language too well.... I went back in and looked at the tables again and figured out how to mass delete the addresses I needed to get rid of.

    Again... Thanks for your help and patience and I'll wait for my trial newsletters to complete the cycle and will upgrade my free BFT Plug In.

    Is there any chance you will be offering a January special on the $87.00 Pro offer ???

    Happy New Year To You Coming Up...

    Pete.

  10. prasunsen
    Member
    Plugin Author

    Posted 3 months ago #

    Please contact me by email and I'll ensure you'll get a discount :) We are not allowed to discuss pro versions here so please use the email for any questions.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic