IDEAScript Questions

Hello, I have a question regarding IDEAScripting. This is something that I can easily do on SQL but I haven't managed to find a solution for this using IDEA.
 
Given the sample data on the attached image, I am looking to find a group of transactions, within 5 days from eachother, which sum of amount is above 5000.
 
For the given data it would be the transactions on the following days:

Hi all,
I have read some scripts writing about import multiple files and there is a part about Shell function that I am not clear. For example
 
Function BrowseFolder()
Dim oFolder, oFolderItem
Dim oPath, oShell, strPath
Dim msg As String
Set oShell = CreateObject( "Shell.Application" )
Set oFolder = oShell.Namespace(17)
Set oFolderItem = oFolder.Self

Hi all,
I need to import a very large number of files and append them into one master database.
I have written a simple script to import the files, and another simple scripte to append them into one database. So, I can just run the two scripts one after the other and be done.
However, due to the very large number of files (>500k), I am a bit  worried about performance: IDEA needs to 'open-read-write-close' the files twice: first for the import-routine and then for the append-routine.

I got like 24 export to excel files, i want to loop the call function with export1, export2 until export 24. When i use the code below i get the result in a message box correct but with the call function i get an error unexpected array. Do i miss something?
Dim Q As String
Dim Func As String
Q = 24
For i = 1 To Q
Func = "Export" & i
'MsgBox Func
Call Func
Client.CloseAll

Hi all - as always, thanks in advance for the help!
I use the Filldown Utility from the IDEAScripts section of the site all the time. What I'd like to do is incorporate that functionality into another script I've built that does some file cleanup on a standard file I receive frequently. But, I want to skip the dialogue box to select the fields to fill down and instead have a defined list of ~5 fields to run. How would I do that?

Can Anyone PLEASE help me !
I am attempting to make a dialogue box where:1) The user selects a database2) Selects upto 15-20 feilds from a drop down which are mapped in my report.3) The fields the user selects are then renamed(modified) to a particular name.4) I have a generlaised script that will then, run for further analysis basis those new fields names. The problem i am facing is - How do i script the following: 

Hi there.

I have may Idea files (*.IDM) in a project. Is there a way to collect every single ideascript for those idea files?

Thanks in advance.

Hi all,
I am writing my first IDEA script. I have searched many topics but could not find the solutions. My problem is msgbox displayed many times when users click on the button several times. In the pictures attached, when users click on Check Ready button 2 times, 2 msgbox will be displayed. Hope to hear from you soon!

Hi,
 
I'm having a bit o a trouble with a script. I want to builda script that creates a new field and insert data in it based on the data existing in one field.
I have uploaded the script.
Basicaly, I want to create a field called CUI and populate it with data from the field FIRMA using the equation @JustNumbersTrailing(FIRMA) but I keep getting the error "Error on line 18 - Automation object does not have a deault value".
 
I would appreciate some suggestions.
 

Hello, im trying to create a script that has an input option to select a time frame on a dialog. For example i would like to be able the user to input a date (12/31/18) and then pull all transactions for the 12 month period ending 12/31/18. Or enter 9/30/17 and then the script would run for the previous 12 months.
Thanks in advance for any help.