IDEAScript Questions

Hello,
I am looking for a script that allows me to export multiple databases (4 standard databases) to one Excel file in multiple tabs, such as: 
- IDEA Database A = Excel tab A
- IDEA Database B = Excel tab B
I found a script on this forum where you can indicate which IDEA databases should be exported to one Excel file, because in my case there are four identical IDEA databases at all times, I would like to leave out this window and export the 4 databases concerned to one Excel file with multiple tabs by default. 

Hi,

Hello,
I just want to know how to unpivot columns in IDEA. The example below is what I am trying to accomplish.  Thanks for the help!
 

Name           Grant Name          Amount

John                 Grant 123               1,000

I have a script to create an array with the fieldnames of a database. But for a check i need to exclude two fields of which i know the name. But is it possible to search the array for a match and remove that row in the array?

Hi.  I am working on a project to compare a data set DATATABLE with customer names (CUSTNAME field) against a separate table KEYWORDS with 1000 words.  I want to either filter, or extract/return, results if there is a the CUSTNAME field contains any word in KEYWORDS.
Is there a way to do this?  I'm thinking probably a loop to go through each of the data elements in the key words table and then to do a "contains" comparison with isini or something?  Just wanted to see if there was a way, or code available, to do this.  Thanks!

Hi @ all,
i tried to compare 2 pictures within a dialog.
But it doesn't work. Has someone a suggestion to solve the problem?
Thanks a lot
Jan

Hi Brian,
Hope you're doing good. Am looking for a Idea script which can be used to knock off positive and negative values from a data set taking into considerations the GL codes as well.
Currently, I am able to perform this in an excel file by using the below mentioned formula,
“=(COUNTIFS($B$2:B2,B2,$A$2:A2,A2)<=MIN(COUNTIFS($B$2:$B$1000000,-B2,$A$2:$A$1000000,A2),COUNTIFS($B$2:$B$1000000,B2,$A$2:$A$1000000,A2)))”

I can't get the IDEA script to open a Excel file, i also can't find the answer on Google. Is there anyone with some experience with this?
 
Sub Main
Dim Workbooks As Object
Dim ActiveWorkbook As Object
Dim File As String
File = "H:\!OHW\IDEA\Test Project 01 (9999990)\Import Definitions.ILB\Import definitions.xlsx"
Set Workbooks = CreateObject("Excel.Sheet")
Workbooks.Application.Visible = True
Workbooks.Open (File)
 
'Workbooks.Application.Quit
'Set Workbooks = Nothing
MsgBox "Gereed"
End Sub

Helo,
Could someone help me with this case. I have file name that contain date format.  Could anyone help me with scripts that can  import automatically based on now date and one/two/three days before.
 
Thank you for your help.

Hi,
Is it possible to create an IDEA script generating text file in which list down all field modifications and new field creations?
For example, the field "Date" when imported will be renamed to "SaleDate" and this field will be used to create a new field called "FinalDate" later