Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
If my original folder or subfolders contains an image that is listed in my excel column, I want those images copied and put in a new folder.
Can someone help me create a simple applescript? Thanks.
Thanks. Got something where it takes images to be searched from a file and copies to dest folder.
set theNewFolder to choose folderwith prompt "Choose the destination folder."
set theOriginalFolder to choose folderwith prompt "Choose the folder containing your images."
set theDocument to choose filewith prompt "Please select a document to process:"
set theNumbers to paragraphs of (read (theDocument as alias))
tell application "Finder" to set theFiles to files of the entire contents of theOriginalFolder as alias list
set theFilesToDuplicate to {}
repeat with thisNumber in theNumbers
set thisNumber to contents of thisNumber
repeat with thisFile in theFiles
set thisFile to contents of thisFile
if (thisFile as text) contains (thisNumber as text) then
copy thisFile to the end of theFilesToDuplicate
exit repeat
end if
end repeat
end repeat
tell application "Finder" to duplicatetheFilesToDuplicatetotheNewFolder with replacing
A simple script? The following script is both simple and “pure” AppleScript. It has been tested under OS X 10.10.4 and seems to work pretty well when the number of subfolders and pictures is small. You might want to give it a try.
set theNewFolder to choose folderwith prompt "Choose the destination folder."
set theOriginalFolder to choose folderwith prompt "Choose the folder containing your images."
set theNumbers to {12345, 23456, 34567, 45678, 56789, 67890} -- to replace with your own list of numbers
tell application "Finder" to set theFiles to files of the entire contents of theOriginalFolder as alias list
set theFilesToDuplicate to {}
repeat with thisNumber in theNumbers
set thisNumber to contents of thisNumber
repeat with thisFile in theFiles
set thisFile to contents of thisFile
if (thisFile as text) contains (thisNumber as text) then
copy thisFile to the end of theFilesToDuplicate
exit repeat
end if
end repeat
end repeat
tell application "Finder" to duplicatetheFilesToDuplicatetotheNewFolder with replacing
Thanks but I'm new to applescript. Maybe this can help you formulate it better for me, so I can understand.
Original Images folder with subfolders: Desktop/Images
New folder were I want files duplicated to: Desktop/NewImages
List of numbers I want duplicated: images.txt
I only want numbers that match the ones in that list to be duplicated to the new folder.
I see the destination folder and containing folder, that helps. But maybe show where I can list the .txt or excel file for it to match numbers.
thanks for your time and help.
If you want, you can replace the first two lines of the script with
set theNewFolder to (path to desktop as text) & "NewImages:" as alias
set theOriginalFolder to (path to desktop as text) & "Images:" as alias
However, the only real issue is your list of numbers. First, I don't use Excel, but Numbers. Second, that list seems to be in a text file (images.txt). Without more details, I don't see how the script could get the correct list of numbers from that text file.
The file with the list is really the key to this whole thing. The .txt file can be converted into .xls, .cvs or numbers whatever you wish. I just need to know how to implement it in the code.
Let's give just an example. Suppose your list of numbers has been written into a TextEdit document saved to the Desktop as Plain Text under the name "My list.txt", as below:
Then you would just have to replace
set theNumbers to {12345, 23456, 34567, 45678, 56789, 67890}
with
set theNumbers to paragraphs of (read ((path to desktop as text) & "My list.txt" as alias))
in the script.
Thank you that worked, went through 10,000 images just fine and a list of 400 numbers.
Only thing I noticed is that if there were two similarly named images for example 12345-A and 12345-B it would pull in only the first it found and not both or all.
Just remove the “exitrepeat” line from the script. The execution time will be longer.
How long did it take for the script to go through 10,000 images and a list of 400 numbers?
Applescript to find image and copy to new folder
