scenario: a free image hoster (foo-host in this example) has gone defunct, and a discourse forum currently has a bunch of hotlinked images in its posts images were backed up manually before they rotted and exist on the local filesystem a mapping exists between image url and local file path: get_paths_from_hotlinked_urls() how can i: create an attachment in rails for each of these images and add them to the post correctly? image_host_domain = 'foo-host.com' hotlink_posts = Post.where('cooked ~ ?', image_host_domain) puts "found #{hotlink_posts.length} posts with hotlinked images..." hotlink_posts.each do |p| # get all URLs in post containing image_host_domain urls = URI.extract(p.cooked).select { |url| url[/#{Regexp.quote(image_host_domain)}/] } local_paths = get_paths_from_hotlinked_urls(urls) new_raw = p.raw urls.each.with_index do |url, i| next if local_paths[i].blank? # ***** TODO: 1) 'upload' local_paths[i] as attachment # and correctly associate it with the post # ***** TODO: 2) replace hotlink with attachment # new_raw = new_raw... end p.update(raw: new_raw) end sorry for the low effort post. just feeling a bit stressed today, lol can someone please point me in the right direction? complete solution not required if it’s too much hassle. thanks

Bulk action help: replace hotlinked images with local image files

pfaffman (Jay Pfaffman) May 14, 2023, 2:08am 2

You can look at the import scripts for examples of how to upload files and insert the html for those uploads.

Topic		Replies	Views
Replacing remote images with local uploaded images issue Bug	13	3857	July 21, 2022
Generate file preview from urls Migration uploads	3	347	February 19, 2024
Rake posts:remap - 0 posts remapped! Self-hosting	4	858	February 1, 2020
Placeholder for non existing remote images Product Support	13	904	December 1, 2022
Image uploads path in posts will not change after rebake and remap Product Support	3	1383	April 6, 2020