Create multiple subfolders with different parent folders CSV - Powershell

Question

I'm trying to create multiple sub folders for different parent directories. I have a CSV file with almost 700 folders. I have 4 columens in my CSV

Column A serial code (codigo)

Column B course (materia)

Column C faculty the course belongs to (facultad)

Column D career that have that course (carrera)

I have the following code for that

$materias = Import-Csv C:\Materias.csv

foreach{$EstMaterias in $materias)
{
    $path = "C:\" 
    $codigo = $EstMaterias.codigo
    $materia = $EstMaterias.materia
    $facultad = $EstMaterias.facultad
    $carrera = $EstMaterias.carrera

    New-Item -Path("$path\$facultad\$carrera\$mateira") -Type directory
}

I'm not sure how to filter thee subfolders so that the careers are created inside their correct faculty and courses inside their correct career. With the code I run right now all courses are created inside the faculties and inside all of the careers.

Can you provide a sample csv with a few line (not the whole file) and the actual and expected result? — Francesco Montesano, Nov 04 '20 at 19:54
First - please do not add additional information as comments. Add them to your question instead. And second - [a picture of code or sample data is not helpful](https://idownvotedbecau.se/imageofcode) ... — Olaf, Nov 04 '20 at 20:14
You don't use `$codigo = $EstMaterias.codigo` and you have typing error here `("$path\$facultad\$carrera\$mateira")`. You typed in $mateira instead of `$materia`. — Zoran Jankov, Nov 09 '20 at 10:23

Zoran Jankov · Accepted Answer · 2020-11-09T22:09:26.693

You don't use $codigo = $EstMaterias.codigo, and you have typing error here "$path\$facultad\$carrera\$mateira". You typed in $mateira instead of $materia.

$materias = Import-Csv C:\Materias.csv

$path = "C:"

foreach ($EstMaterias in $materias) {
    $codigo = $EstMaterias.codigo # What is this? You don't use it here.
    $materia = $EstMaterias.materia
    $facultad = $EstMaterias.facultad
    $carrera = $EstMaterias.carrera

    New-Item -Path "$path\$facultad\$carrera\$materia" -Type directory
}

Create multiple subfolders with different parent folders CSV - Powershell

1 Answers1