IDEAScript Questions

Hi,
 
I'm writing a scriptlet to add a column to an IDEA database. I'd like to make sure the database exists before I try to add the field to it!
I don't see a way to test for the existance of the database as part of a project.
I'm new to IDEA, so this may be an obvious question, so I apologise in advance!
Thanks for your help! 
 
Rob
 
 
 
 

Dear all,
I have a test that I would like to do in IDEA, yet I bought the book Mastering IDEAScript and searched in the Help motor of idea and I have no clue how to execute this script. I tought someone might help me here. My requirement is described in the picture below.
 

Hi 
This is my first post -I have looked around on the internet for some idea solutions and came across this website, which really is quite helpful!
I was wondering whether you could help.  With v9  the project overview is saved as an .sdf File.  is there a way to read in the sdf file into idea at all, or alternatively (or additionally) is it possible to create an idea script to run through and extract the history from all databases in the current project instead? 

Just wondering if it's possible to find the IDEA version number from within a script.  Our organisation is running IDEA 8.5 generally but have IDEA 9.1 on some computers and will be migrating there sometime in the future for the rest.

Hi,
 
I am an business controller, not a programmer,- so forgive me this question -  but I feel the use of idea will have more strength using dialogue boxes.
the video on dialogue boxes expects a general/ basic understanding of writing code.
 
What would be a good starting point to get this understanding?
 
thanks!
 
 

I am using the getFolder function, and now I want to write the list of sub directory's to an array.
Does anyone know of a simple way of doing this?
Reason for the script... I receave 18 seperate files per day, which I save in a directory by the day (e.g. Jan 1). I would like to tell IDEA to look in the Jan 1 folder, then write all the sub-directories to an array. I would then use that array as part of the script to import the files, and the append them all together.
Any assistance is appreciated
Edward

I am new to scripting and have a few questions:
1. If I create a script based on a specific file and later want to run that script on another file, how do I do it without having to go into the script and modify the file? Is there a way to create a script not based on a specific file but just the open file in IDEA?
2. I have criteria to enter into a script but have been told it isn't possible. Is it possible to enter criteria/formula into the script?
Thanks for your help.

When importing an Excel spreadsheet using in V9 is there anyway of not assigning the sheet name (first sheet always being imported from the spreadsheet) to the imported database name i.e. spreadsheet name= Prefix, sheet name= x. Normal database name imported =Prefix-x but would just like to have the database output to be named as Prefix. 

Dear Brian,
apologies for the subject  but it is Friday. I was wondering if you have any tips or a script on how to run median absolute deviation (MAD). I refer to chapter 6 of Nigrini's book and I find the MAD concept quite interesting. I have tried to use  the formula using normal functions but it gets messy. Any tips?
cheers
 
Stefano 

Hi,
I am creating a new ribbon under Smart Analyzer. Please see the image.  I am unable to set image for the 'Banking Procedures' like that for Data Request, Tagging etc. Please advice.
Thanks,
Shafeer