(Vienna, 28.10.2015)
On YouTube (recommend): "https://youtu.be/3Nz_C10Nvt4"
and Download (zip): "https://www.dropbox.com/s/vv5x2ugf4c7e4tk/SendFibaroEventDataToExcel_EN.zip?dl=1"
This is my way to transmit the fibaro-event-data in Excel spreadsheets.
Since I am a FibaroHC2-newbie, I have to read a lot of forum posts first: http://forum.fibaro.com/ (english) http://siio.de/board/ (german) And the descriptions in the developer documentation are an important tool: https://developer.fibaro.com/ (english) The forum members @petergebruers (expert of forum.fibaro.com) and @crissxcross (moderator of siio.de/board) told me several times friendly the right way.
I have found in Fibaro HC2 system is no way to write the event data in an external file.
One option was to send the data via email to me. But this grief I did not want to do to the Fibaro server.
Therefore, I use as a temporary store global variables. The global variables of Fibaro system are very powerful. In the global variable "selEventData" I have saved 1,024 kilobytes of data for testing purposes. These were 20,749 records. With this value (20,000 event-records), I have limited my system. Where the real limits lie, everyone can try out for themselves.
After the selection, so the data is available in the local variable "selBasicData" (sections, rooms and devices) and "selEventData" (events) are available. A local variable can be exported with the "HC2 Toolkit program" in a plain text file. Click the right mouse button on the line with the desired variables and select "Export". Remove the unnecessary parts at the beginning and end of the file and give it the extension ".csv". Now the data can be easily imported into an Excel spreadsheet and processed further.
This is perhaps not the best solution.
But for me the development was interesting and I learned a lot about the FibaroHC2-system. I wish you also so much fun with your Fibaro system!