Title: Third column ignored Last modified: August 24, 2016 --- # Third column ignored * Resolved [tgblack](https://wordpress.org/support/users/tgblack/) * (@tgblack) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/) * We are not specifying passwords in our CSV file. * The following lines of code ignore the third column in an import when it does not have a password: * ``` if($columns > 3){ for($i=3; $i<$columns; $i++): ``` * Example: * ``` username, email, first_name, last_name jsmith, jsmith@example.com, John, Smith jdoe, jdoe@example.com, Jane, Doe ``` * [https://wordpress.org/plugins/import-users-from-csv-with-meta/](https://wordpress.org/plugins/import-users-from-csv-with-meta/) Viewing 14 replies - 1 through 14 (of 14 total) * [chrisbitz](https://wordpress.org/support/users/chrisbitz/) * (@chrisbitz) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107527) * Funny – I have the exact problem too – and my csv file is identical to yours too.. 🙂 * Thanks for a great plugin, it’s really useful! * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107563) * Sorry for the delay answering. * I am going to see it and tell yours. * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107566) * Sorry I was on a trip and I couldn’t see it before. * The CSV format has changed, please, download the new format and tell us. * Also, deactivate the plugin and reactivate it. * [dechtman](https://wordpress.org/support/users/dechtman/) * (@dechtman) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107572) * I have the same issue. I am not sure what you mean by “The CSV format has changed” * Should I remove the plugin and try again? * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107573) * 1. You have to deactivate the plugin 2. And then activate it (to make sure you have the correct structure installed) 3. Check your CSV format, the format has changed (you can see a new example in the new version of plugin) and then, adapt your CSV to this new format * Look at the changes: * Password can be set in any column from 3rd to last * First column must be username * Second column must be user email * [dechtman](https://wordpress.org/support/users/dechtman/) * (@dechtman) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107574) * The CSV does not have the name fields in there. Can I add them? I crerated my own file with: * username, email, first_name, last_name * That is all I want to import. Everything is coming in fine except for the last name. * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107575) * Yes, but please, read “WordPress default profile data” in main page of plugin. * [dechtman](https://wordpress.org/support/users/dechtman/) * (@dechtman) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107576) * I did, but I am not sure I follow. Are you saying that I need to have all the default profile data fields in the CSV file even if they are empty? Essentially filling in the columns I need? * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107577) * No, you can use it if you want, this is not necessary. * [dechtman](https://wordpress.org/support/users/dechtman/) * (@dechtman) * [10 years, 11 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107582) * So what would the fields look like to include the first and last name? * Like this? * Username, Email, Password,Address,City, State, Zip code, Country user_url, first_name, last_name * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 10 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107587) * Exactly. * [dechtman](https://wordpress.org/support/users/dechtman/) * (@dechtman) * [10 years, 10 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107595) * So I tried that and it only pulls in the username and email only. When I performed the import it shows the First name and Last name on the import screen, but they are not populated in the user profile…I am not sure what I am doing wrong. * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 10 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107604) * Have you updated the plugin to 1.3.1 version? * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [10 years, 10 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107660) * dechtman, * I have just solved this bug in the new version. Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Third column ignored’ is closed to new replies. * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png? rev=1174343) * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/) * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq) * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/) * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/) * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/) * 14 replies * 4 participants * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/) * Last activity: [10 years, 10 months ago](https://wordpress.org/support/topic/third-column-ignored/#post-6107660) * Status: resolved