IDEAScript Questions

Hi,
i need a snippet to create a preview of an extraction. IdeaScript only records the complete macro an creates a new file.
I hope somebody can help me...
 
Gerold Mammen

I'm very new to scripting, and I'm struggling a bit with understanding how to properly use dialog boxes. What I'd like to do is pop up a dialog box to have the user map the fields in their client's data to a standard naming convention, so that I can run a pre-designed analysis. I've been successful at building the script to handle the analysis part by using the macro recorder and the history, but I'm stumped on the dialog box part. 
 

Hi Brian! 
I hope all is well with you!
I was wondering if you could help me.....

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