Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,


as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.


As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!



Smart Home Forum by FIBARO Team

Search the Community

Showing results for tags 'Fibaro Data Export'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • FIBARO Community
    • FIBARO Portal and Forum policy
    • FIBARO
    • Say hello!
    • Off-topics
  • FIBARO Update
    • FIBARO System Update
    • FIBARO Mobile Update
  • FIBARO Community Support
    • Scenes and Interface
    • FIBARO Products
    • FIBARO Mobile
    • FIBARO HomeKit
    • FIBARO Assistant Integrations
    • Other Devices / Third-party devices
    • Tutorials and Guides
    • Home Automation
    • Suggestions
  • FIBARO Społeczność
    • FIBARO
    • Przywitaj się!
    • Off-topic
  • FIBARO Aktualizacja
    • FIBARO System Aktualizacja
    • FIBARO Mobile Aktualizacja
  • FIBARO Wsparcie Społeczności
    • Sceny i Interfejs
    • FIBARO Urządzenia
    • FIBARO Mobilnie
    • FIBARO HomeKit
    • Integracja z Amazon Alexa i Google Home
    • Urządzenia Firm Trzecich
    • Poradniki
    • Automatyka Domowa
    • Sugestie


  • Scenes
  • Virtual Devices
  • Quick Apps
  • Icons

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start






Website URL





Found 1 result

  1. (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!
  • Create New...