VirtualBob Posted March 31, 2023 Posted March 31, 2023 I've created a photo catalog in FileMaker and import the images directly (not referenced) into an 'image' container field. In the process I capture the filename and filepath. I've realised the photo scanner I use is making B+W images too dark so I might have to process them through an app and lighten them. For already imported images is there any way to overwrite the current images using the Import function where the image path or filename is matched and only the image container field is updated? I've done this previously with other data but can't recall if I've done it with embedded images.
comment Posted March 31, 2023 Posted March 31, 2023 You can choose to update matching records when importing a folder too. Follow the instructions here (esp. the one about having a backup): https://help.claris.com/en/pro-help/content/importing-folder.html Alternatively you could import the corrected images into a new file and do the update via a relationship.
VirtualBob Posted March 31, 2023 Author Posted March 31, 2023 OK thanks - it was easier than I thought: Import > Update matching records in found set > update field " <-> File Name" and it replaces just the images. Just a note on importing images, yes it can work with folders but if you need to update just a few images in the folder you'll need to put all the non-updated images in a temp folder at the root level of that folder, then when you import, uncheck "include all enclosed folders" so it just imports the updated images you put in the folder root. When that's done reunite the old images with the new ones at the folder root level. Its the only workaround I've found.
comment Posted March 31, 2023 Posted March 31, 2023 Could you not create a found set of the images that need updating first?
VirtualBob Posted March 31, 2023 Author Posted March 31, 2023 Oh yes for updating - that's a good idea, but generally if I incrementally add images on import I have that issue of it wanting to import the whole folder, and if I try to add just one image rather than a folder full, from memory not all of the attributes are imported.
comment Posted March 31, 2023 Posted March 31, 2023 Sorry, you lost me at this point. I thought we were talking about updating. Note that you can check the "Add remaining data as new records" option If you want to add new images at the same time. And you can validate a field - e.g. File Name or File Path - as unique to prevent duplicates.
VirtualBob Posted March 31, 2023 Author Posted March 31, 2023 Its a bit of both, import images into the database, then update some of them with enhanced versions, but I'm trying to streamline the process end to end as the import folder feature is clunky, so your feedback is helpful and I might rethink the import process. Even if I add new images by overwriting the current images with old ones and check "add remaining records" that might still be a less fussy option. I'm an occasional user and so its useful to ask on this forum for better ways of doing things, so thanks again.
Recommended Posts
This topic is 938 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now