EKM Push Timeline

General questions and discussions focused around the EKM Metering System. Discuss your meters, installations, and meter communications here.
Post Reply
Searchman
Posts: 6
Joined: Thu Sep 13, 2012 9:01 am

EKM Push Timeline

Post by Searchman »

Does the EKM Push or Push Plus have the ability to display data by date and time and retain the data?
Jameson
Posts: 860
Joined: Fri Nov 04, 2011 7:42 pm
Location: Santa Cruz, CA
Contact:

Re: EKM Push Timeline

Post 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,
Jameson
EKM METERING
http://www.ekmmetering.com
831.425.7371
Searchman
Posts: 6
Joined: Thu Sep 13, 2012 9:01 am

Re: EKM Push Timeline

Post 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
Jameson
Posts: 860
Joined: Fri Nov 04, 2011 7:42 pm
Location: Santa Cruz, CA
Contact:

Re: EKM Push Timeline

Post 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,
Jameson
EKM METERING
http://www.ekmmetering.com
831.425.7371
Post Reply