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
84650members
353989posts

[Imported] Copying result data from a list / query

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

sbeadle
Janeway Janeway
Janeway

[Imported] Copying result data from a list / query

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: florian, originally posted: 2018-10-25 16:02:51 Id:232
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

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

**_hardin4019:_**
**_Gents, I find this one strange. If I build a list with a query and have data in it, I can't click on the list and use CTRL+C to copy the data and paste it into Excel or a word document. This option works if you do the same thing to "Display Points" list that show you what points are associated with an RTU, and other system generated lists. Any ideas on a way to make this same functinoality work on a custom list based on a query?_**

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

sbeadle:
Hi Shawn,

Is your custom query on a mimic or a standalone window?

All standalone list query windows can be copied from the Ribbon menu.

Steve

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

**_hardin4019:_**
**_Steve, the lists I am referring to would be embedded into a mimic. Any work arounds other than say making these stand alone lists?_**

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

sbeadle:
I have seen two workarounds.

One (easiest) is to have a button adjacent to the list on the mimic. This runs a short script to open the list as an inset. The script copies the list sql (List1.SQL property) to create the inset link.

The second is to have a button which runs a script and executes the query, copying it to the PCs paste buffer. Generally this needs the user to click an 'allow' dialog which Windows demands.

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

**_hardin4019:_**
**_I'm not real good with ST or scripting, but I am learning as I go. What are the basic commands I would need for the script in option 2? This whole thing is more for the system admins. Operators don't have access to anywhere to even paste data. Admins would be using it to compare point values, addresses, complex query results, etc._**


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


geoffpatton:
There are also two ways to get a SQL query results into a file.

1 You can print a embedded list to a PDF printer.
You can even select and copy the results from it. That adds a extra step vs Steve's second suggestion.

It is what I tell customers to do on an existing system where they suddenly need to put ... in Excel to analyze it yesterday.

2 Where someone wants something periodically I use a "SQL Export" object and have it create a new csv file in a folder on the MAIN server's hard drive or better a network drive.

I mostly mention these in case someone else comes across this thread and maybe these will work better for their needs.

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

**_hardin4019:_**
**_Understood. I did do a SQL Export yesterday to compare 2 special lists of RTUs to see if a change to the query had positive or negative effects._**