function import_rra()

in misc/RRA2Spreadsheet.js [39:108]

• 59 lines of code
• 12 McCabe index (conditional complexity)

function import_rra(fid) {
  var doc = DocumentApp.openById(fid);
  var docid = doc.getId();
  var tables = doc.getBody().getTables();
  var paragraphs = doc.getBody().getParagraphs();
  // These are not the manual "marked as reviewed" dates, but actual modification/creation date of the document
  var creation_date = DriveApp.getFileById(fid).getDateCreated();
  var modification_date = DriveApp.getFileById(fid).getLastUpdated();
  var levels = ['UNKNOWN', 'LOW', 'MEDIUM', 'HIGH', 'MAXIMUM']; //order matters
  var recs = [];
  var highest_rec_rank = 0;
  var results = [];
  
  // First table has metadata
  var meta_table = tables[0];
  var i =0;
  
  if (meta_table.getNumRows() > 1) {
    // do we have a service name cell? if yes skip it, we already have the name in the file name
    if (meta_table.getCell(0,0).getText().split('\n')[0] == 'Service Name') {
      i = i+1
    }
    var serviceowner =   meta_table.getCell(i,1).getText().split('\n')[0];
    results.push(['Service Owner', serviceowner]); i=i+1;
    var director =       meta_table.getCell(i,1).getText().split('\n')[0];
    results.push(['Director', director]); i=i+1;
    var classification = meta_table.getCell(i,1).getText().split('\n')[0];
    results.push(['Service Data Classfication', classification]); i=i+1;
    var impact =         meta_table.getCell(i,1).getText().split('\n')[0];
    results.push(['Highest Risk Impact', impact]); i=i+1;
  }
  
  // Find recommendations (this loop is a little hackish, but i couldnt find a good way to iterate without changing the original docs/adding bookmarks f.e.)
  for (var p=0;p<paragraphs.length;p++) {
    var current = paragraphs[p];
    if (current.getText() == 'Recommendations') {
      for (var p1=p;p1<paragraphs.length;p1++) {
        var line = paragraphs[p1];
        if (line.getType() == DocumentApp.ElementType.LIST_ITEM) {
          //Find if we have a recommendation level associated with the recommendation list item
          var rec_level = 'UNKNOWN';
          for (var l=0;l<levels.length;l++) {
            if (line.getText().split(' ')[0] == levels[l]) {
              rec_level = levels[l];
              // Find highest rec
              if (l > highest_rec_rank) {
                highest_rec_rank = l;
              }
              break;
            }
          }
          // Check that the rec is not solved/strikedout
          // And that it isn't just a sub list item (i.e. it has a rec_level)
          var attrs = line.getAttributes();
          if (attrs[DocumentApp.Attribute.STRIKETHROUGH] != true && rec_level != 'UNKNOWN') {
            recs.push([highest_rec_rank, rec_level, line.getText()]);
          } else {
            Logger.log('Recommendation already striked out, skipping');
          }
        }
      }
      break;
    }
  }
  results.push(['Recommendations', recs.length]);
  results.push(['Highest Recommendation', levels[highest_rec_rank]]);
  results.push(['Creation date', creation_date]);
  results.push(['Modification date', modification_date]);
  return results
}