Hi Team, I dont know why my attributes “latched” with Boolean data does not display.
import dash
from dash import dash_table
from dash.dash_table.Format import Group
from dash import dcc
from dash import html
import plotly.express as px
import pandas as pd
from dash.dependencies import Input, Output, State
from flask_sqlalchemy import SQLAlchemy
from flask import Flask
app = dash.Dash(__name__)
databasetemplate = "/mnt/hgfs/FSD_Drive/Database/" + "02. Database Template.xlsx"
event_detection = pd.read_excel(databasetemplate, sheet_name = 'event_detection')
event_action = pd.read_excel(databasetemplate, sheet_name = 'event_action')
execution_timeline = pd.read_excel(databasetemplate, sheet_name = 'execution_timeline')
severity = pd.read_excel(databasetemplate, sheet_name = 'severity')
status = pd.read_excel(databasetemplate, sheet_name = 'status')
cause = pd.read_excel(databasetemplate, sheet_name = 'failure_cause')
damage = pd.read_excel(databasetemplate, sheet_name = 'failure_mode')
action = pd.read_excel(databasetemplate, sheet_name ='Activity')
user = pd.read_excel(databasetemplate, sheet_name = 'user')
closeout = pd.read_excel(databasetemplate, sheet_name ='closeout')
colors = {
'background': '#111111',
'text': '#7FDBFF'
}
tabs_styles = {'zIndex': 99, 'display': 'inlineBlock', 'height': '4vh', 'width': '12vw',
'position': 'fixed', "background": "#323130", 'top': '12.5vh', 'left': '7.5vw',
'border': 'grey', 'border-radius': '4px'}
tab_style = {
"background": "#323130",
'text-transform': 'uppercase',
'color': 'white',
'border': 'grey',
'font-size': '11px',
'font-weight': 600,
'align-items': 'center',
'justify-content': 'center',
'border-radius': '4px',
'padding':'6px'
}
tab_selected_style = {
"background": "grey",
'text-transform': 'uppercase',
'color': 'white',
'font-size': '11px',
'font-weight': 600,
'border': 'grey',
'align-items': 'center',
'justify-content': 'center',
'border-radius': '4px',
'padding':'6px'
}
event_detection_table = html.Div([
html.H1(children ='Event Detection',
style = { 'textAlign' : 'center','color' : colors['text']}
),
dash_table.DataTable(
id = 'event_detection_table',
data = event_detection.to_dict('records'),
columns = [
{'id':'event_id', 'name': 'event_id'},
{'id':'event_start_time', 'name': 'event_start_time'},
{'id':'event_end_time', 'name': 'event_end_time'},
{'id':'event_condition', 'name': 'event_condition'},
{'id':'tag_description', 'name': 'tag_description'},
{'id':'tag_code', 'name': 'tag_code'},
{'id':'tag_limit', 'name': 'tag_limit'},
{'id':'value_of_limit', 'name': 'value_of_limit'},
{'id':'threshold_value', 'name': 'threshold_value'},
{'id':'lacthed', 'name': 'latched'},
{'id': 'trigger_delay_sec', 'name': 'trigger_delay_sec'}
],
filter_action = "native",
sort_action = "native",
sort_mode = "multi",
merge_duplicate_headers=True,
),
html.Div(id='table-dropdown-1')
])
event_action_table = html.Div([
html.H1(children ='Event Action',
style = { 'textAlign' : 'center','color' : colors['text']}
),
dash_table.DataTable(
id = 'event_action_table',
data = event_action.to_dict('records'),
columns = [
{'id':'event_id', 'name': 'Event ID'},
{'id':'CMMS_ref_no', 'name': 'CMMS Ref No.'},
{'id':'severity', 'name': 'Severity', 'presentation': 'dropdown'},
{'id':'status', 'name': 'Status', 'presentation': 'dropdown'},
{'id':'owner', 'name': 'Owner', 'editable':True},
{'id': 'risk_ranking', 'name': 'Risk Ranking'}
],
filter_action = "native",
sort_action = "native",
sort_mode = "multi",
export_format='xlsx',
export_headers='display',
merge_duplicate_headers=True,
dropdown = {
'severity': {
'options':[
{'label': i, 'value': i}
for i in severity['severity'].unique()
]
},
'status': {
'options':[
{'label': i, 'value': i}
for i in status['status'].unique()
]
}
}
),
html.Div(id='table-dropdown-2')
])
closeout_table = html.Div([
html.H1(children ='Closeout',
style = { 'textAlign' : 'center','color' : colors['text']}
),
dash_table.DataTable(
id = 'closeout_table',
data = closeout.to_dict('records'),
columns = [
{'id':'event_id', 'name': 'Event ID'},
{'id':'cause', 'name': 'Cause', 'presentation':'dropdown'},
{'id':'damage', 'name': 'Damage', 'presentation':'dropdown'},
{'id':'action', 'name': 'Action', 'presentation':'dropdown'},
{'id': 'closeout_date', 'name': 'Closeout Date'}
],
editable =True,
filter_action = "native",
sort_action = "native",
sort_mode = "multi",
export_format='xlsx',
export_headers='display',
merge_duplicate_headers=True,
dropdown = {
'cause': {
'options': [
{'label': i, 'value': i}
for i in cause["Failure_Cause"].unique()
],
'clearable': False
},
'damage': {
'options': [
{'label': i, 'value': i}
for i in damage["Failure_Mode"].unique()
],
'clearable': False
},
'action': {
'options': [
{'label': i, 'value': i}
for i in action["Activity"].unique()
],
'clearable': False
}
}
),
html.Div(id='table-dropdown-3')
])
app.layout = html.Div([
dcc.Tabs(id='tabs-example', value='tab-1', children=[
dcc.Tab(label='Event Detection', value='tab-1', style=tab_style, selected_style=tab_selected_style),
dcc.Tab(label='Event Action', value='tab-2', style=tab_style, selected_style=tab_selected_style),
dcc.Tab(label='Close Out', value='tab-3', style=tab_style, selected_style=tab_selected_style),
]),
html.Div(id='tabs-example-content-1'),
])
@app.callback(
Output('tabs-example-content-1', 'children'),
Input('tabs-example', 'value')
)
def render_content(tab):
if tab == 'tab-1':
return event_detection_table
elif tab == 'tab-2':
return event_action_table
elif tab == 'tab-3':
return closeout_table
if __name__ == '__main__':
app.run_server(debug=True)
Looking forward for anyone who can help on it?
Thank you 
