Export comments from a ‘Page’

  • Resolved sagehalo

    (@sagehalo)


    3 years, 5 months ago

    Hi there.

    I am trying to export comments from a wordpress ‘page’ (not post) on a site built using Divi. But when i try the first step in the instructions here: https://ww.wp.xz.cn/support/topic/exporting-pages-2/ to add the following code to the functions.php: 

    add_filter('product_Comments_csv_product_export_args', 'wtproduct_Comments_csv_product_export_args');
function wtproduct_Comments_csv_product_export_args($args){
    if(isset($args['post_type']) && $args['post_type'] == 'Post'){
        $args['post_type'] = 'Post,page'; 
    }
    return $args;
}

    i get the msg “Scrape key check failed. Please try again.”

    Can anyone help?

    Thank you

    • This topic was modified 3 years, 5 months ago by sagehalo.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support WebToffee Support

    (@webtoffeesupport)

    3 years, 5 months ago

    Hi @sagehalo,

    Thanks for getting in touch with us.

    The error message that you are getting seems to be due some issues with editing and saving the active theme. Please refer here: https://ww.wp.xz.cn/support/topic/fix-wordpress-theme-editor-scrape-key-check-failed-error/

    You can try using a code snippet plugin to add code snippet on your site instead of editing the theme file.

    Thread Starter sagehalo

    (@sagehalo)

    3 years, 5 months ago

    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.

    Thread Starter sagehalo

    (@sagehalo)

    3 years, 4 months ago

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

    Plugin Support WebToffee Support

    (@webtoffeesupport)

    3 years, 4 months ago

    Hi @sagehalo,

    Sorry for the delay in our response.

    Can you please share the CSV file that you are trying to import so that we can check it? You can share the CSV by uploading it to Google Drive or WeTransfer or any similar service and sharing the link. Or else, you can share it via support and mention this support thread URL when submitting the ticket.

    Thread Starter sagehalo

    (@sagehalo)

    3 years, 4 months ago

    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!

    Thread Starter sagehalo

    (@sagehalo)

    3 years, 4 months ago

    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

    Thread Starter sagehalo

    (@sagehalo)

    3 years, 3 months ago

    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.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Export comments from a ‘Page’’ is closed to new replies.