Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
EcoStruxure Power Operation: How to expose the custom trend tag in ETL so that it will extract trend data from EPO and load it in PME SQL DB or in other file formats?

Issue

From ETL v6.2 I am unable to extract the EPO/PSO custom tag historical trend data using ETL tool.

Environment

Power SCADA Operation (PSO) 2020 With ETL v6.2

EcoStruxure Power Operation (EPO) v2021 / v2022 With ETL v6.2

Cause

This is a known issue prior to ETL v6.2. However, from this version for custom tags we need additional configuration which is explained in Resolution section.

Resolution

When configuring ETL Job > PSO Extract task make sure to set Include Custom Topics In Mapping Operations = True
ETL_1

After this follow the normal process to configure remaining part of task. Above step will help ETL tool to load the custom tags while Loading Sources in “Mappings” tab of the tool.
But to extract historical trend data from EPO DB, then you may need to create the custom Topics.xml file as per below screen cap (also sample file attached with this article) and place it in ETL install folder [the default location ‘C:\Program Files\Schneider Electric\ETL (PowerSCADA)’] and configure all the custom tags as per below example.
ETL_2
Note:LegacyTopicID must be unique negative number.
Have a look in to attached example Topics.xml file for more info.

Schneider Electric Malaysia

Attachment(s)
Topics_Example1.xml [1.67 KB]
Topics_Example2.xml [2.56 KB]
EcoStruxure Power Operation: How to expose the custom trend tag in ETL so that it will extract trend data from EPO and load it in PME SQL DB or in other file formats?

Issue

From ETL v6.2 I am unable to extract the EPO/PSO custom tag historical trend data using ETL tool.

 

Environment

Power SCADA Operation (PSO) 2020 With ETL v6.2

EcoStruxure Power Operation (EPO) v2021 / v2022 With ETL v6.2

 

Cause

This is a known issue prior to ETL v6.2. However, from this version for custom tags we need additional configuration which is explained in Resolution section.

 

Resolution

When configuring ETL Job > PSO Extract task make sure to set Include Custom Topics In Mapping Operations = True
ETL_1

After this follow the normal process to configure remaining part of task. Above step will help ETL tool to load the custom tags while Loading Sources in “Mappings” tab of the tool.
But to extract historical trend data from EPO DB, then you may need to create the custom Topics.xml file as per below screen cap (also sample file attached with this article) and place it in ETL install folder [the default location ‘C:\Program Files\Schneider Electric\ETL (PowerSCADA)’] and configure all the custom tags as per below example.
ETL_2
Note: LegacyTopicID must be unique negative number.
Have a look in to attached example Topics.xml file for more info.

Schneider Electric Malaysia

Attachment(s)
Topics_Example1.xml [1.67 KB]
Topics_Example2.xml [2.56 KB]
Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range:
Explore more
Range:

Need help?

  • Start here!

    Find answers now. Search for a solution on your own, or connect with one of our experts.

  • Contact Support

    Reach out to our customer care team to receive more information, technical support, assistance with complaints and more.

  • Where to buy?

    Easily find the nearest Schneider Electric distributor in your location.

  • Search FAQs

    Search topic-related frequently asked questions to find answers you need.

  • Contact Sales

    Start your sales enquiry online and an expert will connect with you.

I'd like to receive news and commercial info from Schneider Electric and its affiliates via electronic communication means such as email, and I agree to the collection of information on the opening and clicks on these emails (using invisible pixels in the images), to measure performance of Schneider Electric's communications and to improve them. For more details, please read our Privacy Policy.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Centre
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.