IDEAScript Questions

Hi all
I've had a look at the script here to get an idea of how to hold multiple fields in an array
https://ideascripting.com/snippet/array-hold-all-field-information
 
Tried adapting it to my own script, attached (quite new to this so sorry if my script is hideous)
note I've trimmed out some of the stuff from my script like menus/functions that aren't applicable to this question
 

Hi Brian,
 
I hope you are well.
 
I'm running a macro that creates an excel output file.
 
If the macro has been run previously, and the user has that excel output file open, the macro will crash when it tries to export.
 
To avoid this, I would like to use my script to check if any previously exported excel file is open.
 

Hi everybody,
 
I have table A with columns "CustomerNo.", "Period" and "Amount" that has ~ 5M records.I need to calculate a rolling total over a period of 12 months before "Period".
Problem is that I don't have one record per Customer per Period, but I am missing months for most customers.
Is there a smart way of joining the data in IDEA to create the missing records and let me calculate the Rolling Total (https://www.ideascripting.com/forum/running-total)

Hi together,
I have the following problem:
In Germany we use IDEA11 with the SmatrAnalyzer. Included is the main module "Auswahl und Durchführung von Prüfungsschritten" where You have several audit routines, which are tagged with special IDEA-Tables (especially "Standardjournal" = GeneralLedgerDetails).
 
Is there a possibility to tag a new table via IDEA Script as file that has all fields, necessary for a "GeneralLedgerDetails"-file?
 
Thanks
Martin

I wrote a function that iterates through a database and returns true if a string is found and false if it is not found.
 I inserted the string into code as indicated below to apply an eqn to a field.
 
If StringExists("PayElements-SpecialPay","ELEMENT",rec.GetCharValue("ELEMENT_NAME")) field.Equation = "XXXXXX"Elsefield.Equation = "YYYYYY"End If

Hi,
I would like once the name of the field defined in the dialog box that is attached to a variable that will change the name of the field.
Thanks for the help
 

Hello guys, I´m struggeling with my current project.
I wrote serveral Subs in my script and have to activate or deactivate them by setting a comme symbol like this one " ' " informt of their reference in Main. Now I wonder, if it is possible to open an dialog box at the beginning of the macro, with check boxes an select the wanted/needed Subs, so i dont have so addapt the script every time or have alls Subs running at one time.
Thanks a lot for any help and suggestions
Maurice
 
 

Hi Brian,
 
It's been quite a while since I've had a question and I hope all has been well with you and yours over the last couple of crazy years.
 
I'm currently working on a script and I have a question on using visual connector.
 
My script is joining several files to a primary file using visual connector and it's working.
 
However, I am using task.IncludeAllfields which is giving me a lot of unnecessary columns in my output file.

Hello, has anyone, please, been dealt with this issue? I am preparing a macro to be able to compare 2 databases which includes names of persons, and find the matches. There can be several gaps in the names and the individual words can be in different order in the databases.  Therefore I need to create in each database a common field for the comparison – a name field with individual words sorted alphabetically.
Preparing one of the databases for comparison:
Default state:

Im trying to create a new column   ("FILE ID")    that contains a value from another one. I want this value to be repeated by "Codigo". Everytime "Codigo" changes, The "FILE ID" column must have the new FILE ID. This value can be repeated, and "Codigo" can be repeated too.