Q: applescript: create folders using xcel file
Hello,
I am completely in the dark when it comes to Applescript. Ive been pounding the forums all day, and managed to Frankenstein a few scripts together, but cant quite get this script to work.
Ive attached a screen capture of the script, and the excel file its reading from.
Essentially, Im trying to create an Applescript using the excel file i have:
create a heirarchy of folders, using profile (col A) and color names (col C) then copy a couple images (cols F and H) from existing folders (defined in the script), to the newly created color folders (from col C).
Heirarchy like this:
GOLDEN EAGLE (profile: top level folder)
–KINGS CANYON (color: subfolder)
–1634.jpg (image file copied from other local folder)
_1634_skin.jpg (image file copied from other local folder)
Issues not addressed in current script:
Col A, has tons of duplicates...but I only need 1 folder for each profile. (1 GOLDEN EAGLE folder, 1 BEL AIR folder, etc)
Currently when i RUN the script, i get the first folder (GOLDEN EAGLE) but it errors after that.
Ive got a script that creates the folder heirarchy flawlessly. But then i was tasked with copying all these images into each folder. So, im trying to combine them into 1 script.
Please, I really dont want to do this manually, as there are over 1000 images...any help would be greatly appreciated!
MacBook Pro with Retina display, OS X Mavericks (10.9.5)
Posted on May 21, 2015 5:17 PM
Hi,
KMH wrote:
copy file "4502.jpg" of folder "Volumes:KMH BACKUP:Dropbox:EAGLE:EAGLE_www-FW:EAGLE_images:panels:" to folder "Arcadia" of folder "Bel Air" of folder "EAGLE-Photo Folders-NEW" of folder "Desktop" of folder "kevinherr" of folder "Users" of startup disk
--> error number -1728 from folder "Volumes:KMH BACKUP:Dropbox:EAGLE:EAGLE_www-FW:EAGLE_images:panels:"
copy file "4502_skin.jpg" of folder "Volumes:KMH BACKUP:Dropbox:EAGLE:EAGLE_www-FW:EAGLE_images:panels:" to folder "Arcadia" of folder "Bel Air" of folder "EAGLE-Photo Folders-NEW" of folder "Desktop" of folder "kevinherr" of folder "Users" of startup disk
--> error number -1728 from folder "Volumes:KMH BACKUP:Dropbox:EAGLE:EAGLE_www-FW:EAGLE_images:panels:"
Yes, the issue is the path of the "panels" folder, remove "Volumes:", because HFS path (path with colon character) doesn't need the "Volumes:"
If this does not work :
To get the right path : run this script :
set the clipboard to (choose folder with prompt "Select the 'panels' folder") as string
Now the path is in the clipboard, paste it in your script
Posted on May 22, 2015 5:16 PM

