Index: build/Alarms.xlsx =================================================================== diff -u -rbb4609aa273498094986cc89849f62b861256a72 -r2f89acf0f54eca3bc72407474302b87980181ff7 Binary files differ Index: build/alarmMapping.py =================================================================== diff -u -rca9cd0f4809f448d5622f991d46b88cd497a88c8 -r2f89acf0f54eca3bc72407474302b87980181ff7 --- build/alarmMapping.py (.../alarmMapping.py) (revision ca9cd0f4809f448d5622f991d46b88cd497a88c8) +++ build/alarmMapping.py (.../alarmMapping.py) (revision 2f89acf0f54eca3bc72407474302b87980181ff7) @@ -23,11 +23,11 @@ alarms = exl['Alarms' ] else: print('Alarms sheet not found') - - -col_alarms_id = 14 #9 + +col_alarms_id = 15 #9 col_alarms_title = 8 #5 -col_alarms_message = 10 #6 +col_alarms_alarmName = 9 +col_alarms_message = 11 #6 # it has been assumed that for each alarm multiple lines of instruction will follow. # there are a lot of other options to get instruction but the output CSV format/structure is important. @@ -56,8 +56,12 @@ val = alarms.cell(row=row, column=col_alarms_message ).value val_alarm_message = "" if val == None or val == 'N/A' else val.strip() - conf_content += "Title = {}\n" .format(val_alarm_title ) - conf_content += "Message = {}\n" .format(val_alarm_message ) + val = alarms.cell(row=row, column=col_alarms_alarmName ).value + val_alarm_alarmName = "" if val == None or val == 'N/A' else val.strip() + + conf_content += "Title = {}\n" .format(val_alarm_title ) + conf_content += "AlarmName = {}\n" .format(val_alarm_alarmName ) + conf_content += "Message = {}\n" .format(val_alarm_message ) val = alarms.cell(row=row, column=col_instruction_title ).value val_instruction_title = "" if val == None or val == 'N/A' else val.strip()