Hi All,
About a year ago, I posted this same request and was shocked and pleased to have someone create the basic script (seen below) for me. It has saved me so much time, I can’t begin to thank the person who wrote it. I’m hoping to take the script one step further. Depending on the complexity, I’m willing to pay for an error-free script that does the job.
Resources
Script (zipped): http://www.kylepetrozza.com/CreateShotFolders_scpt.zip
Shot List (Zipped Excel File): http://www.kylepetrozza.com/Shot_List_xls.zip
Screen Shot of Successful Hierarchy: http://www.kylepetrozza.com/Screen_Shot_2014_10_09_at_12_59_49_PM.jpg
Current Script:
[b]set screenBounds to {0, 44, 1920, 1640} – screen rect, change according to your needs.
set aName to “Shot_” – some folder name to rename each created folder
set targetFolder to choose folder with prompt “Select the directory to create folders”
display dialog “How many folders you want to create.” default answer “10”
set n to (text returned of the result) as integer
—** create folder **—
repeat with i from 1 to n
if i < 10 then
set x to aName & “0” & i
else
set x to aName & i
end if
tell application “Finder” to make new folder at targetFolder with properties {name:x}
end repeat[/b]
The script takes information from data in Excel (columns) and creates folders named for that data.
Ideally, I’d love to have a script that does what this basic script does, but for all relevant columns and that also arranges the folders in the hierarchy as seen in the screen shot. If this is possible, the time and stress savings would be enormous.
Self correcting / error checking is important as I’m not the one creating the excel files and errors sometimes crop up (blank cells for instance).
To my novice eyes, this seems like a rather large undertaking, but maybe for seasoned programmers/scripters it isn’t.
Please get in touch if you think you could take this on or know someone who would.
Thanks!
-Kyle
Model: MBP Late 2011
AppleScript: 2.2.4
Browser: Chrome
Operating System: Mac OS X (10.8)