PM5560 Timestamp Problems

[Anonymous user]

Hi Guys,

We have the following issue  with a PM5560 It is recording a 5 min Demand data correctly , however we have seen that  as soon as it arries to 1:00pm it seems not to record the hour correctly.

For example it record the measurement of 12:55p.m.  and the next record is timestamped as 1:00a.m.  this causes that the report has two 1:00 am records but with different values as the second one is 1:00p.m. value but with the incorrect timestamp

I have downoaded the latest firmware from Schneider Page however I’m not sure if this will solve the issue, so I haven’t upgraded it..

I attached the current setting

Could you let me know if this is solved by firmware or should I modify any setting?

Regards

[Matt_Curry]

Moved this to the Power Metering area of the community.  If you do not get an answer to your question on this setting, I recommend contacting Technical Support.

[Grant_IPACS]

Hi Liliana,

If you are viewing the report in excel, we have seen this issue before with the data format.

It may not be the meter, it may be your excel settings.

Can you post your record file?

Regards

Grant

[michael_stith_g]

Liliana,

I would follow Grant Smyth's thread above regarding the formating in Excel.  Data downloaded into an excel spreadsheet is typically not formatted to match standard excel data date/times. 

In the screen cap above you will see the basic format of a field in an Excel spreadsheet.  It is "General" by default.  I have found that applying custom format to the timestamp field tends to correct the issue.  I use  mm/dd/yyyy hh:mm:ss:sss  The detail helps with millisecond time stamping found in wave forms, event logs, etc..

I would definitely upgrade the firmware to version 2.5.2  If possible cycle the meter's control power after you complete the firmware upgrade and verify it connects.  There are some communication issues resolved in the newer firmware.  Re-run your meter configuration report afterwards and you will capture the MAC Address, IP assigned and more in the meter configuration report.

Regards,

Michael

[Anonymous user · Accepted solution]

Hi Grant Smyth​ @Michael Stith

Thank you for your comments, I´m sharing with my client.

Today he sent me the record file  and I attached it.

Warm Regards!!!

[Robert_Lee]

Are you using ION Setup to pull the data out of the device and saving it as a CSV file?

How did you perform a clock synchronization (using ION Setup or PME).  By default, the device should be running in either UTC if using PME/ION Setup and when you do the clock synchronization you should select that option (and then go to the front panel display and program the clock offset so the front panel shows the correct time).

Check the Clock Settings via ION Setup and reply with how the clock settings are programmed (and also how the Device Properties -> Timezone setting is presently selected in ION Setup).

[greg_expoenergy]

The problem with tte file you sent is that the DATE/TIME format is in text and not number format.

 26/06/2018 10.15.000 am

Simply create a new column in excel and do =LEFT(A1,15)

Then do CTL-C and copy for all rows.

Then do  copy on the column and then paste using 123 or numbers.

and then do a replace all / for -

Date/TimeColumn1

26/06/2018 10:15:00.000 a. m.	43277.43
26/06/2018 10:20:00.000 a. m.	26-06-2018 10:20
26/06/2018 10:25:00.000 a. m.	2018 Jun 26 10:25
26/06/2018 10:30:00.000 a. m.	26-06-2018 10:30

Now the new columns are in correct excel datetime number format and you may format as you wish

This new editor does not allow screen shots to be inserted