IDEAScript Questions

Hi Brian, is there a way to add text into an existing blank field, using a script. I've seen some scripts to fill down a column with the contents from the previous field, but i need to add new text to the blank fields.
 
For example, i have a database with various columns and 1000 records. In column X, 500 fields allready has text Q1, the other 500 fields are blank. In these blank fields I want to add Q2.
 
Thanks, Mike

My name is Lucas and I'm from Argentina, I really like your blog.
 
I have a query, I'm doing a "macro" for IDEA with visual basic, where from a base I take a field that has a date in string format I convert it to date. Then I want the user to enter a date with which to compare that data previously obtained, in order to have the base already filtered.
 
Sorry for my english.
 
I have made the following script:
 
' File - Import Assistant: Delimited Text
 
Function Test
dbName = "E070.IMD"

Hey everyone,
 

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