Help
  • Get started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Brand Logo
Help
  • Get started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
close
  • Community Home
  • Forums
    • By Topic
    • By Topic
      EcoStruxure Building
      • Field Devices Forum
      • SmartConnector Forum
      EcoStruxure Power & Grid
      • Gateways and Energy Servers
      • Metering & Power Quality
      • Protection & Control
      APC UPS, Critical Power, Cooling and Racks
      • APC UPS Data Center & Enterprise Solutions Forum
      • APC UPS for Home and Office Forum
      EcoStruxure IT
      • EcoStruxure IT forum
      • EcoStruxure IT™ Advisor CFD
      Remote Operations
      • EcoStruxure Geo SCADA Expert Forum
      • Remote Operations Forum
      Industrial Automation
      • Alliance System Integrators Forum
      • AVEVA Plant SCADA Forum
      • CPG Expert Forum DACH
      • EcoStruxure Automation Expert / IEC 61499 Forum
      • Fabrika ve Makina Otomasyonu Çözümleri
      • Harmony Control Customization Forum
      • Industrial Edge Computing Forum
      • Industry Automation and Control Forum
      • Korea Industrial Automation Forum
      • Machine Automation Forum
      • Modicon PAC Forum
      • PLC Club Indonesia
      Schneider Electric Wiser
      • Schneider Electric Wiser Forum
      Power Distribution IEC
      • Eldistribution & Fastighetsautomation
      • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
      • Paneelbouw & Energie Distributie
      • Power Distribution and Digital
      • Solutions for Motor Management
      • Specifiers Club ZA Forum
      • Електропроектанти България
      Power Distribution NEMA
      • Power Monitoring and Energy Automation NAM
      Power Distribution Software
      • EcoStruxure Power Design Forum
      • LayoutFAST User Group Forum
      Energy & Sustainability Services
      • Green Building Scoring and Certification Forum
      Light and Room Control
      • SpaceLogic C-Bus Forum
      Solutions for your Business
      • Solutions for your Business Forum
      Support
      • Ask the Community
  • Knowledge Center
    • Building Automation Knowledge Base
    • Remote Operations Devices Knowledge Base
    • Geo SCADA Knowledge Base
    • Industrial Automation How-to videos
    • Digital E-books
    • Success Stories Corner
    • EcoStruxure IT Help Center
  • Events & Webinars
    • All Events
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Partner Success
    • Process Automation Talks
    • Technology Partners
  • Ideas
    • EcoStruxure Building
      • EcoStruxure Building Advisor Ideas
      Remote Operations
      • EcoStruxure Geo SCADA Expert Ideas
      • Remote Operations Devices Ideas
      Industrial Automation
      • Modicon Ideas & new features
  • Blogs
    • By Topic
    • By Topic
      EcoStruxure Power & Grid
      • Backstage Access Resources
      EcoStruxure IT
      • EcoStruxure IT™ Advisor CFD
      Remote Operations
      • Remote Operations Blog
      Industrial Automation
      • Industrie du Futur France
      • Industry 4.0 Blog
      Power Distribution NEMA
      • NEMA Power Foundations Blog
      Energy & Sustainability Services
      • Active Energy Management Blog
      Light and Room Control
      • KNX Blog
      Knowledge Center
      • Digital E-books
      • Geo SCADA Knowledge Base
      • Industrial Automation How-to videos
      • Remote Operations Devices Knowledge Base
      • Success Stories Corner
  • companyImpact

Important Announcement: Protecting our Community from Spam Events

Dear Members, we apologize for any disruption or inconvenience caused by the recent spam incidents, and we want to assure you that our dedicated team is actively investigating each reported instance of spam and implementing robust measures to mitigate the impact. Learn more on Spams Mitigation Guidelines

Thank you,

Schneider Electric Community Team

PM5560 Timestamp Problems

Metering & Power Quality

Schneider Electric support forum about Power Meters (ION, PowerTag, PowerLogic) and Power Quality from design, implementation to troubleshooting and more.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Communities
  • EcoStruxure Power & Grid
  • Metering & Power Quality
  • PM5560 Timestamp Problems
Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
Charles_Murison
Picard Charles_Murison Picard
292
Ramasamy_N
Commander Ramasamy_N Commander
75
DanL
Captain DanL Captain
71
Robert_Lee
Captain Robert_Lee Captain
67
View All

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Solved Go to Solution
Back to Metering & Power Quality
Solved
sesa409811_brid
Ensign sesa409811_brid Ensign
Ensign

Posted: ‎2018-09-04 01:53 PM

0 Likes
6
688
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-04 01:53 PM

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
Meter Configuration Report for Twist (SN# 600038909).txt.zip
Reply
  • All forum topics
  • Previous Topic
  • Next Topic

Accepted Solutions
sesa409811_brid
Ensign sesa409811_brid Ensign
Ensign

Posted: ‎2018-09-06 05:32 PM

0 Likes
1
649
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-06 05:32 PM

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
Data Log #1 for Twist (SN ).csv.zip
Reply
Replies 6
Matt_Curry
Administrator Matt_Curry Administrator
Administrator

Posted: ‎2018-09-04 02:12 PM

0 Likes
0
649
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-04 02:12 PM

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.

Reply
Grant_IPACS
Commander Grant_IPACS
Commander

Posted: ‎2018-09-04 04:01 PM

0 Likes
0
649
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-04 04:01 PM

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
Reply
michael_stith_g
Lieutenant | EcoXpert Master michael_stith_g Lieutenant | EcoXpert Master
Lieutenant | EcoXpert Master

Posted: ‎2018-09-06 06:15 AM

0 Likes
0
649
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-06 06:15 AM

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
Reply
sesa409811_brid
Ensign sesa409811_brid Ensign
Ensign

Posted: ‎2018-09-06 05:32 PM

0 Likes
1
650
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-06 05:32 PM

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
Data Log #1 for Twist (SN ).csv.zip
Reply
Robert_Lee
Captain Robert_Lee Captain
Captain

Posted: ‎2018-09-07 10:57 AM

1 Like
0
649
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-07 10:57 AM

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).

Reply
greg_expoenergy
Lt. Commander greg_expoenergy
Lt. Commander

Posted: ‎2018-09-14 09:54 AM . Last Modified: ‎2020-04-29 12:13 PM

0 Likes
0
647
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-09-14 09:54 AM

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

 

 

Reply
Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

Additional options
You do not have permission to remove this product association.
 
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2023 Schneider Electric, Inc