Creating bulk folders

[nevodj]

Hello,

don't know if this is achievable, but i want to create a folder in my documents for every account in our accounting system, with the folder name being their account code.

I can get a list of the account codes in excel or csv or any other format.

I wondered if there was a way to automate this process in AutoIT cos i don't really feel like creating 3500 folders manually.........!!!

Thanks

[enaiman]

That is perfectly possible.

You need to have the account names read into an array - if you can get them in a text file with 1 account name/line that would be easier - but csv, xls ... will work too.

My example will be based on having them in a txt file, one account / line.

#include <File.au3>

Global $usrArray
_FileReadToArray("your file here", $usrArray)
For $i = 1 To $usrArray[0]
    DirCreate(@MyDocumentsDir&"\"&$usrArray[$i])
Next
MsgBox(0, "OK", "All Done")

Test it first with a text file with only several account names. If you're happy - go for the full implementation.

[nevodj]

just on this... It's the adding to context menu i am lost on.... the sql bit etc i can handle.

[nevodj]

Don't worry, got this sorted.