Custom user fields import to post_meta table

  • Resolved kengholm

    (@kengholm)


    7 years, 2 months ago

    I’ve been trying to import users from an old mySQL database using WP Ultimate CSV Import (free) but none of the mapped custom fields showed up in my user_meta table so that data wasn’t available to my membership plugin or user directories, etc. I was also unsuccessful with the provided Sample CSV Users file. FINALLY, I found all the missing user data in the post_meta table, though I always selected “Import each record as USERS”.
    Is this expected behavior? If not, how to I fix it? If so, how do I get Ultimate Member plugin to look for user data in the post_meta table?
    Thank you.
    Kathy

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter kengholm

    (@kengholm)

    7 years, 1 month ago

    I gave up on “Ultimate CSV Import” and am VERY happy with “Import Users from CSV” plugin. You have to do more of the prep and field compatibility adjustments directly on the CSV file (such as changing field names to match your WP meta keys), but that’s so easy and transparent in Excel or any typical spreadsheet app that I found it easier than using the field assignment feature in Ultimate CSV Import.

    Plugin Contributor Smackcoders Support

    (@smacksupport)

    7 years, 1 month ago

    Hi Kengholm,

    WP Ultimate CSV Importer needs the CSV headers to be matched on the same name as the WP fields just to get it auto mapped during the mapping section. You can have your own names on the CSV, you just have to choose Users on the Import section and map the fields to corresponding WP User fields. It will be imported as Users without any problem.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom user fields import to post_meta table’ is closed to new replies.