Version 8.1.24
In Perspective , Add AlarmJournal Table , How to Export Data with EventValue?
system.perspective.print ('onclick start')
startDate = self.parent.parent.getChild("AlarmJournalTable").props.dateRange.historical.startDate
system.perspective.print ( str(startDate))
endDate = self.parent.parent.getChild("AlarmJournalTable").props.dateRange.historical.endDate
system.perspective.print (str(endDate))
journalName = self.parent.parent.getChild("AlarmJournalTable").props.name
system.perspective.print (journalName)
# priority =
# state =
# path =
# source =
# displaypath =
# all_properties =
# any_properties =
# defined =
includeData = True
includeSystem = False
includeShelved = True
# isSystem =False
# provider =
data = system.alarm.queryJournal(startDate = startDate, endDate = endDate, journalName = journalName,includeData=includeData,includeSystem=includeSystem,includeShelved=includeShelved)
dataset = data.getDataset()
system.perspective.print (dataset)
system.perspective.print(type(dataset))
headers = system.dataset.getColumnHeaders(dataset)
# 转换成pydataset
pydataset = system.dataset.toPyDataSet(dataset)
system.perspective.print(pydataset)
# 修改日期格式
system.perspective.print('change date')
new_rows = []
for row in pydataset:
system.perspective.print( row)
new_row = list(row)
event_time = row["EventTime"]
system.perspective.print( event_time)
if event_time is not None:
new_row[pydataset.getColumnIndex('EventTime')] = system.date.format(event_time, 'yyyy-MM-dd HH:mm:ss')
new_rows.append(new_row)
system.perspective.print(new_row)
system.perspective.print(new_rows)
newdataset = system.dataset.toDataSet(headers, new_rows)
system.perspective.print(newdataset)
# 导出CSV
system.perspective.print('start export')
filename = "alarmHistory.csv"
showHeaders = True
csv_content = system.dataset.toCSV(newdataset, showHeaders)
system.perspective.print(csv_content)
system.perspective.download(
filename=filename,
data=csv_content,
contentType="text/csv; charset=utf-8"
)
system.perspective.print(u"导出成功，请查收下载文件！")
Click Button , I can see many columns in CSV.
But I want to export EventValue to CSV, How to get?
