WordPress WP Forms CSV import for entries

Import entries from CSV files in WP Forms.

To import CSV entries into WP Forms, you can use the wpsnippets_import_wpforms_entries() function provided below. This function takes a CSV file path as a parameter and imports the entries into a specified WP Forms form.

function wpsnippets_import_wpforms_entries( $csv_file_path, $form_id ) {
    if ( ! file_exists( $csv_file_path ) ) {
        return;
    }

    $csv_data = array_map( 'str_getcsv', file( $csv_file_path ) );
    $csv_headers = array_shift( $csv_data );

    foreach ( $csv_data as $entry ) {
        $entry_data = array_combine( $csv_headers, $entry );

        $form_entry = array(
            'fields' => array(),
        );

        foreach ( $entry_data as $field_name => $field_value ) {
            $form_entry['fields'][] = array(
                'id'    => wpforms()->fields->get_field_id_by_key( $field_name, $form_id ),
                'value' => $field_value,
            );
        }

        wpforms()->entry->add( $form_entry, $form_id );
    }
}

To use this function, you need to provide the CSV file path and the form ID to which you want to import the entries. The function reads the CSV file, maps the headers to the entry data, and then creates a new entry for each row in the CSV file.

Here’s an example of how to use the wpsnippets_import_wpforms_entries() function:

$csv_file_path = '/path/to/entries.csv';
$form_id = 123; // Replace with your actual form ID

wpsnippets_import_wpforms_entries( $csv_file_path, $form_id );

Make sure to replace /path/to/entries.csv with the actual path to your CSV file, and 123 with the actual form ID you want to import the entries into.

This code snippet can be useful when you have a large number of entries that you want to import into WP Forms from a CSV file. It saves you from manually entering each entry one by one, making the process more efficient and less prone to errors.

Examples

Example 1: Importing WP Forms CSV entries using built-in WordPress functions

This example demonstrates how to import WP Forms CSV entries using built-in WordPress functions. The code uses the wp_insert_post() function to create a new post for each CSV entry, and then uses the update_post_meta() function to save the form data as post meta.

function wpsnippets_import_wpforms_entries( $csv_file_path ) {
    if ( ( $handle = fopen( $csv_file_path, 'r' ) ) !== false ) {
        while ( ( $data = fgetcsv( $handle ) ) !== false ) {
            $post_id = wp_insert_post( array(
                'post_title'   => $data[0],
                'post_content' => $data[1],
                'post_type'    => 'wpforms_entries',
                'post_status'  => 'publish',
            ) );

            if ( $post_id ) {
                update_post_meta( $post_id, 'form_data', $data[2] );
            }
        }
        fclose( $handle );
    }
}

The wpsnippets_import_wpforms_entries() function takes the path to a CSV file as a parameter. It reads the CSV file using fopen() and fgetcsv() functions, and then uses the wp_insert_post() function to create a new post for each entry. The form data is saved as post meta using the update_post_meta() function.

Example 2: Importing WP Forms CSV entries using WPForms API

This example demonstrates how to import WP Forms CSV entries using the WPForms API. The code uses the wpforms()->entry->add() method to add each CSV entry to WP Forms.

function wpsnippets_import_wpforms_entries( $csv_file_path ) {
    if ( ( $handle = fopen( $csv_file_path, 'r' ) ) !== false ) {
        while ( ( $data = fgetcsv( $handle ) ) !== false ) {
            $entry_data = array(
                'fields' => array(
                    array(
                        'id'    => 1, // Replace with the actual field ID
                        'value' => $data[0],
                    ),
                    array(
                        'id'    => 2, // Replace with the actual field ID
                        'value' => $data[1],
                    ),
                ),
            );

            wpforms()->entry->add( $entry_data );
        }
        fclose( $handle );
    }
}

The wpsnippets_import_wpforms_entries() function takes the path to a CSV file as a parameter. It reads the CSV file using fopen() and fgetcsv() functions, and then creates an array of entry data for each CSV entry. The wpforms()->entry->add() method is used to add each entry to WP Forms.

Example 3: Importing WP Forms CSV entries using a custom SQL query

This example demonstrates how to import WP Forms CSV entries using a custom SQL query. The code uses the wpdb class to execute the SQL query and insert each CSV entry into the database.

function wpsnippets_import_wpforms_entries( $csv_file_path ) {
    global $wpdb;

    if ( ( $handle = fopen( $csv_file_path, 'r' ) ) !== false ) {
        while ( ( $data = fgetcsv( $handle ) ) !== false ) {
            $wpdb->insert(
                $wpdb->prefix . 'wpforms_entries',
                array(
                    'field1' => $data[0],
                    'field2' => $data[1],
                )
            );
        }
        fclose( $handle );
    }
}

The wpsnippets_import_wpforms_entries() function takes the path to a CSV file as a parameter. It reads the CSV file using fopen() and fgetcsv() functions, and then uses the $wpdb->insert() method to insert each CSV entry into the wpforms_entries table. The field names and values are specified in the array passed to the insert() method.