I've been using your script to append multiple files in one pass which changes all the fields to character. But there is one small glitch, rather than just appending the databases selected, it ends up opening all the databses in the project folder directory and appends all of them together.
I have tried & tested it extensively, from my experience if there are around 10 files with no virtaulf fields it works fine, otherwise it just appends all the databases in the directory togther.
The only solution to this problem is that if i copy paste all my databases to append in a new folder within the project folder, then it just appends them. But I'm trying to make an application in IDEA where the user imports the files, they are appended and then he maps it to the pre-defined columns in the logic i have created for multiple KPIs/checks. Post that the user selects the KPIs to be run and runs them. I have stiched together/written all of the code now. But due to this error in the append script here, the consolidated database sometimes created is invalid.
Would request you to please look into this append script on this page if you can, will greatly help me if you can solve this glitch so the script just appends the databases we have selected and not all the databses.
this is the script in question
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories