Page 1 of 1

EKM Push Timeline

Posted: Fri Dec 07, 2012 8:53 am
by Searchman
Does the EKM Push or Push Plus have the ability to display data by date and time and retain the data?

Re: EKM Push Timeline

Posted: Fri Dec 07, 2012 9:53 am
by Jameson
Yes, the EKM Push system timestamps each read with its own Unix timestamp. You can use these to know exactly when the meter read was inserted in the database.

Here is one sample read from the EKM Push system:

curl http://io.ekmpush.com/10068~1.xml?MTAxMDoyMDIw
<?xml version='1.0' encoding='utf-8' standalone='no' ?>
<ekmMeterReads grpId='1010' >
<meter addr='10068' subAddr='0' >
<read seq='1354898970277' errCode='0' model='6' fwVer='19' PT='221014' T1_PT='139382' T2_PT='81632' T3_PT='0' T4_PT='0' PT_rev='76893' T1_PT_rev='48234' T2_PT_rev='28659' T3_PT_rev='0' T4_PT_rev='0' L1_V='1207' L2_V='1207' L3_V='0' L1_I='80' L2_I='28' L3_I='0' P='1168' L1_P='862' L2_P='306' L3_P='0' L1_PF='111' L2_PF='102' L3_PF='200' max_P='10395' max_P_period='1' CT_ratio='200' P1_count='0' P2_count='0' P3_count='0' P1_ratio='0' P2_ratio='0' P3_ratio='0' />
</meter>
</ekmMeterReads>

The seq='1354898970277' is the Unix timestamp.

This converts to: Fri Dec 7 08:49:30 PST 2012

More about Unix Time:
http://www.onlineconversion.com/unix_time.htm
http://en.wikipedia.org/wiki/Unix_time
example 1354898970277 -- cut off last 3 digits for seconds, the last 3 digits are fractions of a second)

In command line you can use: date -r 1354898970

Thanks,

Re: EKM Push Timeline

Posted: Fri Dec 07, 2012 12:46 pm
by Searchman
So where is this data stored and how is the data retrieved. I do not see the time stamp on the EKM Push info

Re: EKM Push Timeline

Posted: Fri Dec 07, 2012 1:37 pm
by Jameson
The EKM Push gateway automatically reads your meters and sends the data to a cloud based server cluster (there is not much data that is stored on the EKM Push gateway itself). The latest 1000 meter reads are stored on this server cluster. It is then very easy for you to retrieve these meter reads from the EKM Push server cluster.

The reason it is done this way is ease of installation (no network configuration) and scalability of your EKM Push system. You can have tens of thousands of meters spread around the world all sending data to your EKM Push account. We provide the EKM Push server cluster as a FREE and easy bounce point for your data. This data can be accessed your computers, other databases, smart phones, or building management systems.

To retrieve your data you make a .xml call. Here is a sample:
.xml web browser data dump (best viewed with Firefox or by looking at your Page Source):
http://io.ekmpush.com/10068~300.xml?MTAxMDoyMDIw
--------
Or in Linux command line or Mac OSX Terminal (by default, you can retrieve from 1 to 1000 reads, this request is for 300 meter reads. (include the curl)):
curl http://io.ekmpush.com/10068~300.xml?MTAxMDoyMDIw

A more user-friendly method is to use our EKM Dash software. The EKM Dash will also retrieve data from the EKM Push server cluster. Here is a tutorial: http://documents.ekmmetering.com/How-to ... M-Dash.pdf

The EKM Dash uses the exact same method as is described above (.xml calls). You can see how this is done by selecting your EKM Push meter in the EKM Dash software "Hex Inspector"

====

Time:

In my example above 1354898970 is the time. This is how computers see time (called Unix Time). 1354898970 represents: Fri Dec 7 08:49:30 PST 2012 to a computer. A timestamp like 1354898970 is translated in our rudimentary web interface and EKM Dash software to be "Human Readable Time"

I would like to explain this, so let me know if I can shed any light.

Best regards,