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
84549members
353812posts

[Imported] Extract Data from embedded list into excel?

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.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
465

[Imported] Extract Data from embedded list into excel?

>>Message imported from previous forum - Category:General Items<<
User: ROVSCADAENGINEER, originally posted: 2019-02-12 04:53:41 Id:366
Is it possible to extract data from an embedded list generated by SQL into excel?


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
464

Re: [Imported] Extract Data from embedded list into excel?

>>Responses imported from previous forum


Reply From User: geoffpatton, posted: 2019-02-12 14:16:56
No. Your best bet is to put the same query in a SQL Export object. That lets you export it file. You can have a button execute it or have it executes on a interval.


Reply From User: ROVSCADAENGINEER, posted: 2019-02-12 21:48:09
Thanks Geoff! much appreciated.


Reply From User: ROVSCADAENGINEER, posted: 2019-02-19 01:21:32
Hi [at]BevanWeiss thanks for your advice. this is the code I have put in for the page.

Mimic.OpenInset "SCX:////CMimic/.Test page", 20, 20, 20, 20

however it is generating just the mimic itself in a separate window. when you say "Based on the SQL animation" how exactly would I do this? I understand the url needs to be a little special.

The name of the animation is Lst_1


Reply From User: tfranklin, posted: 2019-02-19 13:44:08
[at]ROVSCADAENGINEER said:
Hi [at]BevanWeiss thanks for your advice. this is the code I have put in for the page.

Mimic.OpenInset "SCX:////CMimic/.Test page", 20, 20, 20, 20

however it is generating just the mimic itself in a separate window. when you say "Based on the SQL animation" how exactly would I do this? I understand the url needs to be a little special.

The name of the animation is Lst_1

The format that you're looking for would be something like:

SCX:////List/Title="SomeTitleHere"&InitialSQL="SomeQueryHere"


Reply From User: geoffpatton, posted: 2019-02-19 17:32:06
Well I missed the boat on this one. Good to know.


Reply From User: ROVSCADAENGINEER, posted: 2019-03-15 04:42:49
So I tried your method [at]BevanWeiss and I am getting the following message

"No apps are installed to open this type of link (error)."

My code is below:

Mimic.OpenInset "RDCMP._Navigation.OverflowFloat List pages.OverflowFloat List Paget", 100, 100, 100, 50

with permission set to Retrieve data.

It does not seem to work.

![]((see attachments below) 3j/e7s4asg91zti.png "")

any help appreciated! I have also attached an image of the script window.

 

Attached file: (editor/3j/e7s4asg91zti.png), script.PNG File size: 20097


Reply From User: BevanWeiss, posted: 2019-03-26 22:45:39
As [at]tfranklin wrote
The format that you're looking for would be something like:
SCX:////List/Title="SomeTitleHere"&InitialSQL="SomeQueryHere"

You would need for the InitialSQL string to be based on the SQL query in the embedded list, which means that you need to use scripting to do this.

Mimic.OpenInset "RDCMP..... is very wrong, it needs to be:
Mimic.OpenInset "SCX:////List/Title=""Title you want""&InitialSQL="""+sqlQuery+""""

And then you need to have a section of script above this which populates sqlQuery with the query from the list. I can't remember this off the top of my head, but I'm sure there were some examples around the old forum (which are hopefully in this new forum somewhere)

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
465

Re: [Imported] Extract Data from embedded list into excel?

>>Responses imported from previous forum


Reply From User: geoffpatton, posted: 2019-02-12 14:16:56
No. Your best bet is to put the same query in a SQL Export object. That lets you export it file. You can have a button execute it or have it executes on a interval.


Reply From User: ROVSCADAENGINEER, posted: 2019-02-12 21:48:09
Thanks Geoff! much appreciated.


Reply From User: ROVSCADAENGINEER, posted: 2019-02-19 01:21:32
Hi [at]BevanWeiss thanks for your advice. this is the code I have put in for the page.

Mimic.OpenInset "SCX:////CMimic/.Test page", 20, 20, 20, 20

however it is generating just the mimic itself in a separate window. when you say "Based on the SQL animation" how exactly would I do this? I understand the url needs to be a little special.

The name of the animation is Lst_1


Reply From User: tfranklin, posted: 2019-02-19 13:44:08
[at]ROVSCADAENGINEER said:
Hi [at]BevanWeiss thanks for your advice. this is the code I have put in for the page.

Mimic.OpenInset "SCX:////CMimic/.Test page", 20, 20, 20, 20

however it is generating just the mimic itself in a separate window. when you say "Based on the SQL animation" how exactly would I do this? I understand the url needs to be a little special.

The name of the animation is Lst_1

The format that you're looking for would be something like:

SCX:////List/Title="SomeTitleHere"&InitialSQL="SomeQueryHere"


Reply From User: geoffpatton, posted: 2019-02-19 17:32:06
Well I missed the boat on this one. Good to know.


Reply From User: ROVSCADAENGINEER, posted: 2019-03-15 04:42:49
So I tried your method [at]BevanWeiss and I am getting the following message

"No apps are installed to open this type of link (error)."

My code is below:

Mimic.OpenInset "RDCMP._Navigation.OverflowFloat List pages.OverflowFloat List Paget", 100, 100, 100, 50

with permission set to Retrieve data.

It does not seem to work.

![]((see attachments below) 3j/e7s4asg91zti.png "")

any help appreciated! I have also attached an image of the script window.

 

Attached file: (editor/3j/e7s4asg91zti.png), script.PNG File size: 20097


Reply From User: BevanWeiss, posted: 2019-03-26 22:45:39
As [at]tfranklin wrote
The format that you're looking for would be something like:
SCX:////List/Title="SomeTitleHere"&InitialSQL="SomeQueryHere"

You would need for the InitialSQL string to be based on the SQL query in the embedded list, which means that you need to use scripting to do this.

Mimic.OpenInset "RDCMP..... is very wrong, it needs to be:
Mimic.OpenInset "SCX:////List/Title=""Title you want""&InitialSQL="""+sqlQuery+""""

And then you need to have a section of script above this which populates sqlQuery with the query from the list. I can't remember this off the top of my head, but I'm sure there were some examples around the old forum (which are hopefully in this new forum somewhere)