IDEAScript Questions

Hi Brian,
While doing a Join to get a field from another database, a new database gets created. So there are multiple steps invovled in scripting due to this since i have to then delete the original database and then rename etc.
Is there a way to add a field to the existing database itself without creating a new database? Can i do this through script or custom function?
 
Regards
Padma

Hi Brian,
 
Can you maybe help me with this script? In order to prevent a script crashing because of varying field names, I would like to create a script that runs based on pre-identified field names that the user selects with dropdown listboxes. I managed to steal some from the scripts you placed on this site, but I'm stuck after the first listbox. 
 

hi bryan,

I have scripts that compare an active employee list with an access list from various systems.  For example AD.  At the end of the day, I end up with two tables.  One that shows people who have access to the system that are active employees and another one that shows accounts that don't belong to active employees.  The two tables then get exported to Excel.  The goal is to have nothing in the inactive employee listing. 
 

Hello, we are currently utilizing IDEA 10. We run various functions for client data on things such as disbursements, A/R, and General Ledgers. These usually come in a variety of formats, which we import and write the various functions for. Is there a way to write a script to automate this process, much like the smart apps (which aren't currently an option for us).

Hi,
 
I have loaded in a large amount of data into a mySQL database that I would like to also query from IDEA. I am new to IDEAScripting and would therefore like some assistance on how I could write an IDEAScript that will connect to the mySQL database and import all the tables into IDEA. Any suggestions?
 
 
Many thanks,
 
M

Hello ! 
I would like to know if there is a script which can put in a database all the "field manipulation" information : Field name, Type , Length, Parameter, Description 
I would like to do this in order to compare field information especially when I need to make a join or append. 
I am sorry if it has already been done, but I didn't find anything on this in the forum.
Many thanks for your help,
Best regards,
MagiBzh

Dear All,
 
Currently i am making a script that is supposed to extract all cash transactions in excess of 15K. The data that i use is an auditfile(.adf). This is a database with all the journal entries of a financial administration. 
 

Hello, 
So I have this script that I've used countless times. I made a copy of it and within the copy made a few changes to the code to add some additional options. The issue is that when I run this new script it will sometimes run the entire script as it is supposed to perfectly, but then sometimes it just closes midway through. I've stepped through the program using the script editor and it works perfectly. I can't figure out why its closing early. 

Hello!
 
I found this code:
 
 
    For i = 0 To x   
 
           ' Set-up the XML import task
     Set task = Client.GetImportTask("ImportXML")
     task.InputFileName = picked_folder & "\" &  listbox2$(i)