IDEAScript Questions

Dear All,
 
Currently i am making a script that is supposed to extract all cash transactions in excess of 15K. The data that i use is an auditfile(.adf). This is a database with all the journal entries of a financial administration. 
 

Hello, 
So I have this script that I've used countless times. I made a copy of it and within the copy made a few changes to the code to add some additional options. The issue is that when I run this new script it will sometimes run the entire script as it is supposed to perfectly, but then sometimes it just closes midway through. I've stepped through the program using the script editor and it works perfectly. I can't figure out why its closing early. 

Hello!
 
I found this code:
 
 
    For i = 0 To x   
 
           ' Set-up the XML import task
     Set task = Client.GetImportTask("ImportXML")
     task.InputFileName = picked_folder & "\" &  listbox2$(i)
 

Hey Brian,
This site has become a staple for me. Thanks so much for all your assistance.
I am trying to obtain the selection from a drop down combo box; however, when I select COL1 where the data is to be tested - nothing happens. When I select COL2 then the script continues and completes my test using the COL1 information. Any idea how to fix this or why it is happening?
This is a copy of the code that I am using to obtain the drop down combo box selection.
If dlg.DropListBox1 > 1 Then
userSel = ListBox1$(dlg.DropListBox1)
Else

Hi Brian,
Is it possible for the user to enter the column to be tested and the extraction to use the user defined variable instead of hardcoding a column which will need to changed every extraction?
colNum = InputBox("Enter column to be tested (Col1, Col2, Col3 etc...)")
task.AddExtraction dbName, "", "@Isini(""Oper"", colNum)"
These are the two lines specifically. I tried to do it and it shows "Bad equation provided"; however, if i type Col1 instead of colNum, then it works.
Any ideas?
Thanks!

Hey, I've been trying to create a script which will perform a calculation to verify that a list of swedish social security numbers are valid. This is done by a mathematical process.

Hi Brian,
If I have a IDEA file and there exist 4 index , have any possible to write a function to get all index information  ?
Thanks,
Derek
 
 

Dear All,I have a script that I’m going to send it to my colleague so, I’d like to secure this script to allowed him to only execute the script without modifying  or reading the contents 
Thanks’.

Hi Brian,
I have two files. 
1. Stay database- which gives the date range for a particular record. For Eg:- Mr.A has stayed from 1st April 2017 to 4th April 2017.
2. Transaction database- This has the list of charges posted for each customer. So in this i would have day wise charges posted for Mr.A
Now i want to compare whether for every day stayed i.e. 1st April, 2nd April, 3rd April and 4th April the charges have got posted in transaction database or not.
How best can i do this using a script?

Hi Brian,
i created a script for pivot table results.
1.  I dont want the subtotals to appear in the pivot. Is there a way to include this in the script itself? Right now i need to manually right click and give remove field.
2. I may run the script multiple times over a period. I do not want a new pivot table result to be created everytime but it should be replacing the existing one. But this is not happening.
 
Could you please help.
 
Regards
Padma T