Hello, I'm new to emonCMS/OpenEnergyMonitor, and I'm working on a temp/energy moitoring using lacrosse TX17 433 wireless temp sensors, pulse counting on individual power counters and Teleinfo from my energy supplier's counter , all with an Arduino.
Currently, temperatures are working, but I've made a lot of tries and retries, and I would like to clear emoncms values without having to recreate everything, how can I do this ?
Thanks and sorry for the bad english ;)
Re: Clear data in EmonCMS
well it depends if you use the mysql or timestamp storage method. You can clean a database with some SQL If you use the default mysql database. use a free SQL editor like PHPmyadmin to clear the feed and input tables.
Re: Clear data in EmonCMS
alco: Can you do that with emoncms.org? getget does not say whether he is using a local emoncms or emoncms.org.
Re: Clear data in EmonCMS
Same needs here. But i think that we are both looking for a solution that it's applicable online not on local DB.
tnx
Re: Clear data in EmonCMS
I have not installed Timestamp on my Wampserver yet. I shall try to do that tomorrow and run some tests. Local emonCMS is the same software as emonCMS.org, so what I find should work for both. I think deleting the feed clears the data, but I will check that.
Re: Clear data in EmonCMS
Yes, deleting the feed for both Timestore & MYSQL does delete the data, on both emoncms.org and local servers. However deleting the feeds can also break any links that you may have in visualisations, dashboards etc.
So in practice, if you had a lot of test data in a feed called 'solar', you could delete it, then add a new feed called 'solar' and start afresh. But if you had used the original 'solar' feed to log graphs or data in dashboards, their link would probably be broken, and you would have to re-establish their relationship with the new 'solar' feed.
Paul
Re: Clear data in EmonCMS
"their link would probably be broken, and you would have to re-establish their relationship"
Probably, no, surely (tested by me). At least in realtime's...
Is possible to implement a function to delete old data stored in feeds stored in emoncms.org ?
Thank you.
Re: Clear data in EmonCMS
Is there any way to resolve this? Any "backdoor" solution ?
Re: Clear data in EmonCMS
Well, found (partially) a solution.
I´ve found that in Vis. page, I can use the datapoint editor. Select "editrealtime", then select the feed, and then "full screen" (otherwise I can´t edit datapoints). Well...
In full mode, I click in the graph and I can modify the value for one datapoint. (new value + save). But, If I select "delete data in window", nothing happens.
Nothing happens also if fill the "multiply data in window" textbox and press save.
At least, I can modify some erroneous values, but not delete them.
Re: Clear data in EmonCMS
Hello again !
I'm trying to modify partial data feed with Datapoint editor in emoncms.org.
Deleting data in window doesn´t work. Editing data point doesn´t work, too.
Any official explanation ?
Thanks in advance.
Re: Clear data in EmonCMS
Seems to be working, sorry...
Re: Clear data in EmonCMS
Sorry again, but It was an illusion.
I select datapoint Editor in "vis". Then select a feed and a period.
I click "Delete data in window", but nothing happens... The data is not refreshed, neither datapoint editor, nor multigraph...
Any idea ?
Re: Clear data in EmonCMS
What browser are you using and what OS? Have you tried using a different browser?
Re: Clear data in EmonCMS
I'm using Windows 7 and Mozilla Firefox 25.0
Re: Clear data in EmonCMS
Neither Mozilla nor IE , nor Chrome...
Re: Clear data in EmonCMS
Hello? Anybody?
Does this happen to anyone else?
Thanks.
Re: Clear data in EmonCMS
I'm having the same problem. I can edit datapoints by using the edit realtime full screen, but the delete button does not work at all.
I can't figure out how to get rid of a bad string of data.
Re: Clear data in EmonCMS
Hi,
I'm also seeing the same issue. Tried with both Chrome (Version 33.0.1750.154 m) and Firefox (28.0)
Again, like the above I am trying to remove some rogue data from a feed.
A download of the feed shows -
ID - 38710
1397035140 0
1397035170 262 144
1397035200 0
Andy.
Re: Clear data in EmonCMS
Yes I am unable to edit anything with "edit realtime" It just sets the datapoint to zero. I am using safari
Re: Clear data in EmonCMS
Webby,
Please look at the browser compatibility part of
http://emoncms.org/site/docs.
Safari isn't one of the browsers emoncms is tested against.
Please try again using Chrome to rule out any issues with your browser.
Re: Clear data in EmonCMS
This bug still exists in v8.3.6. For a PHPFIWA feed using Firefox 36.0 or Chrome 41.0.2272.76 m or Safari 5.1.7, the "Delete data in window" button brings up a confirmation dialog box but when you click "Delete permanently" it doesn't change the data. I don't know how to debug emoncms, but at a web level,
The HTTP request:
receives a response
containing the text
Re: Clear data in EmonCMS
I have the same issue. The log doesn't say anything for that particular operation :-(
René
Re: Clear data in EmonCMS
No solution found?
I have the same problem.
Marius