Skip to main content

IDEAScript Questions

Is the a way to automatically replace databases when the script is running?

Hi There
May you please possible assist. I was wondering if there is an IDEA scripting function, methode or piece of code in IDEA that will allow IDEA to automatically click on "YES" when the script is asking for the existing database to be replaced. The problem I have currently is that I have large scripts and i have to sit there and press yes everytime there's a database that needs to be replaces, in order for the script to continue running.
Thank you.  

Check for multiple conditions

Hi there,
I have the following two tables that i'm trying make a test as below:
Table 1
User | transaction 
User1 | transaction1
User1 | transaction2
User1 | transaction3
User1 | transaction 4
and
Table 2
Case ID | 1st transaction | 2nd transaction | 3rd transaction
Case 1 | transaction1 | transaction 2 | transaction 4
 

global variable

Hi, I am new to using IDEAScripting. I would like to define global variable(s) in the main sub that I can then use in functions. Could you give me an example of how to do this? I am doing this so that I can change the name of the database to re-use the macro. Currently I am having to define the same variable in each function. 
thanks for your time,
Mike

Build exe with External Variables

Hello,
I'am new with IDEAScript, and i have some doubts...
I made an Script using External Variavels. So, IDEA made a file with extesion name ".EVARS". But, when i build the file for EXE, the build just dont save the external variavels file and the build does not call it too.
 
My questions is, exist any other way to compile with in the External Variabels our just put them in ISS file?
I just dont wanna use both files...

Export multiple databases to one Excel file

Hello,
I am looking for a script that allows me to export multiple databases (4 standard databases) to one Excel file in multiple tabs, such as: 
- IDEA Database A = Excel tab A
- IDEA Database B = Excel tab B
I found a script on this forum where you can indicate which IDEA databases should be exported to one Excel file, because in my case there are four identical IDEA databases at all times, I would like to leave out this window and export the 4 databases concerned to one Excel file with multiple tabs by default.