Title: Countries import documentation
Last modified: February 26, 2018

---

# Countries import documentation

 *  Resolved [Ambyomoron](https://wordpress.org/support/users/josiah-s-carberry/)
 * (@josiah-s-carberry)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/countries-import-documentation/)
 * It would be nice to get some documentation for the new import countries from 
   csv file. I created a csv file using the same column names as the names in the
   database (which is not quite the same as the names displayed on screen), and 
   was told that the import failed because of a missing mandatory column. In the
   code, that column is apparently called ‘code’, but there is no explanation of
   what ‘code’ refers to.

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10016697)
 * You’re correct, I’ll try to update the doc today.
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10016834)
 * Doc added:
    [http://www.e-dynamics.be/wordpress/csv-import-countries-states/](http://www.e-dynamics.be/wordpress/csv-import-countries-states/)
 * Also: you bumped on a bug that’s fixed here:
    [https://plugins.trac.wordpress.org/changeset/1829497/](https://plugins.trac.wordpress.org/changeset/1829497/)
 *  Thread Starter [Ambyomoron](https://wordpress.org/support/users/josiah-s-carberry/)
 * (@josiah-s-carberry)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10016963)
 * Thank you. That works now.
 * You might edit your statement:
 * There are 3 columns required: “name”,”alpha_2″.
 * Should it be “2 columns”, or is there a third required column?
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10017290)
 * You’re correct, only 2 are required, doc changed.
 *  [budasy](https://wordpress.org/support/users/budasy/)
 * (@budasy)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10545777)
 * Hi,
    I’ve just had a lot of trouble getting countries loaded. It would help a
   lot if the simple instructions were given on the page above the “import countries”
   button. That’s where it’s needed.
 * I dug into the code. That showed me that headers could be name, alpha_2, alpha_3,
   num_3 and locale. Unfortunately using those names didn’t work.
 * The documentation above says that the numeric id column should be num3. That 
   isn’t consistent with the other column names and it’s not what I saw in the code.
 * I believe that the problems that I was having was that I was preparing the CSV
   file on a Macintosh and it was using carriage return ( ascii 13 ) as the line
   delimiter. When I converted to line feed ( ascii 10 ) the import succeeded.
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10546351)
 * The import doc can be found in the documentation: [https://www.e-dynamics.be/wordpress/category/documentation/19-csv-import/csv-import-countries-states/](https://www.e-dynamics.be/wordpress/category/documentation/19-csv-import/csv-import-countries-states/)
   
   I’ll take a look to linking it on the form and maybe also mention the line ending.
   Concerning the line endiy, read the remark about Macintosh here: [http://php.net/manual/en/function.fgetcsv.php](http://php.net/manual/en/function.fgetcsv.php)

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Countries import documentation’ is closed to new replies.

 * ![](https://ps.w.org/events-made-easy/assets/icon-256x256.png?rev=1856035)
 * [Events Made Easy](https://wordpress.org/plugins/events-made-easy/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-made-easy/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-made-easy/)
 * [Active Topics](https://wordpress.org/support/plugin/events-made-easy/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-made-easy/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-made-easy/reviews/)

 * 6 replies
 * 3 participants
 * Last reply from: [Franky](https://wordpress.org/support/users/liedekef/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/countries-import-documentation/#post-10546351)
 * Status: resolved