Clear data in EmonCMS

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 ;)

 

alco's picture

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.

Robert Wall's picture

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.

zemaree's picture

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

Robert Wall's picture

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.

Paul Reed's picture

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

aicanduit's picture

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.

aicanduit's picture

Re: Clear data in EmonCMS

Is there any way to resolve this? Any "backdoor" solution ?

aicanduit's picture

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.

aicanduit's picture

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.

aicanduit's picture

Re: Clear data in EmonCMS

Seems to be working, sorry...

aicanduit's picture

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 ?

ukmoose's picture

Re: Clear data in EmonCMS

What browser are you using and what OS?  Have you tried using a different browser?

aicanduit's picture

Re: Clear data in EmonCMS

I'm using Windows 7 and Mozilla Firefox 25.0

aicanduit's picture

Re: Clear data in EmonCMS

Neither Mozilla nor IE , nor Chrome...

aicanduit's picture

Re: Clear data in EmonCMS

Hello? Anybody?

Does this happen to anyone else?

Thanks.

altonplace's picture

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.

pentala's picture

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.

webby's picture

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

ukmoose's picture

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.

jmessenger's picture

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:


GET /emoncms/feed/deletedatarange.json?&apikey=BLAHBLAHCHANGED&id=14&start=1424908616919&end=1425211016919 HTTP/1.1 

receives a response

HTTP/1.1 200 OK

containing the text

false
Echo's picture

Re: Clear data in EmonCMS

I have the same issue. The log doesn't say anything for that particular operation :-(

René

mariuso's picture

Re: Clear data in EmonCMS

No solution found?

I have the same problem.

Marius

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.