IDEAScript Questions

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

Hi Brian,
I am trying to do a script to extract all transactions on saturdays and sundays. 
When i go to field statistics i am able to see this and extract as well. But it doesnt get generated as a script. Also i am not able to find any idea function which can workaround.
How to go about?
 
Regards
Padma

I am working in a script that open an txt file and replace any caracter that I choose for another one, so far everything is ok.
The problem is when the file that I am reading contains quote marks(") as at example attached(input.txt).
In this case, when the script faces one line that contains a simple quote mark in the middle is enough for the program launch an error message to the user (image attached). 

Hi,
I am trying to write a script to find out the consquetive invoices of a vendor from vendor ledger.
Input  (Consequtive check is a computed field)

Vendor number
Invoice no
Amt
Consequtive check

1
123
10
Start

1
124
20
Yes

1
125
30
Yes

1
301
400
No

1
302
200
End

2
2134
7000
Start

3
6162
100
Start

3
6163
100
Yes

I've been trying to figure out a way to deal with user created folders. 
Its very common for users in my organization to work with a set of databases in IDEA and then create a folder to organize them within the current directory. They will create a folder and then move the databases over. The problem though is many of the scripts that I have been written can not find those databases moved into those folders. The scripts will pull all the databases in the current directory unless they are within a folder. 

Hi everyone,
Can you please help me vb macro in idea
I have direct extraction equation below
@match(columnname,1000) and.columnname < 0
Where in scripting I need to change the column name by selecting drop-down and account numbers were changing Case by case so I need input different account numbers.
 
Please help me in this regard how to write macro for this.  
Thanks in advance 
Nagaraj Arali
 
 

Hi,
Can anybody tell me the syntax to add items to a CirSimpleList placed in Idea Scripting Dialog control? 
Thanks,Rini

i'm looing for somthing that keeps counting the last 5 days per id.
so from the fifth row, while the id is the same, i add the "amt" but if the "id" changes, it starts again.
for ex.