Skip to main content

IDEAScript Questions

Large and Unusual extraction

Hi Brian,
I am trying to develop a script to run a 'Large & Unusual' style extraction over a range of different databases. This requires two seperate functions being:

  • direct extraction based on a user defined $value (similar to your IDEA Scripting Tutorial video); and
  • direct extraction based on key words in a character field (such as a description field).

My issue is that our standard databases include:

Script - front end

Hi Brian,
I would like to build a script front end, as I have created a major script with lots of minor script each referring to a specific audit testing, where before runnig everything the user is requested to select some or all analysis to perform and also in which order. Have you ever created something like this? In case, would you like to share with me some guidance or advice? I have never created one. 
Thanks, Giorgia

Set a field as variant in an equation

Hi,
I am trying to automate some analysis and I don't know how to fix the following code in order to include the field as variant because I have several fields in where I need to adjust the format. Can someone help me to insert the variable field in my equation editor? This is where my code stop working, I have copied it here! Thanks
Function ModifyAllDateField (DateField, WorkingDatabase) As Variant

Call script with more 4 parameters

Hi all,
 
I have a problem with my Ideascript macros. I have a macro with different variables and object variables. So I want to send more than 4 variables to other macro but I can't. 
I see and read different solutions such as read variables from a text file (after writing) but I want to avoid use this solution...
Moreover, I didn't find a solution to send an object variable to an other Macro or may be it is not possible...
 
Thanks
 

Script for On Error Resume Next in IDEA

Hi All,
Someone help me please, I want to join database A (Primary) and database B (Secondary) with "All Records in Primary File". My trouble is when in database B there is no records (this is cause depend on automatic script before) then the macro is stop.
May anyone can help me? is there any script like in excel (On Error Resume Next) to join those databases?
thank you

Bad equation provided on "task.PerformTask 1, db.Count"

I am trying to write a script for nested direct extractions and I name each extraction with a number included for which number in the sequence of nested extractions it is.  For example, I run an extraction on a database and call is EXTRACTION1, then I run a second extraction on EXTRACTION1 and call it EXTRACTION2.  When I get to the double digits of numbers I get an "Error on line 88 - bad equation provided".  On that line is "task.PerformTask 1, db.Count".  In other words, when I get to doing EXTRACTION10, the aforementioned code returns an error.

"Looping" IDEA Script Example

Hi Brian,
I have developed a script in ACL that uses a command called the GROUP command.  The GROUP command allows you to process a single record mulitple times and in effect, lets you set up a "loop" that allows you to do different types of data analysis tasks.
Is there a similar command in IDEA or is there a way I can accomplish this same thing using the IDEA scripting language? If you have an example IDEA script that you can point me to, that would be great.
Thanks so much in advance for your help!
Mike