[sebastien xtrem]

Hi

Do you have basic solution for remove all entry before update

Thanks

[Steven Zahm]

@ sebastien

Sorry, but I am not certain what you are asking. Could you please provide more details?

[sebastien xtrem]

HI

how are you

Do you have soluttion for remoel all entry after import by exemple

Because if I need remove is very long because 1700 entry and I wand import clean entry by csv

Thnaks

[Steven Zahm]

@ sebastien

There is a way but there is not a point and click way of doing this. Here’s how:

• Install the Code Snippets plugin.
• Add a new snippet with the following code.
• Save and Active the code snippet with the Only run once option selected.
• After the snippet runs all the data from Connections will be erased. *This operation can not be undone. Use with caution. This snippet can be run any time you wish to delete all the Connections data.

code snippet

add_action( 'plugins_loaded', 'cn_empty_tables' );

function cn_empty_tables() {
    global $wpdb;

    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_ADDRESS_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_PHONE_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_EMAIL_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_MESSENGER_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_SOCIAL_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_LINK_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_DATE_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_TABLE_META );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERM_RELATIONSHIP_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERMS_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERM_TAXONOMY_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERM_META_TABLE );

}

Hope this helps!

• This reply was modified 7 years, 6 months ago by Steven Zahm.

[Author]

Posts