Im trying to add data to a feed from an older feed, so the app for HPM in emoncms can see the “historical” data from the old feed, just in the newer feed that the app is set to.
The CSV import says its a success, but I cant see the data on the target feed at all.
The records in a Feed must be in strict time order, so you must add the later data to the earlier, not vice versa. This will probably mean exporting/backing up both the earlier data and the later, then importing the early data to a new Feed, followed by the late data, then point the Incoming data at the new Feed.
[In a fixed Interval TimeSeries feed, the start time and feed interval are stored as metadata, and the Feed data itself does not have the time attached, time is calculated from the position of the record in the file.]
Hello @Swwils if it’s on emoncms.org and you can send me the details of both feeds and which one you want to merge in to the other , happy to have a look at that for you.
Maybe I need to add that in the Variable Interval TimeSeries feed, the time and the value are stored in the same record, as a consequence a VITS feed occupies around twice the storage space as the equivalent number of items in a FITS feed. This doesn’t help when merging data, because you still can’t merge it as such, the newer data cannot overlap the older, it can only follow on. The timestamps in the file must always be in increasing order.
There used to be a full explanation of both types somewhere, I can’t find it now.