Custom meta fields not imported

@ Age

Glancing at the code and everything appears correct. Could you please attach a sample CSV file so I can take a look and give a quick test?

@ Age

You should see a new update for CSV Import, please update and change the code snippet to this code to make it compatible with 2.0:

add_filter( 'cncsv_map_import_fields', 'cncsv_import_meta_fields_options' );
function cncsv_import_meta_fields_options( $fields ) {

    $fields['member_nobnummer']          = 'Membership | NOB-nummer';
    $fields['member_noodcontactpersoon'] = 'Membership | Naam contactpersoon bij nood';
    $fields['member_hoogsteduikbrevet']  = 'Membership | Hoogste duikbrevet';
    $fields['member_soortlidmaatschap']  = 'Membership | Soort lidmaatschap';
    $fields['member_instructeur']        = 'Membership | Instructeur';
    $fields['member_instructeursnummer'] = 'Membership | Instructeursnummer';

    return $fields;
}

add_action( 'cncsv_import_fields', 'cncsv_import_meta_fields_import', 10, 3 );
function cncsv_import_meta_fields_import( $id, $row, $entry ) {

    $nobnummer          = $entry->arrayPull( $row, 'member_nobnummer', '' );
    $noodcontactpersoon = $entry->arrayPull( $row, 'member_noodcontactpersoon', '' );
    $hoogsteduikbrevet  = $entry->arrayPull( $row, 'member_hoogsteduikbrevet', '' );
    $soortlidmaatschap  = $entry->arrayPull( $row, 'member_soortlidmaatschap', '' );
    $instructeur        = $entry->arrayPull( $row, 'member_instructeur', '' );
    $instructeursnummer = $entry->arrayPull( $row, 'member_instructeursnummer', '' );

    $meta = array(
        array(
            'key'   => 'NOB-Relatienummer',
            'value' => $nobnummer
        ),
        array(
            'key'   => 'Naam contactpersoon bij nood',
            'value' => $noodcontactpersoon
        ),
        array(
            'key'   => 'Hoogste duikbrevet',
            'value' => $hoogsteduikbrevet
        ),
        array(
            'key'   => 'Soort lidmaatschap',
            'value' => $soortlidmaatschap
        ),
        array(
            'key'   => 'Instructeur',
            'value' => $instructeur
        ),
        array(
            'key'   => 'Instructeursnummer',
            'value' => $instructeursnummer
        )
    );

    cnEntry_Action::meta(
        'update',
        $id,
        $meta
    );
}

Hope this helps, let me know!

@ Age

Yes, it is possible. But, I have not worked out the code to do so. I think it would be pretty straightforward…

You would use the cncsv_map_import_fields filter to add the Certifications field mapping choice to the drop down.

You would also use the cncsv_import_fields to register the callback to import the Certifications. Much like importing the meta code.

The code within the function would be nearly identical to the code in the file class.cncsv-entry.php file in the processTerms() method around line 518. This file is part of the Connections CSV Import extension.

Off the top, the only changes would be changing the taxonomy from category to certification and the elseif to add the default could be removed since it is not required.

Something like this (untested):

add_filter( 'cncsv_map_import_fields', 'cncsv_import_certifications_field_option' );
function cncsv_import_certifications_field_option( $fields ) {

    $fields['certifications'] = 'Certifications';

    return $fields;
}

add_action( 'cncsv_import_fields', 'cncsv_import_certification_field_import', 10, 3 );
function cncsv_import_certification_field_import( $id, $row, $entry ) {

    $termIDs = array();

    $parsed = $entry->arrayPull( $row, 'certification', $termIDs );

    if ( ! empty( $parsed ) ) {

        /*
         * Convert the supplied certifications to an array and sanitize.
         * Apply the same filters added to the core WP default filters for `pre_term_name` so the certification name
         * will return a match if it exists.
         */
        $certifications = explode( ',', $parsed );
        $certifications = array_map( 'sanitize_text_field', $certifications );
        $certifications = array_map( 'wp_filter_kses', $certifications );
        $certifications = array_map( '_wp_specialchars', $certifications );

        foreach ( $certifications as $certification ) {

            // Query the db for the term to be added.
            $term = cnTerm::getBy( 'name', $certification, 'certification' );

            if ( $term instanceof cnTerm_Object ) {

                $termIDs[] = $term->term_id;

            } else {

                // Add the new certification.
                $insert_result = cnTerm::insert( $certification, 'certification', array( 'slug' => '', 'parent' => '0', 'description' => '' ) );

                if ( ! is_wp_error( $insert_result ) ) {

                    $termIDs[] = $insert_result['term_id'];
                }
            }
        }

    }

    // Do not set certification relationships if $termIDs is empty because if updating, it will delete existing relationships.
    if ( ! empty( $termIDs ) ) Connections_Directory()->term->setTermRelationships( $id, $termIDs, 'certification' );

}

• This reply was modified 8 years, 1 month ago by Steven Zahm. Reason: Code corrections

@ Age

You could add this particular code to using the Code Snippets plugin. That way you do not have to edit the plugin directly and if it does not work you can deactivate it.