Sign In Help
Schneider Electric
HelpSign In
Schneider Electric Exchange
  • Home
  • Collaborate
  • Develop
  • Shop
Home Collaborate Develop Shop Log in or Register Help

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.
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
  • Home
  • Collaborate
  • Exchange Community
  • :
  • SCADA & Telemetry Solutions
  • :
  • Geo SCADA Expert Forum
  • :
  • [Imported] Writing to Data Grids in Group Template Instances
Community Menu
  • Forums
    • By Topic
        • EcoStruxure IT
          • EcoStruxure IT forum
        • Industrial Automation
          • Industry Automation and Control Forum
          • Alliance System Integrators Forum
          • Machine Solutions in the Digital Transformation
          • EcoStruxure Automation Expert / IEC 61499 Forum
          • Industrial Edge Computing Forum
          • Level and Pressure Instrumentation Forum
          • Modicon User Group
          • PLC Club Indonesia
          • SEE Automation Club Forum
          • Fabrika ve Makina Otomasyonu Çözümleri
          • Форум по промышленной автоматизации СНГ
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Forum
          • SCADA and Telemetry Devices Forum
        • Power Distribution IEC
          • Power Distribution and Digital
          • Power Standards & Regulations
          • Paneelbouw & Energie Distributie
        • Power Distribution Softwares
          • EcoStruxure Power Design Forum
          • SEE Electrical Building+ Forum
          • LayoutFAST User Group Forum
        • Solutions for your Business
          • Solutions for Food & Beverage Forum
          • Solutions for Healthcare Forum
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Forum
        • Healthcare
          • Solutions for Healthcare Forum
      • EcoStruxure IT
        • EcoStruxure IT forum
      • Industrial Automation
        • Industry Automation and Control Forum
        • Alliance System Integrators Forum
        • Machine Solutions in the Digital Transformation
        • EcoStruxure Automation Expert / IEC 61499 Forum
        • Industrial Edge Computing Forum
        • Level and Pressure Instrumentation Forum
        • Modicon User Group
        • PLC Club Indonesia
        • SEE Automation Club Forum
        • Fabrika ve Makina Otomasyonu Çözümleri
        • Форум по промышленной автоматизации СНГ
      • SCADA & Telemetry Solutions
        • Geo SCADA Expert Forum
        • SCADA and Telemetry Devices Forum
      • Power Distribution IEC
        • Power Distribution and Digital
        • Power Standards & Regulations
        • Paneelbouw & Energie Distributie
      • Power Distribution Softwares
        • EcoStruxure Power Design Forum
        • SEE Electrical Building+ Forum
        • LayoutFAST User Group Forum
      • Solutions for your Business
        • Solutions for Food & Beverage Forum
        • Solutions for Healthcare Forum
      • Food & Beverage
        • Solutions for Food & Beverage Forum
      • Healthcare
        • Solutions for Healthcare Forum
  • Blogs
    • By Topic
        • Industrial Automation
          • Industrial Edge Computing Blog
          • Industry 4.0 Blog
          • Industrie du Futur France
        • SCADA & Telemetry Solutions
          • SCADA and Telemetry Blog
        • Power Distribution IEC
          • Power Events & Webinars
          • Power Foundations Blog
        • Power Distribution NEMA
          • NEMA Power Foundations Blog
        • Power Distribution Softwares
          • EcoStruxure Power Design Blog
          • SEE Electrical Building+ Blog
        • Solutions for your Business
          • Solutions for Food & Beverage Blog
          • Solutions for Healthcare Blog
          • Solutions for Retail Blog
        • Community experts & publishers
          • Publishers Community
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Blog
        • Healthcare
          • Solutions for Healthcare Blog
        • Retail
          • Solutions for Retail Blog
      • Industrial Automation
        • Industrial Edge Computing Blog
        • Industry 4.0 Blog
        • Industrie du Futur France
      • SCADA & Telemetry Solutions
        • SCADA and Telemetry Blog
      • Power Distribution IEC
        • Power Events & Webinars
        • Power Foundations Blog
      • Power Distribution NEMA
        • NEMA Power Foundations Blog
      • Power Distribution Softwares
        • EcoStruxure Power Design Blog
        • SEE Electrical Building+ Blog
      • Solutions for your Business
        • Solutions for Food & Beverage Blog
        • Solutions for Healthcare Blog
        • Solutions for Retail Blog
      • Community experts & publishers
        • Publishers Community
      • Food & Beverage
        • Solutions for Food & Beverage Blog
      • Healthcare
        • Solutions for Healthcare Blog
      • Retail
        • Solutions for Retail Blog
  • Ideas
        • Industrial Automation
          • Modicon Ideas & new features
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Ideas
          • SCADA and Telemetry Devices Ideas
  • Knowledge Center
    • Building Automation Knowledge Base
    • Industrial Automation How-to videos
    • Ask Exchange
    • Digital E-books
    • Success Stories Corner
    • Power Talks
  • Events & Webinars
  • Support
    • User Guide
    • Leaderboard
    • Releases Notes
How can we help?
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: 
49348members
Join Now
242605posts
Join Now

[Imported] Writing to Data Grids in Group Template Instances

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
Back to Geo SCADA Expert Forum
sbeadle
Sisko sbeadle Sisko
Sisko
‎2019-10-26 02:41 AM
0 Likes
0
201
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2019-10-26 02:41 AM

[Imported] Writing to Data Grids in Group Template Instances

>>Message imported from previous forum - Category:Scripts and Tips<<
User: mchartrand, originally posted: 2018-10-19 17:46:05 Id:152
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

