Skip to content

Instantly share code, notes, and snippets.

@kortov
Created April 22, 2018 13:12
Show Gist options
  • Save kortov/f0c73d6b629f4e36b89cad632dbfdf0b to your computer and use it in GitHub Desktop.
Save kortov/f0c73d6b629f4e36b89cad632dbfdf0b to your computer and use it in GitHub Desktop.
function myFunction() {
// var files = DriveApp.getFilesByName("Grammar test.txt");
// while (files.hasNext()) {
// var file = files.next();
// Logger.log(file.getId());
// var mimeType = file.getMimeType();
// Logger.log('MimeType:' + mimeType);
// }
// var files = DriveApp.getFilesByName("Grammar test.txt");
//
// while (files.hasNext()) {
// var file = files.next();
// Logger.log(file.getId());
// var mimeType = file.getMimeType();
// //Logger.log('MimeType:' + mimeType);
//
// //var string = file.getAs(mimeType).getDataAsString();
// //var string = file.getAs(mimeType).getDataAsString();
// var lines = file.getAs(mimeType).getDataAsString();
// //var data = file.getBlob().getDataAsString();
// // Logger.log('docContent : ' + data );
// //var lines = string.split('\n');
// //var line = lines[0];
// //Logger.log(string);
// //var s = 's';
//
// Logger.log(typeof lines);
//
// //var lines = string.split('\n');
// //var line = lines[0];
// //Logger.log('Line: '+ line);
// }
// Logger.log(typeof lines);
// Logger.log(lines);
var file = DriveApp.getFileById('1BKYE4sVMvDvXAea9wqigdZ-z5lFNME-1');
var mimeType = file.getMimeType();
var lines = file.getAs(mimeType).getDataAsString().split('\n');
//var task = lines[0];
// Logger.log('Line: '+ task);
var form = FormApp.create('Test all subjects 2').setIsQuiz(true);
form.setConfirmationMessage('Маленькие человечки проверили твои ответы, ответы можно посмотреть по ссылке ниже');
var i;
for (i = 0; i < lines.length; i++) {
var line = lines[i];
var elements = line.split('\t');
var helpText = elements[0];
var rightAnswer = elements[1];
var answer1 = elements[2];
var answer2 = elements[3];
var answer3 = elements[4];
var answer4 = elements[5];
var feedback = elements[6];
var category = elements[7];
var item = form.addMultipleChoiceItem();
item.setTitle(category)
.setChoices([
item.createChoice(answer1,rightAnswer == 1?true:false),
item.createChoice(answer2,rightAnswer == 2?true:false),
item.createChoice(answer3,rightAnswer == 3?true:false),
item.createChoice(answer4,rightAnswer == 4?true:false),
])
.showOtherOption(false);
item.setHelpText(helpText);
item.setFeedbackForCorrect(FormApp.createFeedback().setText(feedback).build());
item.setFeedbackForIncorrect(FormApp.createFeedback().setText(feedback).build());
item.setPoints(5);
item.setRequired(true);
//Logger.log('Element: '+ elements[0]);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment