def parseChoices(workbook, errorMessageList):
""" parsing the choices sheet
returns a dictionary containing all of the choice list names and their choices
"""
choicesSheet = getSheet(workbook, 'choices')
choicesDict = {
} # all multiple choice lists stored here, in the format 'key' --> [list, of, values]
list_nameNumber = findColumnWithHeading('list name', choicesSheet)
nameNumber = findColumnWithHeading('name', choicesSheet)
# makes a list that represents the list_name column, taking that element from ever row except for the 0th one (the one with the heading in it)
list_nameColumn = [row[list_nameNumber] for row in choicesSheet[1:]]
nameColumn = [row[nameNumber] for row in choicesSheet[1:]]
#######MAKE NEW HELPER FUNCTION######
emptyRows = []
for row, cell in enumerate(list_nameColumn):
if cell == "":
if nameColumn[row] == "":
emptyRows.append(row)
else:
errorMessageList.append(
"ERROR: CHOICES -- 'list name' is blank in row " +
str(row + 2))
emptyRows.sort()
emptyRows.reverse()
for row in emptyRows:
list_nameColumn.pop(row)
nameColumn.pop(row)
for row, cell in enumerate(nameColumn):
if cell == "":
errorMessageList.append(
"ERROR: CHOICES -- 'name' is blank in row " + str(row + 2))
#####END HELPER FUNCTION###
# print "list_nameColumn is this long: "+str(len(list_nameColumn))
# print list_nameColumn
for row, list_name in enumerate(list_nameColumn):
correspondingChoiceName = nameColumn[row]
if list_name == "" or correspondingChoiceName == "":
continue
if list_name not in choicesDict.keys():
choicesDict[list_name] = [correspondingChoiceName]
else:
# if the value is already in the list, warn about it
if correspondingChoiceName in choicesDict[list_name]:
errorMessageList.append(
"ERROR: CHOICES -- " + str(correspondingChoiceName) +
" listed twice as a choice for the list " + list_name)
else:
choicesDict[list_name].append(correspondingChoiceName)
return choicesDict
def parseChoices(workbook, errorMessageList):
""" parsing the choices sheet
returns a dictionary containing all of the choice list names and their choices
"""
choicesSheet = getSheet(workbook, 'choices')
choicesDict = {} # all multiple choice lists stored here, in the format 'key' --> [list, of, values]
list_nameNumber = findColumnWithHeading('list name', choicesSheet)
nameNumber = findColumnWithHeading('name', choicesSheet)
# makes a list that represents the list_name column, taking that element from ever row except for the 0th one (the one with the heading in it)
list_nameColumn = [row[list_nameNumber] for row in choicesSheet[1:]]
nameColumn = [row[nameNumber] for row in choicesSheet[1:]]
#######MAKE NEW HELPER FUNCTION######
emptyRows = []
for row, cell in enumerate(list_nameColumn):
if cell == "":
if nameColumn[row] == "":
emptyRows.append(row)
else:
errorMessageList.append("ERROR: CHOICES -- 'list name' is blank in row "+str(row+2))
emptyRows.sort()
emptyRows.reverse()
for row in emptyRows:
list_nameColumn.pop(row)
nameColumn.pop(row)
for row, cell in enumerate(nameColumn):
if cell == "":
errorMessageList.append("ERROR: CHOICES -- 'name' is blank in row "+str(row+2))
#####END HELPER FUNCTION###
# print "list_nameColumn is this long: "+str(len(list_nameColumn))
# print list_nameColumn
for row, list_name in enumerate(list_nameColumn):
correspondingChoiceName = nameColumn[row]
if list_name == "" or correspondingChoiceName == "":
continue
if list_name not in choicesDict.keys():
choicesDict[list_name] = [correspondingChoiceName]
else:
# if the value is already in the list, warn about it
if correspondingChoiceName in choicesDict[list_name]:
errorMessageList.append("ERROR: CHOICES -- "+str(correspondingChoiceName)+" listed twice as a choice for the list "+list_name)
else:
choicesDict[list_name].append(correspondingChoiceName)
return choicesDict
def parseQuestions(workbook, errorMessageList):
""" making the Question objects and populating them """
surveySheet = getSheet(workbook, 'survey')
questionsList = []
# figure out which columns are used in the survey sheet
columnList = [
heading for heading in surveySheet[0] if heading in possibleColumns
]
# make sure the question objects get those attributes added properly
##########MAKE HELPER FUNCTION########
#questionTypeNumber = findColumnWithHeading('type', surveySheet)
#nameNumber = findColumnWithHeading('name', surveySheet)
#labelNumber = findColumnWithHeading('label', surveySheet)
# starts at 1 because the 0th row is full of headings
for r, row in enumerate(surveySheet):
if r == 0:
continue
# creating a dictionary mapping the cell in each column to the right name
inputs = {}
for heading in possibleColumns:
if heading in columnList:
if heading == 'type':
inputs['questionType'] = row[findColumnWithHeading(
heading, surveySheet)]
else:
inputs[heading] = row[findColumnWithHeading(
heading, surveySheet)]
else:
inputs[heading] = None
questionsList.append(
Question(row=r + 1,
appearance=inputs['appearance'],
questionType=inputs['questionType'],
name=inputs['name'],
label=inputs['label'],
constraint=inputs['constraint'],
constraint_message=inputs['constraint_message'],
required=inputs['required'],
relevant=inputs['relevant'],
repeat_count=inputs['repeat_count'],
calculation=inputs['calculation'],
hint=inputs['hint']))
return questionsList
def parseQuestions(workbook, errorMessageList):
""" making the Question objects and populating them """
surveySheet = getSheet(workbook, 'survey')
questionsList = []
# figure out which columns are used in the survey sheet
columnList = [heading for heading in surveySheet[0] if heading in possibleColumns]
# make sure the question objects get those attributes added properly
##########MAKE HELPER FUNCTION########
#questionTypeNumber = findColumnWithHeading('type', surveySheet)
#nameNumber = findColumnWithHeading('name', surveySheet)
#labelNumber = findColumnWithHeading('label', surveySheet)
# starts at 1 because the 0th row is full of headings
for r, row in enumerate(surveySheet):
if r == 0:
continue
# creating a dictionary mapping the cell in each column to the right name
inputs = {}
for heading in possibleColumns:
if heading in columnList:
if heading == 'type':
inputs['questionType'] = row[findColumnWithHeading(heading, surveySheet)]
else:
inputs[heading] = row[findColumnWithHeading(heading, surveySheet)]
else:
inputs[heading] = None
questionsList.append(Question(
row=r+1,
appearance=inputs['appearance'],
questionType=inputs['questionType'],
name=inputs['name'],
label=inputs['label'],
constraint=inputs['constraint'],
constraint_message=inputs['constraint_message'],
required=inputs['required'],
relevant=inputs['relevant'],
repeat_count=inputs['repeat_count'],
calculation=inputs['calculation'],
hint=inputs['hint']))
return questionsList
