Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84751members
354180posts

PM5560 Timestamp Problems

Metering & Power Quality

Collaborate with multiple experts and discuss various topics about Power Meters and Power Quality. From design & implementation to troubleshooting and more, get support from experts and share your experiences by subscribing to the Schneider Electric Exchange forum today.

Solved
sesa409811_brid
Schneider Alumni (Retired)
Schneider Alumni (Retired)
0 Likes
6
395

PM5560 Timestamp Problems

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

Attachments

Accepted Solutions
sesa409811_brid
Schneider Alumni (Retired)
Schneider Alumni (Retired)
0 Likes
1
356

Re: PM5560 Timestamp Problems

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!!!

See Answer In Context

Attachments
6 Replies 6
Matt_Curry
Administrator Administrator
Administrator
0 Likes
0
356

Re: PM5560 Timestamp Problems

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
Commander
Commander
0 Likes
0
356

Re: PM5560 Timestamp Problems

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

Regards

Grant
michael_stith_g
Lieutenant | EcoXpert Master Lieutenant | EcoXpert Master
Lieutenant | EcoXpert Master
0 Likes
0
356

Re: PM5560 Timestamp Problems

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

Respectfully,

Michael Stith
Albireo Energy
6525 The Corners Parkway
Suite 102
Peachtree Corners, Georgia 30092-3349
sesa409811_brid
Schneider Alumni (Retired)
Schneider Alumni (Retired)
0 Likes
1
357

Re: PM5560 Timestamp Problems

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!!!

Attachments
Robert_Lee
Captain Captain
Captain

Re: PM5560 Timestamp Problems

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
Lt. Commander
Lt. Commander
0 Likes
0
354

Re: PM5560 Timestamp Problems

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