Error: File must contain at least 2 columns

  • Resolved Andrew

    (@cipes)


    8 years ago

    Hi Javier,
    Thanks for the time you’ve put into this plugin. I’m trying to import users from this CSV file. I’ve edited the file so that it starts with Username and Email as the first two columns (I just copied over WP’s default user_nicename and user_email in my CSV).

    But when I import I still get the error “File must contain at least 2 columns: username and email”. Also it does not show any data under the ‘First row represents the form of the sheet’. So my users and their meta data are not making it in.

    See this screenshot for reference.

    Any help or guidance would be greatly appreciated!

    https://wordpress.org/plugins/import-users-from-csv-with-meta/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Javier Carazo

    (@carazo)

    8 years ago

    Andrew,

    As I can see in the CSV it has serialized data and yes, it cannot be imported by this plugin.

    It also has his own ID in the file and it also cannot be used.

    You won’t be able to use this plugin to import this kind of data.

    Thread Starter Andrew

    (@cipes)

    8 years ago

    Javier,
    Thanks for your quick reply. Darn! I guess I’ll have to do it the old fashioned way with PHP MyAdmin. Unless you have any other insights or ideas from your experience?

    Plugin Author Javier Carazo

    (@carazo)

    8 years ago

    Maybe some plugin that let you synchronize users between installations.

    Or yes, a tailor-made PHP script.

    Thread Starter Andrew

    (@cipes)

    8 years ago

    I had success just manually exporting and importing the wp_usermeta() table via PHP MyAdmin.

    Take care Javier!

    Plugin Author Javier Carazo

    (@carazo)

    8 years ago

    That’s great! Thanks!

    DuffmanCC

    (@duffmancc)

    8 years ago

    What do you mean with serialized data?

    I have the same problem. One of my colums is kind of {1552, 1554 ,1686 1711 ,1763 ,1788} and I get the same error “File must contain at least 2 columns: username and email” and if I take off that column everything is fine.

    Plugin Author Javier Carazo

    (@carazo)

    8 years ago

    DuffmanCC,

    With serialized data you cannot use this plugin (not currently if someone one to support the develop, we can do it).

    Maybe with a SQL tool you can do it.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error: File must contain at least 2 columns’ is closed to new replies.