IDEAScript Questions

Hello everyone,
 
For some stupid reasons I need to be able to copy a database from the IDEA Server to a local IDEA project. However I cannot find any informatie on how to do this and the IDEAScript helper is useless. I am looking for a bit of code expecting something like task.CopyDatabase("database name", "Destination folder") a bit like the task.MoveDatabase command but I need it to be a copy and it has to be from the server towards a local project. Please help me out!
 
With Kind Regards
Ivo
 

Good afternoon Brian,
Love the website, thanks for your dedication to it. I am trying to utilize a variable that I created from the Field Statistics to  count the number of records. However when I put the variable in the Field.Equation line, I recieve a "0" instead of the number of records. The first attachment is the script piece, the second attachment is the results in the databas, where there are "0"s I was expecting the Recordnumber count from the variable RecordCounterResult.
 
Additional Info:

At the moment i'am using the On Error Resume a lot, but is it possible when the err.number is not equal to 0 that a text line is exported to a txt file? That way i can create a log. Because with the automate of IDEA server scripts i can't use msgboxes anymore.

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