Skip to main content

IDEAScript Questions

Double Quote Issue

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?

Adding multiple radio buttons

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?

Seemingly unrelated change to dialog is causing FileSystemObject methods to throw internal error

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 :)
 

Doing summarization task with dialog buttons

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!

ODBC Connection using IDEA Script

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"""

Working with Arrays

Hello,
I am working on a project that involves populating multiple drop down lists via arrays with the field names from a previously selected database. There is also an array that is being used to populate information for another part of the process. The problem I am running into is that once I add in my 3rd drop down menu (4th time an array is being used) I keep getting the error: "Subscript out of range". Am I missing something that would clear the array each time I use it? Below are some sections of my script:

Appending Data files to Header files that are not transposed

Hello everyone
Can somebody please assist if this is possible. I have over 100 files with data and 100 coresponding files with headers (column names of the data files). All 100  data and header files are in different names, but sharing names as pears. The header files have all the headers in one column (all headers are in rows). Thus, I was wondering if there is an IDEA script or way to traspose the header files first and then append each trasposed header file to its corresponding data file. Please help if possible.
Thank you. 

Delete parent database without deleting child database

Hi,
 
is there a way to script deleting a parent database without deleting child database. When I do this manually it comes up with the option: would you like to delete child database? Is there a way to script this? (havening been able to find anything)
thanks for your time,
 
Mike

Append field using a local variable.

Hi,
I have developed this script.
I want it to get the value Materiality and return a new field with YES or NO for additional filtering (i.e. PerfMateriality and Sampling).
The code is stuck on task.AppendField field as Syntax Error.
Could you please help me?
This is the code.
Sub Main
Dim Materiality As Long' Could set to 2 decimal places & do similarly for the following two variables
Dim PerfMateriality As Long
Dim SamplingThreshold As Long

Looking Advice on How to Implement a Same-SameOrNull-Different Test

I'm currently trying to identify duplicates in our vendor file. I'm tackling the issue of using the address, because I'm able to find a lot of potential duplicates which we would not otherwise identify (e.g. John Doe and ABC Corp at 1234 Main St).
The manual algotrithm which I'm doing currently works on three criteria: