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

Export temperature chart data


Neo Andersson

Question

Guys, anyone know how can i export temperature sensor's data from chart?

I need to get a longer period (a month maybe) with all values and times measured by the sensor.

Thanks in advance

  • Like 1
Link to comment
Share on other sites

Recommended Posts

  • 0
1 hour ago, Neo Andersson said:

Guys, anyone know how can i export temperature sensor's data from chart?

I need to get a longer period (a month maybe) with all values and times measured by the sensor.

Thanks in advance

Please login or register to see this code.

 

Edited by jgab
  • Like 2
Link to comment
Share on other sites

  • 0

That's different...

Btw, I edited the post, you should addd hour=0

Link to comment
Share on other sites

  • 0
  • Inquirer
  • 22 minutes ago, jgab said:

    That's different...

    Btw, I edited the post, you should addd hour=0

    Can you show me the way i get binary switch events?

    Please

    Edited by Neo Andersson
    Link to comment
    Share on other sites

    • 0
    40 minutes ago, Neo Andersson said:

    Can you show me the way i get binary switch events?

    Please login or register to see this code.

     

    • Like 1
    Link to comment
    Share on other sites

    • 0

    @jgabJust what I need!

    I added your rules in ER5 QA

    Can I do multiple devices?

    Please login or register to see this code.

    How I can print now to test how it looks like?

    Can the date be exported to email?

    Edited by Sjakie
    Link to comment
    Share on other sites

    • 0
    8 hours ago, Sjakie said:

    @jgabJust what I need!

    I added your rules in ER5 QA

    Can I do multiple devices?

    Please login or register to see this code.

    How I can print now to test how it looks like?

    Can the date be exported to email?

    No, you need to call it for each device.

    Well, printData(data) will print it to the console.

    To email, in theory yes, are there any length limits? 

    • Like 1
    Link to comment
    Share on other sites

    • 0

    Wow great!

    Is it possible to have the "RoomName". "DeviceID before the date?

    Lengt limits? As in email I don't know but will see if it's coming true yes or no. If there is a limit I can choose one week instead of a month?

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • @jgab Jan this is a mega help for me but i have found some unexpected results.

    Please check this..How is this possible. I m checking device 316 events. This is in history from Fibaro UI

    Please login or register to see this attachment.

     

    The export function did not find any entry for this device. Not only for this particular date, but at all.

     

    Please login or register to see this code.

     

    How is it possible?

     

    I have tried to manually turn off an on th device, than the on off event shows up, but only this one from todays test, nothing from the past.

     

    Link to comment
    Share on other sites

    • 0

    Did you add the hour=0 in

    Please login or register to see this code.

    ?

     

    Secondly, what kind of device is it?

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • 41 minutes ago, jgab said:

    Did you add the hour=0 in

    Please login or register to see this code.

    ?

     

    Secondly, what kind of device is it?

    Yes, there is the hour argumen, i am using the sheer copy of your last post.

    It is a binary switch

    Link to comment
    Share on other sites

    • 0
    1 hour ago, Sjakie said:

    Wow great!

    Is it possible to have the "RoomName". "DeviceID before the date?

    Lengt limits? As in email I don't know but will see if it's coming true yes or no. If there is a limit I can choose one week instead of a month?

    This sends the temps for the last week every Sunday

    Please login or register to see this code.

    I'm a bit unsure if you get html codes in the message - let me know...

    Edited by jgab
    Link to comment
    Share on other sites

    • 0
    10 minutes ago, Neo Andersson said:

    Yes, there is the hour argumen, i am using the sheer copy of your last post.

    It is a binary switch

    Is save events to history enabled for the device?

    Please login or register to see this image.

    /monthly_2024_01/image.png.be07741efe5ac59f52fd63515376b7dd.png" />

    Yes, it should be. you show me the history...

    What does it say if you log the raw data from the api

    Please login or register to see this code.

     

    Link to comment
    Share on other sites

    • 0

    It's kind of a bug, it doesn't include the last day so last day should be set to +1 day, because it starts and end at 00:00 the days specified

    Edited by jgab
    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • 16 minutes ago, jgab said:

    Is save events to history enabled for the device?

    Please login or register to see this link.

    Yes, it should be. you show me the history...

    What does it say if you log the raw data from the api

    Please login or register to see this code.

     

    Please login or register to see this code.

    Sorry i cant format to JSON here

     

    Please login or register to see this image.

    /monthly_2024_01/image.png.90cba36f8370ce2665431f16dbdfa46b.png" />

    Edited by Neo Andersson
    Link to comment
    Share on other sites

    • 0

    If I replace your data as the response to the api call 

    Please login or register to see this code.

    I get

    Please login or register to see this code.

     

    Edited by jgab
    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • 6 minutes ago, jgab said:

    If I replace your data as the response to the api call 

    Please login or register to see this code.

    I get

    Please login or register to see this code.

     

    Yes me too

    The 18 jan event is my test. I just turned OFf and ON the device to see if it shows up..It shows up but nothing from the past

    1 minute ago, Neo Andersson said:

    Yes me too

    The 18 jan event is my test. I just turned OFf and ON the device to see if it shows up..It shows up but nothing from the past

    Maybe it is som bug in Fibaro? Becuase if i roll over the history tab in web UI i can find entrys for this device. As you can see on my screenshot.

    Link to comment
    Share on other sites

    • 0
    18 minutes ago, Neo Andersson said:

    Yes me too

    The 18 jan event is my test. I just turned OFf and ON the device to see if it shows up..It shows up but nothing from the past

    Maybe it is som bug in Fibaro? Becuase if i roll over the history tab in web UI i can find entrys for this device. As you can see on my screenshot.

    Ok, but if you log data from ex. "2024-01-01" to "2024-01-17", what json data do you get then?

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • I got nill

    11 minutes ago, jgab said:

    Ok, but if you log data from ex. "2024-01-01" to "2024-01-17", what json data do you get then?

    I got nill

    3 minutes ago, Neo Andersson said:

    Please login or register to see this code.

     

     

    3 minutes ago, Neo Andersson said:

    I got empty data table

     

     

    I have changed to log function to show me if data is empty

    Please login or register to see this code.

    and i got no data at all message

    Edited by Neo Andersson
    Link to comment
    Share on other sites

    • 0
    7 minutes ago, Neo Andersson said:

    I got nill

    I got nill

     

    I have changed to log function to show me if data is empty

    Please login or register to see this code.

    and i got no data at all message

    Yes, because there are only property 'energy' and 'power' in that period. No property 'value'

    So history is saved but not property 'value' (e.g. on/off)

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • 1 minute ago, jgab said:

    Yes, because there are only property 'energy' and 'power' in that period. No property 'value'

    So history is saved but not property 'value' (e.g. on/off)

    I dont get it. How is it possible? You can see that i can see in Fibaros histry panel the enrtry for turnOn action

    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...