IDEAScript Questions

Hi Brian,
I have a file with user rights assigned to roles.
I have another file which has the conflicting user rights. this file has 2 columns T code and conflicting T code. i.e. If T code is F41 and conflicting T code is F56 it means that roles which have F41 assigned and also have F56 assigned are conflicting.
There are more than 100 items for which such conflicts have to be found and around 2500 combinations. 

I am trying to wrap up some inputted value within a formula using the following bit.
Hi there,
I have two bits:
1) This works fine
Function Starters
Set db = Client.OpenDatabase("PAYROLL_DATABASE_COMPLETE.IMD")
Set task = db.Summarization
task.AddFieldToSummarize "PERSON_REFERENCE"
task.AddFieldToSummarize "SHORT_DESCRIPTION"
task.AddFieldToTotal "VALUE"
task.Criteria = "DATE_STARTED > @Ctod(""&dYear&"",""ddmmyyyy"")"
dbName = "Starters.IMD"
task.OutputDBName = dbName

I have the current import script:

Sub Main
Call ExcelImport()
End Sub

Function ExcelImport
Set task=Client.GetImportTask("ImportExcel")
dbName="C:\Desktop\myfile.xlsx"
task.FileToImport=dbname
task.SheetToImport="Sheet1"
task.OutputFilePRefix="Test"
task.FirstRowlsFieldName="True"
task.EmptyNumericFieldAsZero="True"
task.PerformTask
Set task=Nothing
End Function

Hi is there a way when using @isin or @isini to point to a list values stored in a different database?
I have a list of values created using the following code attached.
I need to sift through the GL transactions and pick up the transaction related to the names in the list.

Thank you for your help.

Kind regards,

Hi,
i'd like to know if there is a function or script to allow me to delete a file without name it (automaticly)
like the function Client.CloseAll

Thank you,
Ahmed

How to:
1) Prompt the user to insert dates or text
2) Use the variable inputted as factor within task formulas

I have a script that first backs up prior idea files before it creates new ones. Some files though are locked and even if I use an error handler, the script still brings up an error prompt. Is there a way to force unlock using the idea script or suppress this error message?

Hello! I am trying to run the script which performs a joined database and summarisation. However, i am having issue with my summarisation where by the error message , i have try many ways to debug this but it doesn't seems to work. Wonder if anyone could kindly assist me on this! Thank you!

Hey guys,

Im trying to extract values from a table with the criteria being that the values in the columns have to be >= 30. This parameter, however, can vary. I created a separate Excel-table containing this value to ensure that other people dont have to go into the code and change it there.

I would like to add to my script a dialog box where the user selects the database that is to be opened and tested. I also want another dialog box where the user can enter a part of a output database name (like the year) and use that value in a variable to name part of the output table, if that makes sense.

So part of the output database name would be static, like Duplicates Payment Test and then add the variable for the year at the end.

Thanks in advance!