Table Preview by Scripting

8 posts / 0 new
Last post
kai
Offline
Joined: 10/12/2016 - 02:47
Table Preview by Scripting

Is it possible to generate a table preview window by idea script?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Kai and welcome to the site.

Unfortunately you can't do previews using IDEAScript, I assume that you mean using something like the criteria to filter the information.  Maybe you could explain what you are trying to do and I might have some suggestions for you.

Brian

kai
Offline
Joined: 10/12/2016 - 02:47

I want to generate a temporary IDEA-file and display it as a preview with two buttons (Cancel, Save as..).
(e.g. extraction preview of a summarization) 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

About the only thing I can suggest is that you create a dialog that displays part of the information with the cancel, save, etc buttons.  Unfortunately you can't use IDEAScript to develop a preview that you can scroll through.

You could also output the info to Excel and the user previews in Excel then returns to a dialog that asks what they want to do with the information in Excel.

Clara
Offline
Joined: 03/16/2020 - 07:57

Hello, 
 
I have a similar doubt:
 
I am trying to do by IDEAScript the extraction in different databases of the grouped recordes I have after a summarization.
This is: I summarize, i click where is written "NO_OF_RECS", and the save those records shown.
 
Is this possible?
 
My global intention is to export in separate databases every single group of records from the summarization.
 
Thank you very mucho, 
 
Clara

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Clara,

How many items are in your summary.  If they are less than 500 you could use the Key Value Extraction instead as it was made to do something like this.  

Another way it to put the items in your summary and then create a loop to extract each one of them using a direct extraction.  

Clara
Offline
Joined: 03/16/2020 - 07:57

Hi, 
thank you four your help. I has doing the direct extraction way. 
But, the point is that I want one separated database with each of the different cases I get. I mean:
I have done the summarization by ID, REFERENCIA and IMPORTE; so i get as a result the picture n1.
Afterwards, I do the direct extraccion where NO_OF_RECS > 1. Picture n2
Here is where I want to save each database from each case. So I select the NO_OF_RECS, and save (picture3 shows this)
And a new database is stracted, right? (picture4) But these isn't shown in the IDEA script.
 
What I want to do is to automate the process of extract in different databases every case from the summarization table where NU_OF_RECS > 1. But I don't now if that is possible of is there is any toher way to automate this.
 
Thank you very much, 
 
 

Images: 
dhuffman63
Offline
Joined: 07/18/2019 - 11:20

Could you do this by recording all your steps as a macro and saving as an IDEAScript?  I've done that with several of my projects even those where I have to download through ODBC different databases and join several times.  I first draw out the tables involved and the fields I want to capture.