Can i setup mass directory folders

[Scottlem]

Hi i have a list of around 5000 items in excel which need to be setup as directories. Does anyone know how i can do this.

 

[mcconmw]

Could you elaborate on your question? I'm not sure I understand what you are asking.

 

[Scottlem]

On our accounts system we have all our clients listed by client number. I can run a report from our accounts system on to excel. What i need is to some how get the client numbers to be /foldersdirectories on our file system. This is to allow all letters etc to be stored by client number reference

 

[nolapeck]

Simple solution with no coding. You could add a column in the spreadsheet and put mkdir in all rows of the first column and your directory structure it the second column. Highlight the 2 columns and copy to notepad. Save this file as test.bat.

It should make all of the directories when you run the bat file.

 

[mcconmw]

Using nolapeck's method above make sure you run the bat file from the directory that you want all the directories to be sub-directories of.

 

[nolapeck]

On a related question.

What is the maximum number of directories under a single folder?

 

[Scottlem]

Thanks that was just the ticket. Simple really, if only my head was not where it is at the moment. Thanks again.

 

[mcconmw]

I'm not sure how many you can have precisely. I know it is a lot. Personally, I do not like to have much more than 5000 and prefer it to remain around a thousand. It takes a long time for explorer to enumerate all the folders and display at these numbers. It is typically more efficient to nest the directories somewhat to improve performance in explorer.

 

[Scottlem]

is it possible to run the batch file so it creates the directories with sub directories also

 

[mcconmw]

Sure. You will have to create the directory first and then create the subdirectories. Something like...

md c:\group1
md c:\group1\client1
md c:\group1\client2
md c:\group2
md c:\group2\client3
etc.

You can use excel to build these lists