Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Generate folders from spreadsheet?
#10
Allright, I found a kind young geek who speaks English.
Here's his solution:

Hi Dik-

So here's what I found....

1. Create a .csv file from your spreadsheet with two columns. (One column with the name and the other with the zipcode.) Name it folders.csv.
2. Create a folder and name it whatever you'd like and place folder.csv into that folder.
3. Open Terminal from Applications
4. type cd followed by a space into terminal like this 'cd '
5. Drag the folder you created that has the folder.csv file to terminal. This will add the folder path after cd. Hit return.
6. Terminal should now show the folder name
7. copy and paste this cat folder.csv | xargs mkdir into terminal and hit return.

That's it. You should see the folder populate with lots of folders using this 'name,zipcode' convention.

Feel free to give me a call if you have any questions.
Austin.
Reply


Messages In This Thread
Generate folders from spreadsheet? - by Dik2 - 05-17-2011, 01:49 AM
Re: Generate folders from spreadsheet? - by Dik2 - 05-17-2011, 10:23 AM
Re: Generate folders from spreadsheet? - by Dik2 - 05-17-2011, 12:19 PM
Re: Generate folders from spreadsheet? - by Dik2 - 05-18-2011, 02:02 PM
Re: Generate folders from spreadsheet? - by Dik2 - 05-19-2011, 02:00 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)