IDEAScript Questions

Is there a basic script to check if a database file in a IDEA server project exists? And is there a script to check if a field in a database exists?
At the moment i'am scripting for IDEA server projects and if i want to automate scripts there can't be any popup boxes or message boxes in the script but this leads to a world of problems. Anyone with any experience in scripting on IDEA server projects and automate scripts?

Hi Brian,
I have a project that I am working on and wanted to use scripting to do it:
I am performing analysis on a customer transactions database that has deposits that change to a base currency after 30 days if not utilized.
Customer deposits (identified as credits 'C') are utilized according to the order they arrive in, granted they are still within the 30-day limit from the date of deposit.
The idea is to check at the end of a specified date, how much is still viable for use and how much has been converted to a base currency

Hi everybody,
i want to put several IDEA scripts together,  that at the end only with one click i can run all those IDEA scripts. But unfortunately it doesn't work in that way i am trying it:
Sub StartMyScript()
Call FCH()
Call FGL()
End Sub
 
I receive at the second rwo the error message " Sub or Function have been not defined: FCH"
Do you know, if there is another way to do that resp. how can i solve it?
Thanks and regardd, FMLA

Hi all,
I'm writing a script appending new Standardize fields in all projects. Is there any way to let users choose the fields manually from a dropdown list to make the formula for these Standardize fields? 
 
E.g: In the picture attached, users need to choose the correct fields manually (Users or Users_2) to append createdBy field which is a standardize field. The name of standardize fields remain unchanged among projects.
 

Hi again,
I'm runing a script that involves importing an excel spreadsheet and then multiple pdfs, which are all joined in turn to the spreadsheet.
To eliminate error, I'd first list to read the data from a specific field in the excel file (trader ID) and from a specific field in the first pdf import (trader ID) to ensure that the matching keys are there.
The Trader ID will remain constant, i.e. it will be the same in every cell in the file.

I have in my database a caracter's field wich contains sometines quotes.
exemple : JOURNAL DES "A NOUVEAUX"
I'm trying to replace or delate quote " by the following function but it doesn't work :
    Set db = Client.OpenDatabase(DBNAME)
    Set task = db.TableManagement
    Set field = db.TableDef.NewField
    field.Name = "JOURLIB2"
    field.Description = ""
    field.Type = WI_VIRT_CHAR

Hi,
I would like to know if it's possible to protect a script with a password ?
I don't want the users modify the script.
Thank you
Ben

Is it possible to import delimited text files without an RDF? 
 
I believe that is what Mohamed was doing here using RDFCREATORLib, but I can't get it to work in IDEA script.
 
https://www.ideascripting.com/forum/issue-importing-date-field-text-file
 
Thanks
Scott

Hi there.
I have to export many information to excel for some users but i have to wait for them to confirm whent to do it. They don't have database users so I was thinking to create some sort of configuration file where I do write my credentials and let them execute my script to import data...I know it's to much to ask encrypting-decrypting function to retrieve authetication info, but I'm expecting to be able of retrieving user and password.
Any advice?

Hi Brian,
I'm sure somebody might have asked you the question.
I'm coming back to idea scripting after three years and almost forgot all the tips and tricks.
Previously i have created many macros with list box but not rememebr facing this issue.
I'm getting internal error for the below example. I have defined the array for list box seperately but still facing issue. I'm using idea 10 version. Do you see something that i'm missing? I have a 3000 line code having this problem. so, just created an example with simple list box.
code: