This response is for documentation:
The structure of the csv file is problematic for a lot of people. Here is an explanation of how to properly structure your csv file to work optimally with this plugin:
It’s really very simple. If I have three fields Name, Email, Address Then I have to list them on the first line by their titles, separated by commas:
Name,Email,Address
I don’t typically use spaces after the commas in the final product but you can.
Then I put double quotes around each field:
“Name”,”Email”,”Address”
The same goes for the actual values. The only thing to remember and take note of is the structure of the various fields. For instance the address field is made up of 6 sections: address 1, address 2, city, state, zip, country and if a field is not to be populated you still have to keep the commas. So a good way to keep track of this is to begin with your double quotes for the first row of entries beneath the header:
“”,””,””
This is the root structure for an entry. If an entry is left blank, you still need this structure. For instance If Name and Address were populated but email was not, you would do this:
“{Name here}”,””,”{Address here}”
So, then to make sure you have the structures correct you would go from the root to the structure:
“{F Name},{L Name}”,”{Val}”,”{address 1,address 2,city,state,zip,country}”
This is the basic structure of your first row. Now just fill in the blanks and remove the {} after your done doing so. Let’s fill in the name field:
“Aryan,Duntley”,”{Val}”,”{address 1, address 2, city, state, zip, country}”
Now, lets fill in the email:
“Aryan,Duntley”,”[email protected]”,”{address 1,address 2,city,state,zip,country}”
Now let’s fill in the address, but we’ll not include a zip code or a country. To do this we would fill in the address like so:
“Aryan,Duntley”,”[email protected]”,”123 fake street,appt #2,San Diego,CA,zip,country”
Now, we still have zip and country place holder text in there so we will remove those, making sure the commas stay in place:
“Aryan,Duntley”,”[email protected]”,”123 fake street,appt #2,San Diego,CA,,”
This would be our first row entry after the headers:
“Aryan,Duntley”,”[email protected]”,”123 fake street,appt #2,San Diego,CA,,”