how to read raw data from files stored in EMONCMS?

Arash_sh · 2023-08-14T15:58:13.646Z

Hi dear friends,
I have Emoncms installed on a VPS and I am going to read the stored historical data (electrical parameters) to feed into a newly built module. The problem is, I don’t know where the data is stored and how could I access them. For example, in one case, I have a python code which is able to analyze the data of voltage and current and I must read the historical data from emoncms using this python code.

I studied the documentation and some relevant topics, but no solution yet.
I found some data with .MYD format in the timeseries folder. But as I couldn’t extract the data, I am not sure this is the right folder I am looking for.

could you please help me to find the storage directory of historical data and also a way to extract them.

Thanks

Robert.Wall · 2023-08-14T16:18:15.147Z

Welcome, Arash, to the OEM forum.

If you knew what to search for here in the forum, you would have found this from just two days ago

Extracting data from emoncms Emoncms

I’m trying to extract data from emoncms to reconcile against my smart meter readings. At the moment I am attempting to do this via the CSV export on the feed interface, but seem unable to achieve what I want: I want to extract data values at 8:00 am every day for a month. I can set this up in the input boxes as, for example, from 01/06/2023 08:00:00 to 30/06/2023 08:00:00, period ‘Daily’ but the data returned is always at midnight (00:00:00) - the same thing happens if I try to extract the CS…

(I could not find it either - which is why I questioned it.)

Arash_sh · 2023-08-15T09:03:17.557Z

Hi dear Robert.Wall
Thank you for your prompt response.
I hope the mentioned post will be helpfull for me.