-------------------------------

**_Chadam:
Just wondering if it is okay to have a Data Grid in a group template. I have an ST Logic section that needs to write to a data grid within the group template. The Data grid has a unique tablename for each instance.
If i create a group instance and execute the ST Logic i get an error saying "Program Error: QP Error - Invalid Object"
If i convert the group template instance to a group and execute the same ST logic, it works fine and the Data Grid gets populated.
I have checked Property overrides and the Data Grid is available for editing within the instances. Any thoughts?_**

-------------------------------

AWoodland:
Have a look into data sets, they may do what you want to do with data grids but make your life so much simpler

_____________________________

**_Chadam:
Hi Adam. I have looked into Data Sets. However, it doesn't quite work for me in this instance. If i go with Data Set solution, it implies that within the Group Template i can only define a Data Set Row. This takes in a single Row of data only. The Data Rows from each group instance are then automatically collected into a Data Set which needs to sit outside the Group instance. Rather than building the table outside the group instance, i would like to build the table within the group instance.
As such it would be great if i could populate a Data Grid that sits within the Group template with Multiple rows. Using a Data Set Row in the Group template doesn't give me the multiple rows in a table that i need.
Feel free to correct me if i am wrong. Any more ideas are definitely welcome._**

____________

trentonite:
You _could_ but it doesn't mean you should. I'd look at having multiple data grids as having to manage multiple different tables. Things can get really messy really fast. If you NEED to have a data grid to do what you're trying to do, consider having a single data grid and using ST+SQL to query and insert data as needed. Writing logic to populate a single data grid and configure expressions accordingly isn't as daunting a task as it sounds; however, be mindful of the size of the datagrid and the complexity of each expression.

If this is for something that you don't need to reference items but rather just need static values, consider using a data table instead.

___________________________

bevanweiss:
You can have multiple Data Set Rows within a Template (or Template Instance) which would each contribute a row to the DataSet.

How did you get the DataGrid to be referenced within your Template Instance? It's unusual that you were able to just convert it to a Group and have the logic work. Since the SQL query would have needed a dynamic table reference (which doesn't work).

_____________________________

sbeadle:
Re: "You can have multiple Data Set Rows within a Template (or Template Instance) which would each contribute a row to the DataSet. "

There have been improvements in monthly releases which make this solution more scalable - DataSets with large row counts.

______________________

du5tin:
I am working on a system that used to do this. They had a datagrid for each tank in the system (there were over 2,000!!!!). Think about that.... 2,000 extra tables in the ClearSCADA database. We are re-building the database currently and we are using DataRows and DataSets. So now instead of 2,000 tables with a few rows each we have a few thousand rows in a single table.

Where we need multiple rows from a single instance we put in multiple row objects in to the template. Well Optimization is one of these where we have a DataRow for each of the past ten completed cycles.

We found a lot of efficiency improvements with DataSets/DataRows, both on the configuration side and on the data extraction side. With all the data in one table (which is good database design) we could query one site, or many sites in a single query, rather than two or using Unions. Plus it kept the ugly management of multiple DataGrid table names for what is the same data schema out of our scope.

Just my $0.05. 🙂

______________

**_Chadam:
Hi Dustin. How do you manage a situation where the number of data rows in a template is unknown i.e. it differs for each instance._**

__________

bevanweiss:
In your Template you have the number of DataSetRows that you need as a minimum.
Then inside your Template Instance you can just create new DataSetRows to get the number of rows that you finally need.

______________________

du5tin:
What Bevan said. If we need more rows we simply add the DataRow object to the instance after it is created.

If we are working with sites that have multiple meters or logical objects then we make those a template with the DataRow inside, like a meter template. If we have more meters we simply add more meter instances and those rows show up in the table, linked and ready to go.

_________________

bevanweiss:
DataSets and DataSetRows are a really amazing feature for reporting.

No longer do you need to do complicated SQL queries to identify what is or isn't a pump... just add a DataSet for pump statistics, and then DataSetRows for each Pump... job done 🙂

The only slight improvement I could see would be if it were possible within the DataSetRow object to have multiple rows, there are times when it would be nice to just be able to add new rows like a DataGrid.. but to still have it consolidate all such items into an inclusive DataSet.

___________________________________

**_Chadam:
I agree Bevan, additional rows in a data set "row" would have been excellent._**

Labels
  • SCADA
Share
  • All forum topics
  • Previous Topic
  • Next Topic
Related Products
Schneider Electric
EcoStruxure™ Geo SCADA Expert
Top Experts
User Count
sbeadle
Sisko sbeadle Sisko
1
geoffpatton
Lieutenant geoffpatton
1
BevanWeiss
Admiral BevanWeiss
1
See More Top Experts
Find a Service Provider
Find a certified partner to help you address your integration, installation, maintenance and project needs.
View all Providers
Support

Have a question? Please contact us with details, and we will respond.

Contact Us
FAQ

Look through existing questions to find popular answers.

Learn More
About

Want to know more about Exchange and its possibilities?

Learn More

Full access is just steps away!

Join Exchange for FREE and get unlimited access to our global community of experts.

Connect with Peers & Experts

Discuss challenges in energy and automation with 30,000+ experts and peers.

Get Support in Our Knowledge Base

Find answers in 10,000+ support articles to help solve your product and business challenges.

Ask Questions. Give Solutions

Find peer based solutions to your questions. Provide answers for fellow community members!

Register today for FREE

Register Now

Already have an account?Log in

About Us FAQ Terms & Conditions Privacy Notice Change your cookie settings
©2020, Schneider Electric