# Export Alarm Journal to CSV using Start and End Date **URL:** \ **Category:** Ignition\ **Created:** [July 8, 2019, 5:13am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339 "2019-07-08T05:13:17Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Callmesoon](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Callmesoon](https://forum.inductiveautomation.com/u/Callmesoon)\ **Post date:** [July 8, 2019, 5:13am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/1 "2019-07-08T05:13:17Z")
Hello, I would like to know how do i export alarm journal to CSV. ---
**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\ **Post date:** [July 8, 2019, 10:47am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/2 "2019-07-08T10:47:20Z")
```auto start = event.source.parent.getComponent('Date Range').startDate end = event.source.parent.getComponent('Date Range').endDate journal = system.alarm.queryJournal(startDate=start, endDate=end).getDataset() filePath = system.dataset.exportExcel("Journal.xls", 1, journal) if filePath != None: system.net.openURL("file://"+filePath) ``` ---
**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\ **Post date:** [July 8, 2019, 10:54am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/3 "2019-07-08T10:54:05Z")
Sorry, you said CSV, not excel… ```auto start = event.source.parent.getComponent('Date Range').startDate end = event.source.parent.getComponent('Date Range').endDate journal = system.alarm.queryJournal(startDate=start, endDate=end).getDataset() csv = system.dataset.toCSV(journal) filePath = system.file.saveFile("mycsv.csv", "csv", "CSV File") if filePath: system.file.writeFile(filePath, csv) ``` ---
**Author:** ![Callmesoon](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Callmesoon](https://forum.inductiveautomation.com/u/Callmesoon)\ **Post date:** [July 9, 2019, 1:18am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/4 "2019-07-09T01:18:20Z")
Thank you so much for your help. ---
**Author:** ![Aybars.Urut](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aybars.urut/32/32003_2.png) [@Aybars.Urut](https://forum.inductiveautomation.com/u/Aybars.Urut)\ **Post date:** [February 18, 2022, 6:35am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/5 "2022-02-18T06:35:52Z")
hi Jonathan, its working but when i export the alarm journal only “EventId”, “Source”, “DisplayPath”, “EventTime”, “EventState”, “Priority”, “IsSystemEvent” are coming. how can i manage these columns. i also want to export “Label”. Thanks in advance. ---
**Author:** ![Darenn\_Yfrelle\_Villa](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@Darenn\_Yfrelle\_Villa](https://forum.inductiveautomation.com/u/Darenn_Yfrelle_Villa)\ **Post date:** [April 6, 2022, 10:37am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/6 "2022-04-06T10:37:01Z")
> [@jonathan.taylor](#): > > ```auto > start = event.source.parent.getComponent('Date Range').startDate > end = event.source.parent.getComponent('Date Range').endDate > journal = system.alarm.queryJournal(startDate=start, endDate=end).getDataset() > csv = system.dataset.toCSV(journal) > > filePath = system.file.saveFile("mycsv.csv", "csv", "CSV File") > > if filePath: > system.file.writeFile(filePath, csv) > > ``` hi did you solve this problem? this is my current problem right now ---
**Author:** ![Aybars.Urut](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aybars.urut/32/32003_2.png) [@Aybars.Urut](https://forum.inductiveautomation.com/u/Aybars.Urut)\ **Post date:** [April 6, 2022, 11:40am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/7 "2022-04-06T11:40:15Z")
Hi Daren, As I understand you want to see data that is not directly in the table like me. So I used the following code for this; ```auto from com.inductiveautomation.ignition.common.config import BasicProperty eventTime = BasicProperty("eventTime", BasicProperty().getType()) start = event.source.parent.getComponent('Alarm Journal').startDate end = event.source.parent.getComponent('Alarm Journal').endDate alarms = system.alarm.queryJournal(startDate=start, endDate=end) headers = ["EventTime", "Label", "DiplayPath", "SourcePath","Priority"] data = [] for alarm in alarms: data.append([alarm.get(eventTime),alarm.getLabel(), alarm.getDisplayPath(), alarm.getSource(), alarm.getPriority()]) val = system.dataset.toDataSet(headers, data) filePath = system.dataset.exportExcel("AlarmJournal", 1, val) if filePath != None: system.net.openURL("file://"+filePath) ``` the important point here is “system.alarm.queryJournal()” For detailed information about this command; [https://docs.inductiveautomation.com/display/DOC81/system.alarm.queryJournal](https://docs.inductiveautomation.com/display/DOC81/system.alarm.queryJournal) ---
**Author:** ![Darenn\_Yfrelle\_Villa](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@Darenn\_Yfrelle\_Villa](https://forum.inductiveautomation.com/u/Darenn_Yfrelle_Villa)\ **Post date:** [April 6, 2022, 11:48am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/8 "2022-04-06T11:48:43Z")
Hi to All, I want to export a csv file through a component of BUTTON from the Alarm Journal, I did it using this script: **dataset = event.source.parent.getComponent(‘Alarm Journal’).getAlarms()** **file = system.date.now() \*\* path = system.dataset.exportCSV(“data.csv”, 1, dataset) if path != None: \*\* system.net.openURL(“file://”+path)** …unfortunately, I’m not satisfied because the result (csv file) is lack of information, the event time is incomplete, I want to include the Date and there are missing columns when it exported. How can I solve this one? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/b/1b29f8dfa4330c4630a85460c6fccb344cc797ea.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/e/6e8c68a5a923ca61eb141db1a216349bf5af2e37.png) Any ideas? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 6, 2022, 11:50am UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/9 "2022-04-06T11:50:33Z")
Posting the same question in multiple topics is against this forum's rules. You posted this over here: > [@Alarm Journal CSV export](https://forum.inductiveautomation.com/t/alarm-journal-csv-export/58100): > > Hi to All, I want to export a csv file through a component of BUTTON from the Alarm Journal, I did it using this script: dataset = event.source.parent.getComponent(‘Alarm Journal’).getAlarms() file = system.date.now() \*\* path = system.dataset.exportCSV(“data.csv”, 1, dataset) if path != None: \*\* system.net.openURL(“file://”+path) …unfortunately, I’m not satisfied because the result (csv file) is lack of information, the event time is incomplete, I want to include the Date and there are … ---
**Author:** ![Darenn\_Yfrelle\_Villa](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@Darenn\_Yfrelle\_Villa](https://forum.inductiveautomation.com/u/Darenn_Yfrelle_Villa)\ **Post date:** [April 6, 2022, 12:52pm UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-csv-using-start-and-end-date/26339/10 "2022-04-06T12:52:50Z")
noted sir, thank you