{"id":156,"date":"2018-06-29T22:52:16","date_gmt":"2018-06-29T22:52:16","guid":{"rendered":"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/settings\/import-export\/"},"modified":"2020-02-19T14:52:14","modified_gmt":"2020-02-19T14:52:14","slug":"import-export","status":"publish","type":"docs","link":"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/settings\/import-export\/","title":{"rendered":"Import \/ Export"},"content":{"rendered":"<p><span class=\"bookmark-index\"><br \/>\n<a href=\"#listings\">Listings<\/a><br \/>\n<a href=\"#categories\">Categories<\/a><br \/>\n<a href=\"#reviews\">Reviews<\/a><br \/>\n<a href=\"#settings\">Settings<\/a><br \/>\n<a href=\"#faq\">FAQ<\/a><br \/>\n<\/span><\/p>\n<h3><a href=\"#listings\" name=\"listings\">Listings<\/a><\/h3>\n<h4>Listings: Import CSV<\/h4>\n<p>Configure the options for the import of a CSV of listings.<\/p>\n<ul>\n<li><strong>Update listing if post ID already exists.<\/strong><\/li>\n<\/ul>\n<p>Listings will be updated if the post ID already exists.<\/p>\n<ul>\n<li><strong>Ignore listing if post ID already exists.<\/strong><\/li>\n<\/ul>\n<p>Listing updates will be skipped if the post ID already exists.<\/p>\n<ul>\n<li><strong>Select and Upload CSV<\/strong><\/li>\n<\/ul>\n<p>Choose a CSV from your local file system, then confirm the upload of the CSV.<\/p>\n<ul>\n<li><strong>Download Sample CSV<\/strong><\/li>\n<\/ul>\n<p>Download a sample CSV to review the precise formatting of columns and row data that is expected by on import.<\/p>\n<h4>Listings: Export CSV<\/h4>\n<p>Configure an export of listings.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Post Type<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Choose the post type for export<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Max entries per CSV file<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Select the count of listings that will be exported.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Start date and End date<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Limit the listings exported to a particular time period based on the post creation date.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Export CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Click the button once your export has been configured.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Download<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Download the file and use OpenOffice or LibreOffice for review or edit.<\/p>\n<h3><a href=\"#categories\" name=\"categories\">Categories<\/a><\/h3>\n<h4>Categories: Import CSV<\/h4>\n<p>Configure the options for the import of a CSV of categories.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Update item if item with cat_id\/cat_slug already exists.<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Items will be updated if the ID or slug already exists.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Ignore item if item with cat_id\/cat_slug already exists.<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Item updates will be skipped if the ID or slug already exists.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Select and Upload CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Choose a CSV from your local file system, then confirm the upload of the CSV.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Download Sample CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Download a sample CSV to review the precise formatting of columns and row data that is expected by on import.<\/p>\n<h4>Categories: Export CSV<\/h4>\n<p>Configure an export of categories.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Post Type<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Choose the post type for which categories will be exported.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Max entries per CSV file<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Select the count of items that will be exported.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Export CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Click the button once your export has been configured.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Download<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Download the file and use OpenOffice or LibreOffice for review or edit.<\/p>\n<h3><a href=\"#reviews\" name=\"reviews\">Reviews<\/a><\/h3>\n<h4>Reviews: Import CSV<\/h4>\n<p>Configure the options for the import of a CSV of reviews.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Update item if review with comment_ID already exists.<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Items will be updated if the ID already exists.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Ignore item if review with comment_ID already exists.<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Item updates will be skipped if the ID already exists.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Select and Upload CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Choose a CSV from your local file system, then confirm the upload of the CSV.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Download Sample CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Download a sample CSV to review the precise formatting of columns and row data that is expected by on import.<\/p>\n<h4>Reviews: Export CSV<\/h4>\n<p>Configure an export.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Post Type<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Choose the post type for which items will be exported.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Max entries per CSV file<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Select the count of items that will be exported.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Start date and End date<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Limit the listings exported to a particular time period based on the creation date.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Rating<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Limit the export items based on particular rating.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Status<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Limit the export based on particular status.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Export CSV<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Click the button once your export has been configured.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Download<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Download the file and use OpenOffice or LibreOffice for review or edit.<\/p>\n<h3><a href=\"#settings\" name=\"settings\">Settings<\/a><\/h3>\n<h4>Import \/ Export Settings<\/h4>\n<p>Import and export your GeoDirectory Settings between sites or simply back them up via a .json file.<\/p>\n<ul>\n<li><strong>Import Settings<\/strong><\/li>\n<\/ul>\n<p>Select a file from your local file system to import and overwrite site settings.<\/p>\n<ul>\n<li><strong>Download Settings<\/strong><\/li>\n<\/ul>\n<p>Download the file and store in a backup system, or use the file to import settings on a different site.<\/p>\n<h3>Customize<\/h3>\n<p>For more about using CSS and PHP snippets see our doc about <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/faq\/customizing\/\">customizing<\/a>.<\/p>\n<p><strong>Export a single category<\/strong> &#8211; Use this snippet to export only listings in a particular category &#8211; <a href=\"https:\/\/wpgeodirectory.com\/support\/topic\/website-screenshot-instead-of-category-image-in-listings\/page\/2\/#post-494443\" rel=\"noopener noreferrer\" target=\"_blank\">Snippet<\/a><\/p>\n<h3><a href=\"#faq\" name=\"faq\">FAQ<\/a><\/h3>\n<h4><a href=\"#images\" name=\"images\">Listings: Importing images<\/a><\/h4>\n<blockquote class=\"gd-faq\">\n<p>When importing listings, you can add image details for the listings in the <strong><em>post_images<\/em><\/strong> column. This format is used in other file import fields as well.<\/p>\n<p>In order to allow for commas in the caption, each image statement is ended with a <\/p>\n<pre><code>::<\/code><\/pre>\n<p> double colon.<\/p>\n<p>The structure of the import data in an file image cell is:<\/p>\n<p><em><\/p>\n<pre><code>URL|ID|TITLE|DESCRIPTION::URL|ID|TITLE|DESCRIPTION::URL|ID|TITLE|DESCRIPTION<\/code><\/pre>\n<p><\/em><\/p>\n<p>For an import without id, title, or description:<\/p>\n<p><em><\/p>\n<pre><code>::filename01.jpg|||::filename02.jpg|||::filename03.jpg|||<\/code><\/pre>\n<p><\/em><\/p>\n<p>About filenames:<\/p>\n<p><strong>URL<\/strong><\/p>\n<ol>\n<li>To upload new images, use the filename like this:\u00a0<br \/>\n<em><strong>filename.extension<\/strong><\/em><\/li>\n<li>If you already have uploaded the image to an existing listing, the file URL will be shown like this:<br \/>\n<em><strong>https:\/\/mysite.com\/wp-content\/uploads\/year\/month\/filename.extension<\/strong><\/em> Note: It is not possible to reference images in the Media Library in this way. This URL is only shown as an example.<\/li>\n<\/ol>\n<p><strong>ID<\/strong><\/p>\n<ol>\n<li>Leave this empty when importing new listings.<\/li>\n<li>When updating listings, include the image ID as exported.<\/li>\n<\/ol>\n<p><strong>TITLE and DESCRIPTION<\/strong><\/p>\n<ol>\n<li>Used as the image title and caption:<br \/>\n<img class=\"alignnone size-full wp-image-625\" src=\"http:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/imp2.png\" alt=\"\" width=\"367\" height=\"157\" srcset=\"https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/imp2.png 367w, https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/imp2-300x128.png 300w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/li>\n<li>Used as the title and alt tag:<br \/>\n<img class=\"alignnone size-full wp-image-626\" src=\"http:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/imp1.png\" alt=\"\" width=\"434\" height=\"30\" srcset=\"https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/imp1.png 434w, https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/imp1-300x21.png 300w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/li>\n<\/ol>\n<p>If you want another example, try adding a listing with several images. Hover over the images in the form and add title and descrption to them. Then export the listing. You will see something like this:<\/p>\n<p>Sample Export of post_images field values<\/p>\n<pre><code class='php'>\r\nhttps:\/\/mysite\/wp-content\/uploads\/2019\/05\/file01.png|818|Image Title|Image Caption::https:\/\/mysite\/wp-content\/uploads\/2019\/05\/file02.jpg|819||::https:\/\/mysite\/wp-content\/uploads\/2019\/05\/file03.jpg|820||::https:\/\/mysite\/wp-content\/uploads\/2019\/05\/fie04.jpg|821||\r\n<\/code><\/pre>\n<\/blockquote>\n<h4><a href=\"#business-hours\" name=\"business-hours\">Listings: Business Hours<\/a><\/h4>\n<blockquote class=\"gd-faq\">\n<p>Business hours can be imported and exported. An example of the format: <\/p>\n<pre><code>[\"Mo 09:00-17:00,18:00-23:59\",\"Tu 00:00-08:00,09:00-17:00\"],[\"UTC\":\"-5:00\"]<\/code><\/pre>\n<p>To master the format, try adding listings with different examples that are relevant to your directory and then export as described in the <a href=\"#recommended\">recommended procedure<\/a> below.<\/p>\n<p><a href=\"http:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/biz-hours.jpg\"><img src=\"http:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/biz-hours.jpg\" alt=\"\" width=\"865\" height=\"465\" class=\"alignnone size-full wp-image-889\" srcset=\"https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/biz-hours.jpg 865w, https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/biz-hours-300x161.jpg 300w, https:\/\/wpgeodirectory.com\/docs-v2\/wp-content\/uploads\/sites\/23\/2018\/06\/biz-hours-768x413.jpg 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><\/a><\/p>\n<\/blockquote>\n<h4>Geocode and Reverse Geocode<\/h4>\n<blockquote class=\"gd-faq\">\n<p><a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/integrations\/maps\/#geocoding\" rel=\"noopener noreferrer\" target=\"_blank\">Read more in the Maps doc<\/a><\/p><\/blockquote>\n<h4>Assign Category IDs<\/h4>\n<blockquote><p>\nIt is not possible to assign specific category IDs using GeoDirectory options. WordPress creates the ID and assigns it. It is not possible with GeoDirectory import\/export and falls outside of support.\n<\/p><\/blockquote>\n<h4><a href=\"#recommended\" name=\"recommended\">Recommended procedure for importing listing data<\/a><\/h4>\n<blockquote class=\"gd-faq\"><p>\n<strong>Complete the Setup of GeoDirectory First<\/strong><\/p>\n<ul>\n<li>Enable the <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/addons\/location-manager\/\" rel=\"noopener noreferrer\" target=\"_blank\">Location Manager<\/a> if you have listings outside your default location. (Failure to enable the Location Manager will results in all your listings being added to the default location).<\/li>\n<li>Setup maps: Get your Google Maps API key working first (especially if your listings have incomplete address data or are missing lat\/lon coordinates so you ca use the superior Geocoding provided by the Google Maps API).<\/li>\n<li><a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/settings\/general\/#default-location\" rel=\"noopener noreferrer\" target=\"_blank\">Set your default location<\/a><\/li>\n<\/ul>\n<p><strong>Create and configure your Custom Post Type<\/strong><\/p>\n<p>You can use the built in &#8220;Places&#8221; post type, or create your own with the <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/addons\/custom-post-types\/\" rel=\"noopener noreferrer\" target=\"_blank\">Custom Post Types addon<\/a>. In either case, before you import, you should set that custom post type up with all the fields that you want.<\/p>\n<ol>\n<li>Create your <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/addons\/custom-post-types\/\" rel=\"noopener noreferrer\" target=\"_blank\">Custom Post Type<\/a> (or use the built in places CPT).<\/li>\n<li>Add all the <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/places\/custom\/\" rel=\"noopener noreferrer\" target=\"_blank\">Custom Fields<\/a> you need for your CPT.<\/li>\n<li>Add a test listing to make sure all your Custom Fields look and behave as expected.<\/li>\n<li>Make any necessary changes to the Custom Fields, including re-ordering the fields.<\/li>\n<\/ol>\n<p><strong>Create or Import Categories<\/strong><\/p>\n<p>Categories are required. Each category requires the Name, slug, and a map icon. Any category referenced in your import must first be created (completely) in your site under the Custom Post Type that you want to use. See the <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/places\/categories\/\">Categories doc<\/a> for more info.<\/p>\n<p>When you import your listings, make sure that the category listed as the default category is also listed in the category column.<\/p>\n<p>Once you have imported listings, you will need to run the <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/status\/#term-counts\" rel=\"noopener noreferrer\" target=\"_blank\">Term Count tool<\/a> to update the count of listings in each category.<\/p>\n<p><strong>Do Not Create Locations<\/strong><\/p>\n<ol>\n<li>It is not necessary to create locations before importing listings. It is more important to create sample listings in various locations.<\/li>\n<li>It is recommended to add listings to various locations. Locations are created automatically when listings are added.<\/li>\n<\/ol>\n<p><strong>Add Test Listings<\/strong><\/p>\n<ol>\n<li>Add a test listing for each category. Ex. Title=&#8221;Test {category name}&#8221;, Category={category name}. This will give you an export that will show you how to map each category in your data.<\/li>\n<li>Add a listing for each location. This will give you an export that will show you how to map each location in your data and provide you samples that are coming from the Map API of your choice.<\/li>\n<li>Fill out all your custom fields and image fields, and use multiple images in a test listing. This will show you how the fields map, and give you an example for how images are referenced in exports.<\/li>\n<\/ol>\n<p><strong>Export Test Listings<\/strong><\/p>\n<ol>\n<li>Go to GeoDirectory &#8211; Settings &#8211; Import\/Export &#8211; Listings<\/li>\n<li>Export the listings from the Custom Post Type where you added your categories and test listings.<\/li>\n<li>Do not use the &#8220;Sample Data&#8221; file. This file has limited fields. Only the exported listings sheet will contain all your custom fields and be in the appropriate column order.<\/li>\n<li>Download the CSV Export file.<\/li>\n<li>Note: You can only edit the file with OpenOffice or <a href=\"https:\/\/www.libreoffice.org\/discover\/calc\/\" target=\"_blank\" rel=\"noopener noreferrer\">LibreOffice Calc<\/a>. Other editors leave artifacts in saved files that make them unreadable.<\/li>\n<\/ol>\n<p><strong>Test Import<\/strong><\/p>\n<ol>\n<li>Examine the sheet with Open Office or LibreOffice and note that exported listings have a listing ID<\/li>\n<li>Take notice that the categories are identified by ID.<\/li>\n<li>Take you downloaded listings export and attempt to re-import.<\/li>\n<li>Go to the import dialogue and choose the option to &#8220;Update listing if post ID already exists.&#8221;<\/li>\n<li>Select your listing file and upload.<\/li>\n<li>Error? If you see an error, <a href=\"#not-a-valid-csv-file\">please check here<\/a>.<\/li>\n<li>Import<\/li>\n<li>If no changes were made, there should be no errors.<\/li>\n<li>Note any errors and report them in a support topic if you cannot address them.<\/li>\n<li>Make some changes to the file. Try changing the default category of one or more listings, then re-import to see if you made the change correctly.<\/li>\n<\/ol>\n<p><strong>Merge A Test Set of 5 Records into the Exported Listings file<\/strong><br \/>\nNow that you have some confidence in the export\/import system, you can try merging your data into the exported file format. We recommend you try first with one or two records.<\/p>\n<ol>\n<li>Open the export file in Open Office or LibreOffice Calc.<\/li>\n<li>Merge 5 records into the sheet. You will at least need to fill in the required fields including title, categories, and some location data.<\/li>\n<li>Copy-down location data from the exported listings like country\/region\/city if it is different. Some country names may be different. See the <a href=\"https:\/\/github.com\/AyeCode\/geodirectory\/blob\/605b03059ca237672216226a1cf891a3ef86115f\/vendor\/ayecode\/wp-country-database\/wp-country-database-data.php\" target=\"_blank\" rel=\"noopener noreferrer\">country file here<\/a>.<\/li>\n<li>One by one, copy your data from your sheet, and place it into the appropriate column of the export CSV.<\/li>\n<li>If you have made any changes to existing listings, be sure to choose the option to &#8220;Update listing if post ID already exists.&#8221;<\/li>\n<li>Import the sheet. Address any errors identified during the process ad re-import if necessary.<\/li>\n<\/ol>\n<p><strong>Merge Data into the Exported Listings file<\/strong><\/p>\n<ol>\n<li>Examine the export file with Open Office or LibreOffice. Make note of the columns. Save a backup copy.<\/li>\n<li>One by one, match the exported column structure to your listing data column structure.<\/li>\n<li>One by one, copy your data from your sheet, and place it into the appropriate column of the export CSV.<\/li>\n<li>Map all categories to category IDs.<\/li>\n<li>If you have made any changes to existing listings, be sure to choose the option to &#8220;Update listing if post ID already exists.&#8221;<\/li>\n<li>Import the sheet. Address any errors identified during the process ad re-import if necessary.<\/li>\n<li>Run the <a href=\"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/status\/#term-counts\" rel=\"noopener noreferrer\" target=\"_blank\">Term Count tool<\/a> to update the count of listings inside each category.<\/li>\n<\/ol>\n<\/blockquote>\n<h4><a href=\"#not-a-valid-csv-file\" name=\"not-a-valid-csv-file\">CSV Error<\/a><a href=\"#csv-error\" name=\"csv-error\"><\/a><\/h4>\n<blockquote class=\"gd-faq\">\n<p>WordPress does not allow the upload of CSV files (by default). You may see one of several different errors when trying to upload a CSV file, all of which are telling you that you cannot upload a CSV file. <\/p>\n<p>To get around this, install this plugin which makes your site allow the upload of CSV files:<br \/>\n<a href=\"https:\/\/wordpress.org\/plugins\/disable-real-mime-check\/\" rel=\"noopener noreferrer\" target=\"_blank\">https:\/\/wordpress.org\/plugins\/disable-real-mime-check\/<\/a><\/p>\n<p>Once you have uploaded your files, then you can deactivate and delete the plugin.<\/p>\n<p>Alternatively, you can simply add the plugin code to your theme functions file or use the plugin \u201ccode snippets\u201d to add it.<\/p>\n<pre><code class='php'>\r\nfunction wp39550_disable_real_mime_check( $data, $file, $filename, $mimes ) {\r\n\t$wp_filetype = wp_check_filetype( $filename, $mimes );\r\n\r\n\t$ext = $wp_filetype['ext'];\r\n\t$type = $wp_filetype['type'];\r\n\t$proper_filename = $data['proper_filename'];\r\n\r\n\treturn compact( 'ext', 'type', 'proper_filename' );\r\n}\r\nadd_filter( 'wp_check_filetype_and_ext', 'wp39550_disable_real_mime_check', 10, 4 );\r\n<\/code><\/pre>\n<p>This issue, not being able to upload a CSV without a workaround, is a result of a WordPress security policy change (not us!) and the verdict is still out about a &#8216;proper&#8217; resolution. In fact, you may encounter this issue on your site for a number of different reasons (WordPress version, PHP extensions, Multisite rules, the program used to make the CSV file), none of which are related to GeoDirectory code. Check and see that there are several WordPress bugs resulting from the WordPress security policy change:<br \/>\n<a href=\"https:\/\/core.trac.wordpress.org\/ticket\/45615\" rel=\"noopener noreferrer\" target=\"_blank\">https:\/\/core.trac.wordpress.org\/ticket\/45615<\/a><br \/>\n<a href=\"https:\/\/core.trac.wordpress.org\/ticket\/45633\" rel=\"noopener noreferrer\" target=\"_blank\">https:\/\/core.trac.wordpress.org\/ticket\/45633<\/a>(and many many more)<\/p>\n<p>Almost every plugin that accepts CSV uploads was affected by this, including WooCommerce and Easy Digital downloads, both of which have published workarounds that reference the plugin linked above.\n<\/p><\/blockquote>\n<h4>All my imported listings are now in the default location after import, what happened?<\/h4>\n<blockquote class=\"gd-faq\">\n<p>Make sure to install and setup the Location Manager first before importing listings. See the recommended import procedure above.\n<\/p><\/blockquote>\n","protected":false},"featured_media":0,"parent":96,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"amp_validity":null,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/docs\/156"}],"collection":[{"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/comments?post=156"}],"version-history":[{"count":0,"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/docs\/156\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/docs\/96"}],"next":[{"title":"API","link":"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/settings\/api\/","href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/docs\/157"}],"prev":[{"title":"General","link":"https:\/\/wpgeodirectory.com\/docs-v2\/geodirectory\/settings\/general\/","href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/docs\/152"}],"wp:attachment":[{"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/media?parent=156"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/wpgeodirectory.com\/docs-v2\/wp-json\/wp\/v2\/doc_tag?post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}