Skip to main content

IDEAScript Questions

Making macro universal

Hey IS Forum!
Right now I'm trying to solve an issue I faced while using one of my macros that I made a while ago.
Purposue of my macro is perform some tasks regarding appending new columns in files that have to work with on a daily basis.
 
Lately, unfortunately, instead of one file there are several files that I receive for analysis event though it is the same in terms of its content.
I know that I can append them and run the macro but there is some specific issue that i think when resolve on my end would be able to help in my future work.

capture error

Greetings.
I am new to ideas, and I have found this forum, which has helped me with some scripts; congratulations to the creator.
 
I have used the routine of executing scripts that were created previously, these are divided into projects and at the same time they are programmed for initial at a certain moment, this comes from versions prior to 11.2 which is the one I currently have, because of this there is a script that does not they execute me.
 

How to Export a Pivot Table Using IdeaScript?

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?

Sending Results to an IDEA database through IDEA scripting (e.g. Pivot Table)

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. 
 

csvDefinition: CsvFileEncoding=2 does not recognize ä,ö,ü

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

Changing default file name in task.DisplaySetupDialog

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.

Variable in IDEA editor

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