Locally testing EmonCms

So i successfully installed EmonCMS locally on my machine following your tutorial. I do not yet have the "gadgets" to fetch real data, so i tried fiddling with the MySQL DB and adding some values manually. It seems to me i was able to add inputs and feeds this way, but when i try to go to the my electric nothing shows up and i have tried all combinations there.
I probably missed something but i cant seem to figure this out. I have attached some screenshots.

thanks

 

 

 

pb66's picture

Re: Locally testing EmonCms

The data isn't actually stored in the mySQL tables, they hold configuration data (and the last value if using the full version). So putting data in the SQL tables is bypassing redis and the data storage engines.

You can read up on the data engine development in the documentation on the git repo For test purposes you could use the input api's http://emoncms.org/input/api or http://localhost/emoncms/input/api (always use a node id - the api doc's need updating) you can even use a cron job to send data at regular interval to get some data.

Paul

psychok7's picture

Re: Locally testing EmonCms

hi there, thanks for the reply.  i did try posting to the input api and although i got a json malford from Postman, it did create the entries in the DB, but there was still nothing in the MY ELECTRIC.

am i missing something? posting to the api should be enough to get redis starting and so on right?

i realized i didnt pass the node id like http://emoncms.org/input/post.json?node=1&csv=100,200,300 , could this be the problem?

TrystanLea's picture

Re: Locally testing EmonCms

@psychok7 Can you see the last power value in myelectric? there may not be enough data to see historic kwh per day.

psychok7's picture

Re: Locally testing EmonCms

@TrystanLea in My electric is always showing me 0W... so i should post lots of values to the API?? sorry i am new at this

psychok7's picture

Re: Locally testing EmonCms

i think i figured it out. thanks to this video https://www.youtube.com/watch?v=Y0lsou0PqwU and a lot of data i am able to see some charts now. thanks

Comment viewing options

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