IDEAScript Questions
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
Searching dates with direct extraction with a variable
Forums
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")
Script current date as a column header
Forums
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:
- Read more about Script current date as a column header
- 1 comment
- Log in or register to post comments
Outlier Detection Using Machine Learning
Forums
Has this resource been remove?
http://ideascripting.com/IDEA_Lab/outliers-detection-using-machine-lear…
Thank you,
Rich O'Hara
Scranton, PA
- Read more about Outlier Detection Using Machine Learning
- 4 comments
- Log in or register to post comments
Convert Filed to date using a mask inputted by user
Forums
Good morning,
I am trying to convert CHAR fields to DATE but I don't want to hadrwire the mask in the equation.
I have tried to wirte concatenate the variable with three and two "" but the result is the same.
Is there a way to let this work in this way? I am almost done with the macro and this is the last bit.
The bit coded is attached, thank you very much for your help.
Vito
Set decimal and thousands separator in csvDefinition
Forums
I am using a comparable code as mentioned in this post:
http://ideascripting.com/forum/create-rdf-file-csv-import
The code works and imports my csv file. However, in my original csv file the decimal separator is ".". When I now open my IMD file I can see that these are character columns displaying for example 9987.5. When I manually do the import I can set the options as mentioned in this post: