{"id":917,"date":"2025-03-24T14:28:01","date_gmt":"2025-03-24T14:28:01","guid":{"rendered":"https:\/\/wpgeodirectory.com\/documentation\/article\/how-to-format-the-csv-file-for-importing-listing-images\/"},"modified":"2025-04-03T15:24:22","modified_gmt":"2025-04-03T14:24:22","slug":"how-to-format-the-csv-file-for-importing-listing-images","status":"publish","type":"gd_place","link":"https:\/\/wpgeodirectory.com\/documentation\/article\/how-tos\/how-to-format-the-csv-file-for-importing-listing-images\/","title":{"rendered":"How to format the CSV file for importing listing images"},"content":{"rendered":"\n
<\/span>When importing listings<\/strong>, you can add image details for the listings in the\u00a0post_images<\/em><\/strong>\u00a0column.<\/span><\/div>\n\n\n\n

In order to allow for commas in the caption, a double colon is added between images:<\/p>\n\n\n\n

::<\/pre>\n\n\n\n
For each image reference you need a file reference<\/strong>, media ID<\/strong>, title<\/strong> and caption<\/strong>.
For example, the data required to import 2 images would be in this format:<\/p>\n\n\n\n
file reference|media ID|title|caption::file reference|media ID|title|caption<\/pre>\n\n\n\n
File reference<\/strong><\/h3>\n\n\n\n
(Note: if you are importing an exported CSV the images will have a media ID and will not be processed)<\/p>\n\n\n\n
    \n
  1. Manual bulk upload:<\/strong> Use the filename like this:\u00a0
    filename.extension <\/i>(for example hotel.jpg<\/strong>) then you can bulk upload the images to the current month upload directory as shown in the examples below.<\/li>\n\n\n\n
  2. Download and Import image: <\/strong>If you are adding a new image that does not have a media ID you can reference the image as a URL and it will be downloaded and imported into your system. (URLs must contain a valid image extension.)
    https:\/\/mysite.com\/wp-content\/uploads\/year\/month\/my-image.jpg<\/a><\/strong>\u00a0
    Note:<\/strong> This URL is only shown as an example.<\/li>\n\n\n\n
  3. Externally hosted images: <\/strong>If you wish to use an external image, you can reference the external image and add a “#” <\/strong>before it, this will let the system know to not download it. (external images won’t be used as a featured image)
    #    https:\/\/mysite.com\/wp-content\/uploads\/year\/month\/<\/a><\/em>my-image.jpg\u00a0<\/b><\/strong>
    <\/b><\/li>\n<\/ol>\n\n\n\n
    Media ID<\/strong><\/h3>\n\n\n\n
      \n
    1. Leave this empty when importing new listings.<\/li>\n\n\n\n
    2. When updating listings, include the image ID as exported.<\/li>\n<\/ol>\n\n\n\n
      Title and Caption<\/strong><\/h3>\n\n\n\n
        \n
      1. Can be shown as part of image displays.\u00a0<\/li>\n\n\n\n
      2. These can be left blank.<\/li>\n\n\n\n
      3. For example<\/strong> with a title “City map” and caption “An image of a city map”:
        \"\"<\/figure><\/li>\n<\/ol>\n\n\n\n
        Examples<\/h2>\n\n\n\n
        Import 3 images only:<\/p>\n\n\n\n
        1.jpg|||::2.jpg|||::3.jpg|||<\/pre>\n\n\n\n
        Import 2 images with title and caption:<\/p>\n\n\n\n
        hotel.jpg||Hotel|This is a nice hotel::restaurant.jpg||Restaurant|This is a nice restaurant<\/pre>\n\n\n\n
        <\/p>\n\n\n\n
        <\/span>When adding new images, upload the images<\/strong> to the uploads folder for the current month, for example:<\/strong><\/span><\/div>\n\n\n\n
        \"\"<\/p>\n\n\n\n
        Filename and File type<\/strong><\/p>\n\n\n\n
        GeoDirectory’s importer can only import images from a remote URL that has both filename and filetype.<\/p>\n\n\n\n
        URLs like this will work.
        https:\/\/mysite.com\/images\/filename.jpeg<\/strong>
        URLs like this will not work
        https:\/\/mysite.com\/images\/1234121231-LHLKHKHP<\/p>\n","protected":false},"excerpt":{"rendered":"
        In order to allow for commas in the caption, a double colon is added between images: :: For each image reference you need a file reference, media ID, title and caption.For example, the data required to import 2 images would be in this format: file reference|media ID|title|caption::file reference|media ID|title|caption File reference (Note: if you are […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"article\/tags":[],"article\/categories":[211,432],"class_list":["post-917","gd_place","type-gd_place","status-publish","hentry","gd_placecategory-tips-tricks-more","gd_placecategory-how-tos"],"_links":{"self":[{"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/article\/917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/types\/gd_place"}],"author":[{"embeddable":true,"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/comments?post=917"}],"version-history":[{"count":0,"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/article\/917\/revisions"}],"wp:attachment":[{"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/media?parent=917"}],"wp:term":[{"taxonomy":"gd_place_tags","embeddable":true,"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/article\/tags?post=917"},{"taxonomy":"gd_placecategory","embeddable":true,"href":"https:\/\/wpgeodirectory.com\/documentation\/wp-json\/wp\/v2\/article\/categories?post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}