IDEAScript Questions
Making macro universal
Forums
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.
- Read more about Making macro universal
- 3 comments
- Log in or register to post comments
capture error
Forums
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.
- Read more about capture error
- 5 comments
- Log in or register to post comments
Run set of extractions for each database in project
Forums
Hello, I would like to run a set of extractions and summaries on each database in a project. I used the history of the extractions I did as a starting point, but I seem to be stuck.
- Read more about Run set of extractions for each database in project
- Log in or register to post comments
How to Export a Pivot Table Using IdeaScript?
Forums
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?
Identify Current Index On Database
Forums
Hi Everyone,
Is there a way to determine the current index of a database?
Thanks,
Scott
- Read more about Identify Current Index On Database
- 1 comment
- Log in or register to post comments
Sending Results to an IDEA database through IDEA scripting (e.g. Pivot Table)
Forums
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.
Hash value
Forums
Are there any function in IDEA or that can be called with a script to calculate a hash value of a string?
- Read more about Hash value
- 2 comments
- Log in or register to post comments
csvDefinition: CsvFileEncoding=2 does not recognize ä,ö,ü
Forums
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
Forums
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
Forums
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
- Read more about Variable in IDEA editor
- 3 comments
- Log in or register to post comments