Skip to main content

IDEAScript Questions

How to export history from databases using IDEA script?

Hi All,
I completed a few group projects via using IDEA macro, while I need to export the history, PDF version, from databases manaually for documentation purposes.
I read Language Browser for help, and it seems no introduction on that is about history export.
How could I get the history from databases automatically rather than manaually exporting them one by one?
Seeking for your advice.
Regards
 

Dialog Box to Map Fields

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. 
 

Adding fields from another database without creating a new table

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

Userform with dropdown listboxes

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. 
 

Error Handling and Empty Tables

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.