IDEAScript Questions
Export History
Forums
Is it possible to export the history to a txt file from the IDEA script?
- Read more about Export History
- 3 comments
- Log in or register to post comments
create rdf file for CSV import
Forums
Hi,
I am trying to import a csv file using an ideascript. I understand that there needs to be a corresponding rdf file otherwise the import wont work. Is there a way to create the rdf file using ideascript?
thanks,
Mike
- Read more about create rdf file for CSV import
- 8 comments
- Log in or register to post comments
rename column by position
Forums
Hi,
Is it possible to rename the column of a database based on its position rather than its name? For example, change the last column of a database to a standardised name.
I am looking for something similar to how you index by columns with a data.frame or matrix in R and Python.
thanks,
Mike
- Read more about rename column by position
- 2 comments
- Log in or register to post comments
Is the a way to automatically replace databases when the script is running?
Forums
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
Forums
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
- Read more about Check for multiple conditions
- 1 comment
- Log in or register to post comments
global variable
Forums
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
- Read more about global variable
- 5 comments
- Log in or register to post comments
Build exe with External Variables
Forums
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...
- Read more about Build exe with External Variables
- 3 comments
- Log in or register to post comments
Script preformance
Forums
Is there any information about the time duration that some IDEA actions take? I have a large script and sometimes with a file with more than 1.000.000 records with a rather big size the script takes around 8 to 12 hours to finish.
- Read more about Script preformance
- 1 comment
- Log in or register to post comments
Export multiple databases to one Excel file
Forums
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.
- Read more about Export multiple databases to one Excel file
- Log in or register to post comments
Compare a record with a previous record
Forums
Hi,
- Read more about Compare a record with a previous record
- 3 comments
- Log in or register to post comments