IDEAScript Questions

Hello,
I'm trying to export a pivot table but I don't know the code to do this. I already know how to export it by using the interface of IDEA, but I need to create a script to automate the process and users just have to look for the excel in the export folder. Does anyone know how to do it?

Hi Everyone,
Is there a way to determine the current index of a database?
Thanks,
Scott

Hello Everyone
 
I hope you are all well.
 
May you please assist?
 
I was wondering if there is a way to send your Pivot Table results through an IDEA script to an IDEA database, rather than having to go and manually select "Send to IDEA database" after you have created you Pivot table. The creation can be done through a script, its just the turning the results of the Pivot Table into an IDEA database that i dont know how to get around in scripting. 
 

Are there any function in IDEA or that can be called with a script to calculate a hash value of a string?

Hi,
I am using the normal csvDefinition to import a csv into IDEA. The code is mentioned also here:
http://www.ideascripting.com/comment/3213#comment-3213
Sub Main

csvPath = "Source Files.ILB\Delimited.csv"
rdfPath = "Import Definitions.ILB\Delimited.RDF"
firstRowAsFieldNames = TRUE
CsvEncodingUTF8 = 2

Hi, I'm trying to change the default file name (join.imd to ABCinc.imd for example) in task.DisplaySetupDialog.
But when I excute the script, the default name displayed is still join.imd. Is there a way to change the default name?
I also want to change the default selection to: task.PerformTask dbName, "", WI_JOIN_ALL_IN_PRIM
How can I do that with task.DisplaySetupDialog?
Thanks for help.

Hey, guys, I tried many things and didnt find the answer.
My problem is that I want to get a value from an InputDialog and assign it to a variable: so far so good.
Now I want to use it in the equation editor. Unfortunately, I cant sort out the double quotion marks in a right way.
This is the code that I'd like having to work:
 
0) this is the inputbox:
Dim eingabe As String
eingabe = InputBox("Bitte geben Sie hier das Rückrechnungsdatum ein", "Rückrechnung", "")
MsgBox "Datum zur Rückrechnung: " & eingabe

Hi, 
I am relatively new with IDEAscript, but faced an issue that I finds difficult to resolve even with searching for help on the web. 
My script is meant to recieve input from a database, using the value and change it into criteria to filter the result,
I was constantly prompted with bad equation, I have also changed to array but same result. 
here is a snip shot of my code (highlighted yellow and bold as the issue):
 
Call multidatesearch("20200403,20200503,20200305","Sample")

Hello, I am relatively new to IDEA scripting and have come to my first brick wall.  Hopefully someone here may know the answer. I am trying to script a self updating database to keep track of inventory audits.  My script runs in the following order:

 
Has this resource been remove?
http://ideascripting.com/IDEA_Lab/outliers-detection-using-machine-lear…
Thank you,
Rich O'Hara
Scranton, PA