IDEAScript Questions
Array Reporting
Forums
I have created a script that runs around various files and generates stats from the files. Right now it is writing the results to an array. Is there a way to have the array output into a new IMD file? Or would it be best to write to an excel file?
Thanks
- Read more about Array Reporting
- 1 comment
- Log in or register to post comments
FileOpen
Forums
HI, All,
Is there a way to set the default file browsing location for the FileOpen common dialog?
It seems to remember where it last pointed, but where is that pointer stored?
Rob
- Read more about FileOpen
- 9 comments
- Log in or register to post comments
Dealing with errors caused by external script
Forums
Hi,
I have a master script that calls smaller scripts using Client.RunIDEAScriptEx. Every now and then (and more often than I'd like), something has changed which causes one of the scripts to fail - often it is something to do with the source data, but not always.
How to write to the IDEA Status Bar?
Forums
I would like to visually inform the user as to what the script is working on. Like, "Processing records for VENDOR Ace Hardware", followed by "processing records for VENDOR Home Depot", "processing records for VENDOR Lowes", etc. This would update over time as the system was doing different things, but require no user intervention. A progress bar is not specific enough for what I need to convey, i.e. vendor name.
So, anyone have a way to write to the IDEA status bar?
- Read more about How to write to the IDEA Status Bar?
- 11 comments
- Log in or register to post comments
Check to see if a database exists in a project
Forums
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
Create a new database including a concatenate field from several recors in other table
Forums
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.
Project overview and history
Forums
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?
- Read more about Project overview and history
- 5 comments
- Log in or register to post comments
Find IDEA version number from script
Forums
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.
- Read more about Find IDEA version number from script
- 5 comments
- Log in or register to post comments
Introduction
Forums
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!
- Read more about Introduction
- 10 comments
- Log in or register to post comments
List of Sub-Folders
Forums
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
- Read more about List of Sub-Folders
- 3 comments
- Log in or register to post comments