Skip to main content

IDEAScript Questions

Obtaining user details

Hi,
I have been trying to find a way to get the user details to pre-load a dialogbox with a possible path - eg C:\Users\jdgoodchild\Documents\IDEA9\Exports.ILB
Using set userprofile at a DOS prompt, I get USERPROFILE=C:\Users\jdgoodchild - just what I want. So I tried
Sub Main
Dim wshShell
Dim wshSystemEnv
Dim WScript
 
Set wshShell = CreateObject( "WScript.Shell" )

How to use optional field to sort or index?

Hi,
I wanted to use a drop down list to select some columns and these are not mandatory selection, for example there are five criteria's provided, if user selected all 5 criteria (tagged 5 column/fields) I want to use all five fields to sort/create index and perform direct extraction using that index, if user tagged only one column then I need to sort the field using only that criteria and so on...
I am not sure how to use "task.addkey" in these conditions. Can anyone please help me with the code.
 
Thanks in advance,
Vijay
 

Export a manualy selected range of records

Hi,
first of all excuse my bad english.
I will export an IDEA file to excel. But I will only export the records I marked. (ctrl + left mouse klick)My idea is to mark the records (i.g. record-nr 1, 5 and 9) an then start a script to export only these records to excel. (or first to a temporary ideafile an then to excel)
Many thank for your help
Kind regards
Thomas

Excel Export

I am working on creating my scripts to audit multiple systems at once. I am currently using Excel to perform this task but Corporate policy is directing me to move to IDEA. I have most of the scripting done but I am wanting to export multiple database files to one Excel file. I know this is possible if I were statified with .XLSX but I need it to be .XLSM. Do you know if this is possible?
Thanks

Field names

Hi,
I would like to know if it is possible to create a variable that is very general:
for example "Dim a as an integer" with a=any integer or a range of integer.
I would like to do that because I have some field names whose name are pratically the same, only the number at the end change:
"SEGMENT1"
"SEGMENT12"
"SEGMENT13"
I would to know if it is possible to have a variable that can store any integer and have something like:
"SEGMENT"&a
Thanks in advance for the help :)

Pass the filename from the 1rst function to the 2nd

Hi,
I have 5 joins to make, I put a picture to show what I mean. I would like to use the client.uniqueFileName for the name of each database after each join.
I manage to use  the client.uniquefileName for the two first join by using the method "calling a sub-routine" but I can not add the 3rd, 4th and 5th join.
I do not manage to pass the filename from the 2nd function to the 3rd function.
I can not upload my scripts, they are in .ism :(
Thanks in advance for the suggestions :)