Cannot insert user without email

XAdapter Forums WordPress Users & WooCommerce Customers Import Export Cannot insert user without email

Tagged: 

This topic contains 7 replies, has 3 voices, and was last updated by Mark Mark 5 months, 1 week ago.

  • Author
    Posts
  • #70814
    arcus
    arcus
    Participant

    Hi,
    When I try to import a csv I get the error “Cannot insert user without email”
    The formatof the csv is: ID,”user_login”,”user_pass”,”user_nicename”,”user_email”,”user_url”,”user_registered”,”display_name”,”first_name”,”last_name”,”user_status”,”roles”

    Wordpress 4.9.5 / Woocommerce 3.3.5 / PHP 7.0

    thanks, Arcus

  • #70816
    Mark
    Mark
    Keymaster

    Hi,

    User email is mandatory to add users to WordPress. Kindly ensure the email address is filled in the user_email column in the importing CSV.

  • #70817
    arcus
    arcus
    Participant

    Thank you Mark,

    The thing is, there is a password …

    ID,”user_login”,”user_pass”,”user_nicename”,”user_email”,”user_url”,”user_registered”,”display_name”,”first_name”,”last_name”,”user_status”,”roles”
    200,”master”,”$password”,”master”,”arcus@xs4all.nl”,””,”2018-04-25 15:10:35″,”master”,””,””,””,”administrator”

  • #70819
    Mark
    Mark
    Keymaster

    Hi,

    Are you having any issues with the password import?

  • #70820
    arcus
    arcus
    Participant

    It’s a clean install with only one user (admin)
    When I import a .csv like above, I get the error.

    error

  • #70838
    Mark
    Mark
    Keymaster

    Hi,

    Please reach us via support with the importing CSV.

  • #75590
    Gregory
    Gregory
    Participant

    I have the same issue. Email is there and maps – and autodicsovers and shows the first line in the csv. Can you please post here any solution required / found for the OP.

    Thanks

  • #75678
    Mark
    Mark
    Keymaster

    Hi,

    The issue could be related to CSV columns not mapping correctly. Could you please share us a screenshot of your mapping screen.

You must be logged in to reply to this topic.