sagehalo

For any of those who have the same problem i did, i am posting my email conversation with Web Toffee support, who were brilliant and help me resolve the issue:

(WebToffee) I have gone through the file you shared [copy] and noticed that the delimiter and format of the file have changed [from the orginal]. This might have happened when you tried to modify the file with your spreadsheet application. Since the file delimiter and format changed, the columns failed to auto-map, and as a result, the comments failed to import. The spreadsheet application you are using to edit the CSV file might be changing the file delimiter and encoding when saving the file. Please try using a spreadsheet application like LibreOffice to edit the CSV file which has proven to be better in handling CSV files in our experience.

(Me) I used Libre Office instead of Open Office, saved the copy file as a csv text file not an ODF file and entered the correct delimiter character when uploading the csv file using the plugin and it worked perfectly.

Hi there the Wetransfer has expired, here is a link to the csv files in dropbox:https://www.dropbox.com/s/2afm81k16j29ovx/WP%20CSV.zip?dl=0

Thank you so much for your help. Here is a link to the original csv that i downloaded using the plugin and a ‘copy’ which is the one that i edited using Open Office: https://tinyurl.com/3zjsumh8 Thanks again, i really appreciate it!

Hi Web Toffee. I’m not sure if you saw my last comment? Could you help? Thank you.

Thank you for your help. I managed to sucessfully export the csv with the page details using the code snippet plugin, i could see the page name “Testimonials” in the csv file. I found the page/post id of the new destination page: https://ibb.co/RvqJ8GV and changed the id in the csv file: https://ibb.co/vv0nB6x.

I then used the same code snippet plugin to add

add_filter('wt_cmt_imp_post_exists_query', 'wt_cmt_imp_post_exists_query');

function wt_cmt_imp_post_exists_query($query) {
    global $wpdb;
    $query = "SELECT ID FROM $wpdb->posts WHERE ID = %d AND (post_type='post' OR post_type='page')";
    return $query;
}

to the new site. But when i tried to import the csv file i got an error ‘not parsed’ https://ibb.co/jbnZt8S

Can you help me figured out what went wrong?

Thank you.

Ok cool, thank you Dan. And thank you for makin such a great plugin for free, much appreciated!

Ok great, thank you Dan. So would you suggest that it is better to create shipping rules in the ‘shipping zones’ tab rather than the ‘weight based shipping’ tab?

Aha, i see. Sorry for the confusion, i didn’t understood what was going on from your communication.

Thank you for your help though, much appreciated.

I’m sorry, I don’t know why this has been marked resolved, as it hasn’t been resolved, I still have the problem.

SendGrid states that it was ‘Not Delivered’

Here are a couple of screenshots of what is going on:

SENDGRID ACTIVITY FEED:

https://www.dropbox.com/s/3804d72dewyxdz2/sg.jpg?dl=0

WP MAIL LOGGING LOG

https://www.dropbox.com/s/2j06828rh1kvbql/wpm.jpg?dl=0

To recap, i set up your plugin to the letter, sent a test email with your plugin. WP Mail Log plugin says it left my site, SendGrid recognises it was sent, but did not deliver it to the email address used in the ‘send to’ field of ‘Send a test email’.

Sorry i didn’t explain, i didn’t actually get the test email.

Thank you so much Laurena! I will check this out.

I have the same problem.

Thank you! But I was hoping that a solution could be found that didn’t involve any cost.

Best wishes.