|I have a rather challenging requirement at work and would be extremely grateful if someone could help with a solution. This then is the scenario:|
As part of our Configuration and Release Management process, we currently record all files that are to be released or deployed in a spreadsheet. The spreadsheet is rather basic with 3 main columns of data covering the following:
Column 1 - The file name
Column 2 - The source location of the above file (TFS in our case)
Column 3 - The version number of the above file (Changeset number in the case of TFS)
What we therefore have is something that looks like the below representation, the vertical bar being the separator for each Excel row cell:
HelloWorld.java | $/TFSServerName/ProjectA/SolutionA/SourceCode | 320012 (changeset no)
Can I stress though that each spreadsheet always contains multiple rows of similar entries as above, i.e. multiple files to be processed. The changeset numbers also tend to vary for each file.
What I am therefore looking to set up is an MS-DOS For Loop that will retrieve the three values from each row and parse them into another command (e.g. another For Loop) which performs some other task like a checkout of each file, using TFS command line syntax.
The main focus as far as this query goes is on the MS-DOS For Loop requirement and not the TFS command line script.
Anyone have some tips on how to achieve this please?