Pushbutton

William Yong

Forums

Hi Brian,
I have created an extraction in IDEA. My task now is to automate it by creating a menu / dialog box for the user. How am I able to trigger a pushbutton and display the direct extraction result via IDEAScript. Example, I have a pushbutton called 'A'. If 'A' button is pushed, the extraction result will be displayed.  Same goes with button 'B', 'C' and so on. Should I also put a Do..Until / Select..Case loop in this situation. 
Any help with sample scripts would be great here.
Thanks.
William

Brian Element Tue, 07/22/2014 - 07:23

Hi William, you could do something like this to check the code.

If UCase(Mid(sImportDefinition, Len(sImportDefinition) - 3, 3)) <> "JPM" Then
	'it is not a jpm file
Else

End If

 

William Yong Fri, 07/25/2014 - 06:07

Hi Brian,
I encounter error while input the code that you recommended. Please refer to 'error msg(2)' screen attached. What could have gone wrong here?
How am I able to allow user to go back to the menu screen to perform other task after the result is displayed? I put the Do..Loop While button > 0 inside the Function displayIt, but it seems not working here. Please assist. From the 'replace existing file' screen, how am I able to prevent user from seeing the same screen while perform/execute the same test in the menu? And lastly, from the 'idea files' screen, how am I able to display only the results from my last action, instead of displayed all the databases in the idea files window. And I noticed from the last selection of the aaaaaa2 files, the result/output is displayed in the aaaaaaa database. Any idea that I could make the results generated in the same database selected?
Thanks in advance.
Regards, William.
 

Brian Element Fri, 07/25/2014 - 07:16

Hi William for the syntax error the mid function does not seem to like having a variable as the second paramater.  I think I tried the original one on V9 and it works by V8 gives an error.  Can you try the following as this seems to work:

If UCase(Right(sImportDefintion, 3)) <> "JPM" Then

For your second question it is hard to answer without seeing your script, any chance you can send it to me at brian.element@ideascripting.com and I will have a look at it.

To display only what you want to can use the db.close at the end of each routine and delete the line that is usually added saying client.OpenDatabase(dbName).  You can also use the client.Closeall function and then only open the database that you want viewed.

To get rid of the Replace Existing File dialog you can do two things, when selecting a new database name you could use the following function:

dbName = client.UniqueFilename("Filename") 'make sure you don't include the .imd at the end

or you could delete the old file and then replace it with the new one.

I think I covered your questions, let me know if I missed something or if something doesn't make sense.