function process_all_rra_docs()

in misc/RRA2Spreadsheet.js [12:36]

• 21 lines of code
• 3 McCabe index (conditional complexity)

function process_all_rra_docs() {
  var driveid = ''; // Where assessments are stored, this is a drive id
  var template_skip_id = ''; // the template, so that we don't process that
  var s = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = s.getSheetByName('RRA3');
  var folder = DriveApp.getFolderById(driveid);
  var files = folder.getFiles();
  
  //Start fresh
  sheet.clearContents();
  // Headers
  sheet.appendRow(['Link', 'Name', 'Service Owner', 'Director', 'Service Data Classification', 'Highest Risk Impact', 'Recommendations', 'Highest Recommendation', 'Creation date', 'Modification date']);
  
  while (files.hasNext()) {
    var file = files.next();
    if (file.getId() == template_skip_id) {
      continue;
    }
    var rra_name = clean_fname(file.getName());
    s.toast("Importing RRA: "+rra_name+"...");
    var results = import_rra(file.getId());
    insert_rra('https://docs.google.com/document/d/'+file.getId(), rra_name, sheet, results);
  }
  s.toast("All done!");
}