Automating Folder Creation in OSX (CSV)

With the new Evaluation system in Ohio my curriculum director needed an easy way to create a folder for each teacher to keep track of all of their documents, evaluations, slo’s, etc. So I went to work and created an easy to use script.

So here are the steps that we will be doing.

1. Create a list of students, teachers, or anything else you want to create folders for. This can be for students in your class, weeks in the school year, teachers etc.

Example: https://docs.google.com/spreadsheets/d/1s9I9Ce9Euqj8499B9Az5SroCpchSthQ8CklC6vv-3Xc/edit?usp=sharing

2. Export that list as a csv.

CSV stands for Comma Separated Value. This basically is an excel spreadsheet with the values separated by a comma.

3. Navigate to the folder that you would like to create all of the folders in.

4. Make sure you have 2 files in your folder (folders.sh , and the CSV file of your names)

4. Run the script (folders.sh)

5. Enjoy filling the folders with lots of useful information!

 

Note:

Google Sheets makes it super easy to create and download CSV’S. Simply open your Google Sheet, Click File, Click Download As and choose “Comma Separated Values”

Screen Shot 2013-10-03 at 11.50.13 AM

 

 

Its important to note that it must be named “folders.csv” unless you modify the script.

Now for the script.

Bonus:

With the Google drive application on your computer you can simply navigate to the folder that you want to create folders in and those folders will all sync to Google Apps!   As always if you have any questions feel free to reach out!

Thanks TJ        

TJ Houston

TJ Houston the Vice President of Managed services at Epiphany Management Group. TJ leads professional development in all areas of technology and loves developing ways to make teachers, students, and staff's lives easier with the use of technology. TJ also loves photography and his portfolio can be found at http://www.tjshots.com. All of the views on this site are his own.

  • Amber

    I followed this tutorial exactly, but it didn’t work. I got the script to run, and it prompted me about whether to delete it or not, but it never created the folders.