EasyIoT Cloud - New version

4 years 2 months ago - 4 years 2 months ago #3249 by NightOne
The CSV file exports in Comma Seperated Values.... if you read/import in EXCEL then the top line will be the the Headings of each sensor you have in that graph.... the next line is the time....it might seem strange but its UNIX EPOCH time.... that means the machine counts the seconds(in the case of EasyIOT its milliseconds) since 1 Jan 1970....so you will need to run a formula if you want to have the value in human readable values....

=((A1/1000)/86400)+25569 or

=(A1/1000)/(60*60*24)+DATEVALUE("1/1/1970")

PS...also remember to format the cell as a date and time.... you can goto custom format and type "dd/mm/yyyy h:mm:ss"

Hope this helps
The following user(s) said Thank You: Phil77560

Please Log in or Create an account to join the conversation.

4 years 2 months ago - 4 years 2 months ago #3253 by Phil77560
thank you ... I begin to understand now... ;)
Could you show me the formula in my CSV file please ? I tried but it did not works :blush:
thank you

File Attachment:

File Name: EasyIoTClo...a(1).zip
File Size:14 KB
Attachments:

Please Log in or Create an account to join the conversation.

4 years 2 months ago #3254 by NightOne
No problem....the first file is csv with second coloum is human readable date.

Second is excel file with working formual



File Attachment:

File Name: HumanReadable.zip
File Size:85 KB
Attachments:
The following user(s) said Thank You: Phil77560

Please Log in or Create an account to join the conversation.

4 years 2 months ago #3256 by Phil77560
Oh thank you so much... I did not understand why I wasn't successful... anyway, you helped me so much thank you once more.
Regards

Please Log in or Create an account to join the conversation.

4 years 1 month ago #3361 by EasyIoT
Cloud was updated to V 0.8. Please clear browser cache to load new app. if neccessary.

What's new:
-MQTT topic prefix /Db/[instance id] is no more needed. Also you do not need myMqtt.subscribe("/Db/InstanceId"); any more. In all programs simply remove /Db/[instance id] in topic. Program example with new MQTT is here iot-playground.com/blog/2-uncategorised/...mqtt-api-v1-improved
Also you can use any custom topic. Just be careful to enter custom topic in parameter configuration.
-smal bugfixes

Please Log in or Create an account to join the conversation.

4 years 3 weeks ago #3371 by dubaleeiro
Great ! I have tested it and it worked like a charm.

Moreover, is the automation part working already? I have set up a small program to send an e-mail but it did not work.

Thanks and congratulations for the great job!

Please Log in or Create an account to join the conversation.

Time to create page: 0.221 seconds

Forum latest

  • No posts to display.