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!

 

Regards,

Smart Home Forum by FIBARO Team


  • 0

General sensor activity plots


Joska

Question

Fibaro includes an energy panel for the graphic representation of actors and a temperature panel for similar purpose.

Is there a way to monitor and download the sensor data of other sensors, like humidity, burglary, LUX, etc ?

I would propose, to create a generic sensor panel (similarly to the current temperature panel), where you can select which ever sensor you want to analyze.

How can I get the humidity data analyzed and exported?

Are there any plans to implement something like this?

thnks

Josef

  • Like 2
Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

 

http://192.168.1.36/api/panels/history?from=505952000&to=1508579311&deviceID=547
http://192.168.1.36/api/panels/event?from=1433076212&to=1433079828&type=time&deviceID=732,546
http://192.168.1.36/api/panels/event?from=1433076212&to=1433079828&type=time&deviceID=9
 

 

about temperature

 

http://192.168.1.36/api/temperature/now-36000/now/summary-graph/devices/temperature/9

 

 

192.168.1.36 - your HC

Link to comment
Share on other sites

  • 0
  • Inquirer
  • Thanks for the hints. The easiest for me is to download the data with

    Please login or register to see this link.

      (nnn is the rest of the TCP/IP address of your device)

    This downloads all available device data.

     

    For the analysis and visualisation, I created an Excel file converting the times, and sorting all the data by device. While this works, this is neither elegant, nor professional....

     

    So the question remains, when Fibaro will be so glad to provide a professional interface.

    (By the way, the current temperature visualisation solution of fibaro is not really elegant and user friendly either....)

     

    Link to comment
    Share on other sites

    • 0
    On 4/27/2018 at 10:25 AM, AndyY said:

    +1

     

    On 11/2/2018 at 1:22 PM, Joska said:

    Thanks for the hints. The easiest for me is to download the data with

    Please login or register to see this link.

      (nnn is the rest of the TCP/IP address of your device)

    This downloads all available device data.

     

    For the analysis and visualisation, I created an Excel file converting the times, and sorting all the data by device. While this works, this is neither elegant, nor professional....

     

    So the question remains, when Fibaro will be so glad to provide a professional interface.

    (By the way, the current temperature visualisation solution of fibaro is not really elegant and user friendly either....)

     

    Hi Joska! Please, can tell me how do you exported the series in excel from the format that is outputed by the api   

    Please login or register to see this link.

     ?

    The raw data outputed by the apy look something like  

     

    [{"id":12,"deviceID":21,"timestamp":1541824110,"value":"12.29"},{"id":11,"deviceID":21,"timestamp":1541820014,"value":"12.48"}, ...]

     

    Thanks!

    Edited by LMD
    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • Dear LMD

     

    Export the sensor data as formatted. This should look like this

    Please login or register to see this image.

    /monthly_2018_11/image.png.0047dc456436bec9d8d9156fcdcc0a52.png" alt="image.png.0047dc456436bec9d8d9156fcdcc0a52.png" />

    Import in Excel and copy-paste into the "RawData" worksheet of the attached Excel workbook.

    There are two result worksheets:

    1) The worksheet "Processed" just re-formats and lists the data in chronological order as it is usual in Excel. As the data in this worksheet can not be sorted (well it could, if one copy-paste it as text), I made an trial to make individual colums for each device.

    2) The worksheet "Tabulated " does the same as before, but puts the data of each device into it's own device-specific column.

    Of course, you can extend the ranges just by "pulling" the cells.

    The files can get quite large, so perhaps a macro doing the same would

    Have fun

     

    Josef

     

    Please login or register to see this attachment.

    Link to comment
    Share on other sites

    • 0
    1 hour ago, Joska said:

    Dear LMD

     

    Export the sensor data as formatted. This should look like this

    Please login or register to see this link.

    Import in Excel and copy-paste into the "RawData" worksheet of the attached Excel workbook.

    There are two result worksheets:

    1) The worksheet "Processed" just re-formats and lists the data in chronological order as it is usual in Excel. As the data in this worksheet can not be sorted (well it could, if one copy-paste it as text), I made an trial to make individual colums for each device.

    2) The worksheet "Tabulated " does the same as before, but puts the data of each device into it's own device-specific column.

    Of course, you can extend the ranges just by "pulling" the cells.

    The files can get quite large, so perhaps a macro doing the same would

    Have fun

     

    Josef

     

    Please login or register to see this attachment.

    Thanks Josef!

    The problem is that after I access the data from Fibaro api, using  http://192.168.0.100/api/panels/event?from=0&to=10000000000

     

    I receive a file formated in json format:

    Please login or register to see this code.

     

    The problem is that I do not know how I can import it in your first sheet, called "RawData": copy-paste will not work because will paste all the data in the first cell, and not in the format that you present in "RawData" sheet .

    Link to comment
    Share on other sites

    • 0

    in case you are still looking for a solution. i opened the text file in word. did 'find replace' on },{ with a manual line break (see 'special' box at bottom of replace menu). and then removed the [{ and }] strings at beginning and end. 

     

    resaved the file as .txt and then imported to excel as comma delimitted text. 

     

    far from elegant. but it did the trick...

    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Answer this question...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...