Moving folders with batch file and list

[Matt_B]

First, apologies for the title, I couldn't think of a better one.

On our server at school we have a list of folders for each class, Class 1, Class 2 etc and within those I wanted one for each child. I have written a small batch script that cycles through all of the text files in the batch folder which are called Class 1.txt, Class 2.txt etc. Within these files is each child's name on a new line. So far so simple.

The problem will come next September when children move classes. They don't move together, so some of Class 1 will go to Class 3 with some of Class 2 etc. Is there a script that would go through a simple text file or CSV to move them from one folder to another?

ie.

Name Old Class New Class
Child A, 1, 3
Child B, 2, 3

and so on?

I'm thinking something like

xcopy P:\%oldclass%\*.* P:\%newclass%\*.*

My issue is how to get that info from the text file

 

[Darth Vodka]

first thought: use a database...or at least a master spreadsheet of data

two things to try

one...with a spreadsheet with everything you need, write a formula that the end forms an MSDOS command like

="copy c:\"&B2&"\"&A2&".txt c:\"&C2&"\"
copy c:\1\Child A.txt c:\3\

then create a load of MSDOS lines and spang them into the command prompt

secondly, you could write a VB script task that opens text files and loops through them

 

[Darth Vodka]

oh my formula needs work for the spaces in the DOS path, like

="copy "&CHAR(34)&"c:\"&B2&"\"&A2&".txt"&CHAR(34)&" c:\"&C2&"\"
copy "c:\1\Child A.txt" c:\3\

 

[Matt_B]

first thought: use a database...or at least a master spreadsheet of data

two things to try

one...with a spreadsheet with everything you need, write a formula that the end forms an MSDOS command like

="copy c:\"&B2&"\"&A2&".txt c:\"&C2&"\"
copy c:\1\Child A.txt c:\3\

then create a load of MSDOS lines and spang them into the command prompt

secondly, you could write a VB script task that opens text files and loops through them

The text files are only really useful as a first run, once the folders are created it's a case of moving them and everything in them.

 

[SJN-Fox]

Probably find that there's a way in Powershell to do this.

 

[Matt_B]

Probably find that there's a way in Powershell to do this.

Never used it before, I'll have a looksy.

 

[Darth Vodka]

i'd still say vb scripting