French PowerShell User Group - Parse the survey on topics from 2017/09 sent to all members

readme.md

PowerShell - Parse the survey

Here is a quick PowerShell script demo that I used to parse the responses file of the topics survey sent to the French PowerShell User Group members in 2017/09.

The goal is to parse the CSV file, and create a simple markdown table that I can include into a Call for speakers post and give potential speakers ideas of topics.

Improvements

Feel free to improve my code, which is very ugly at the moment :)

Join us on the chat

#French on Slack! https://frpsug.github.io/slack/

Output example

## Question: HeureParfaite

|Compte|Reponse|
|---|---|
|26|20h00|
|24|21h00|
|14|19h00|
|5|18h00|

## Question: NiveauDesPresentations

|Compte|Reponse|
|---|---|
|21|300 (Confirmé/Avancé) ou +|
|16|200 (Intermediaire) ou +|
|8|400 (Expert)|
|4|100 (Débutant) ou +|

## Question: Sujet

|Compte|Reponse|
|---|---|
|41|Partage d'experience (Regler un probleme avec PowerShell|
|41|Reduit le temps d'execution d'une tache|
|41|Creation de rapport HTML|
|41|Creation d'interface graphique|
|37|performance|
|37|choses a eviter|
|37|PowerShell toolmaking et meilleur pratique (faire de meilleurs scripts/functions/modules|
|34|PowerShell Security (Attack/Offense|
|34|Audit de Securite|
|34|EventLog parsing|
|31|Gestion de Configuration (PowerShell avec DSC|
|31|SCCM|
|30|Unit Testing avec Pester|
|30|Technologies indispensable (Source Control avec GitHub|
|30|Utiliser et creer des regles Script Analyzer|
|29|PowerShell Troubleshooting|
|27|Culture DevOps|
|25|Container|
|25|AWS|
|25|Technologie specifique (SQL|
|25|Office365|
|25|Azure|
|23|PowerShell Core (.Net Core)|
|15|Débuter avec PowerShell|
|1|Powercli|
|1|DSC Core ;)|

## Question: VotreNiveau

|Compte|Reponse|
|---|---|
|21|Confirmé/Avancé (Ecrire des functions Avancé, gestion d'erreurs, Creation de module, ...)|
|16|Intermediare (Creation de scripts simple et/ou function simple, copie et modification de scripts trouvé en ligne)|
|6|Expert (Utilisation quotidienne, integration CI/CD avec Unit Testing/Script analyzing, DSC, ...)|
|6|Debutant (Quelques lignes de commandes par-ci par-la...)|

FrPSUG-Parse_survey_sondage.ps1

# Load file
$Content = import-csv 'responses.csv' -Header time,VotreNiveau,HeureParfaite,NiveauDesPresentations,Sujet |
select -Skip 1 |
select -prop VotreNiveau,HeureParfaite,NiveauDesPresentations,Sujet

# Create some arrays
$allHeureParfaitevalues=@()
$allSujetvalues=@()

# Retrieve properties (questions) and foreach...
$Content|gm -MemberType NoteProperty|Select-Object -ExpandProperty name|?{$_}|%{
    # Capture current property
    $prop = $_

    switch ($prop){
        'time' {<#do nothing#>;break}
        'HeureParfaite' {
                # each answer might contains multiple choices
                $Content|select -ExpandProperty $prop|%{
                    # remove whitespaces, split on comma and replace some useless '...'
                    $allHeureParfaitevalues += $_ -replace '\s+' -split ','|? {$_ -notmatch [regex]::Escape('...)')}
                }
                # store the report
                $report = $allHeureParfaitevalues|Group
            }
        'Sujet' {
                # each answer might contains multiple choices
                $Content|select -ExpandProperty $prop|%{
                    # Remove '... )' or '...)' and split on comma, trim the spaces on extremities and keep only non-null values
                    $allSujetvalues += ($_ -replace '\.\.\.\)|\.\.\.\s+\)' -split ',').trim()|where{$_}
                }
                # store into report
                $report = $allSujetvalues|Group
            }
        default {
            # for other simple entries, just group on the current question property name
            $report=$Content|select -ExpandProperty $prop|group}
    }


    # show each report into Out-GridView
    #$report |Out-GridView -Title $prop

    # Create a Markdown report table
    $MarkdownTable = ,"## Question: $prop"
    $MarkdownTable += "|Compte|Reponse|"
    $MarkdownTable += "|---|---|"

    $report|Sort Count -Des |%{
        $MarkdownTable+="|**$($_.Count)**|$($_.Name)|"
    }

    $MarkdownTable
}

Responses.csv