Import capabilities from survey spreadsheet

import_capabilities(survey_file = system.file("survey", "survey.xlsx",
  package = "evaluator"), domains)

Arguments

survey_file

Path to survey XLSX file. If not supplied, a default sample file is used.

domains

Dataframe of domains and domain IDs.

Value

Extracted capabilities as a dataframe.

Examples

data(domains) import_capabilities(domains = domains)
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> New names: #> * `` -> `..5` #> * `` -> `..6` #> * `` -> `..7`
#> # A tibble: 60 x 4 #> capability_id domain_id capability diff #> <chr> <chr> <chr> <chr> #> 1 1 ORG A senior-level committee provides dedicate… 5 - Opti… #> 2 10 POL External authorities and industry trends a… 5 - Opti… #> 3 11 POL Policy compliance issues are documented, a… 2 - Repe… #> 4 12 POL The information security policies are defi… 2 - Repe… #> 5 13 COMP Security compliance for all critical syste… 5 - Opti… #> 6 14 ORG Self-assessment of the information securit… 4 - Mana… #> 7 15 ORG Verification of reasonable and appropriate… 2 - Repe… #> 8 16 ORG Verification of reasonable and appropriate… 2 - Repe… #> 9 17 RISK An appropriate risk identification and tre… 2 - Repe… #> 10 18 RISK Results of risk assessments, including any… 3 - Defi… #> # … with 50 more rows