IDEAScript Questions

Hi! Is there an easy way to create a macro that combines multiple existing macros withouth restructuring the script?
Any help is appreciated.

Hello, everyone. I'm quite sure I read something, somewhere...just can't fetche the source to my memory right know. But I'm quite curious about this topic: Iknow windows let you schedule a program execution by selecting in this cases ideascript.exe, but I wonder what could be the arguments I would be passing to the task manager wizard in order to program an ideascript periodical execution?
Thanks in advance,

Hi,
I'd like to rename the field names that fits a certain list in every file of my project.
For example:
Some files in my project have columns named "YEAR", "DATE", "BALANCE" and they have to be renamed into "YEAR_1", "DATE_NEW", "BALANCE_X". So they don't get the same extension but every field name has a new field name without some logic behind it.
 
It would be nice, if one could have a dialogue box with every .IMD file in the project where you can check which files should be scanned for old field names and replace them with the new ones.

Good morning,
I have a summarisation report with 54 records each of those has a number of instances that renges from few thousands to more than two millions.
Now, what I need to do is to export each row in a separate csv or txt file that will be sent to the relevant audit unit.
Is there any script that could help me in having typefile needed and automate the export  process? 
Those 54 entities could become more than 100 at the end of the year and I need to automated the process.
Thank you very much for your help.
Vito

Hi, 
I tried to solve this issue I'm having, but couldn't find a solution.
The code I upload work very well when a user choose date fields or character fields in the dropdown boxes. However, in case of numeric fields chosen, it says that "Bad equation provided"
The part I'm talking about is the following:
If extractionType Then
If IsNumeric(acilirListeVerisi1) And IsNumeric(acilirListeVerisi2) Then
eqn = acilirListeVerisi1 & " <> " & acilirListeVerisi2
Else

Hi,
I want to let users type 20181231, so I want to get the following via letting a variable be equal to that date users type.
task.AddExtraction dbName, "", acilirListeVerisi1  & ">" & " ""20181231""  " 
That is if I let var=dlg.txt1, then how should I modify (task.AddExtraction dbName, "", acilirListeVerisi1  & ">" & " ""20181231""  ") so that I can still get the desired code when a user type 20181231 manually?

Hi, I tried to add multiple radio buttons to the script, but so far only the first radio button is working. That is, no mather which radio button I choose when doing extraction, it always gives me this result:
Extraction Criteria:      (@DToDays(İRSALIYE_TARIHI) - @DToDays(BELGE_TARIHI))  > 7
PS: İRSALIYE_TARIHI and BELGE_TARIHI are date fields and 7 is the number of days.
Could you please tell me why this is not working?

I apologize in advance for the length of my script and the fact that it probably fails to follow a host of best practices in IDEAScript and/or VBScript... I'm pretty new to this, so bear with me :)
 

Hi. I found this code here and tried to utilize it in one of my tasks.I want the user select two fields to see for example how many different companies have the same IBAN numbers by doing summarization task. So, the user needs to first choose IBAN, then needs to choose the company. Here actually I want to detect that these companies' names are failed to be saved previously.
I am completely new to this program and ready to take all the advice and help. Thanks in advance!

Hello everyone,
 
I've trying to create an ODBC Connection using IDEA Script Code (to work with Microsoft Power Bi). First it seems to be easy: Simply use cmd commands. But i couldn't find the right command. Access Database and Excel works fine, but I'm missing the right command for the IDEA ODBC Driver.
 
This is, how I've tried it:
 
(It's german, Treiber means Driver)
 
Phrase1 = "odbcconf configdsn"
Phrase2 = """CaseWare IDEA Treiber"""