[Imported] Extract Data from embedded list into excel?

[sbeadle]

>>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?

[sbeadle · Accepted solution]

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

 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)