Skip to main content
N
nagrawal-21-Visitor
1-Visitor
October 4, 2017
Solved

Best practise to store historical data plus live streaming data in a Thing

  • October 4, 2017
  • 1 reply
  • 8209 views

Hi,

 

What should be the best practice to store the historical data from Excel and then later start storing Live streaming data in same properties of a Thing. I know as per the documentation, I should use Datatables to store static or historical data and Value Streams for Live streaming data but my setup is different. Initially, I need to push some Historical data of a device and later the same device will start pushing live data in TW. I am not sure how would I proceed to achieve this.

 

Please suggest me the best way possible.

Thanks in advance.

 

Best regards,

Neetu

Best answer by nagrawal-2

Hi Carles,

I have resolved the issue. It's not about passing the date-time value in CSV, I had to change the date format in params object:

dateformat: "yyyy-MM-dd HH:mm:ss"

The string should be in exact above format (Case sensitive) to make it work.

Thanks for your support.

Regards,

Neetu

1 reply

C
CarlesColl1-Visitor
1-Visitor
October 5, 2017

If it's the same data that will be recorded live, than all have to go to the same storage, in this case Stream or ValueStream.

N
nagrawal-21-VisitorAuthor
1-Visitor
October 5, 2017

Hi Carles,


Thanks for your response.

Yes format of data will be same when recording live. But initially I will be pushing the data from CSV ? Can I push the CSV data in Value Stream?


Regards,

Neetu

C
CarlesColl1-Visitor
1-Visitor
October 5, 2017

Yes for sure, you can read CSV files with the following extensions:

An you can insert data directly on the ValueStream with property owner Thing service:

  • Add+baseType+ValueStreamEntry

We usually combine booth without issues.

Terms & ConditionsAccessibility statement