IDEAScript Questions
Double Quote Issue
Forums
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?
- Read more about Double Quote Issue
- 9 comments
- Log in or register to post comments
Adding multiple radio buttons
Forums
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?
- Read more about Adding multiple radio buttons
- 1 comment
- Log in or register to post comments
Seemingly unrelated change to dialog is causing FileSystemObject methods to throw internal error
Forums
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
Forums
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!
- Read more about Doing summarization task with dialog buttons
- Log in or register to post comments
ODBC Connection using IDEA Script
Forums
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"""
- Read more about ODBC Connection using IDEA Script
- Log in or register to post comments
Working with Arrays
Forums
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:
- Read more about Working with Arrays
- Log in or register to post comments
Appending Data files to Header files that are not transposed
Forums
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
Forums
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.
Forums
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
- Read more about Append field using a local variable.
- 3 comments
- Log in or register to post comments
Looking Advice on How to Implement a Same-SameOrNull-Different Test
Forums
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: