IDEAScript Questions
Error Handler by Function
Forums
Hello,
I've written a set of functions within a single script that completes various tasks. Each function has its own error handler with the intention of logging which function the error occurred so I can quickly isolate a potential problem to one single function. However, during my testing I've noted that when an error occurs in one of the functions it calls the error handler in all of them. Is there a way to fix this or perhaps build a single error handler for the whole script that will log from which function the error originates.
- Read more about Error Handler by Function
- 2 comments
- Log in or register to post comments
Extract only the rows, which have a defined symbol in "cell"
Forums
Hello, I was an Excel user before, but have started to work with IDEA for a while. First of all sorry if will use such definitions as "cells" etc. I have a database, it looks like
UserName | bla | bla2| bla 3| .....
Superman | 1 | 2 | 3 | .....
Hyperm_n | 4 | 5 | 6 | .....
Delete Database
Forums
Hello,
I'm having a little problem when trying to delete a database using Script. Everytime the code run it gives me an error saying: "Unable to delete." Not sure why that is, so any help would be great.
Code I have is:
Client.DeleteDatabase("SumbyJrnl.IMD")
- Read more about Delete Database
- 1 comment
- Log in or register to post comments
Close all databases
Forums
Hello,
Part of a script I am working on includes a direct extraction. I want to close both the original database and the extraction database once the extraction is complete. I added Close but that only closes the extraction database (script attached). I also tried Close All but obtained the same result. My apologies if this answer exists somewhere on your site already. I tried several searches and wasn't able to find it. Thank you very much!
Holly
- Read more about Close all databases
- 2 comments
- Log in or register to post comments
Table Preview by Scripting
Forums
Is it possible to generate a table preview window by idea script?
- Read more about Table Preview by Scripting
- 7 comments
- Log in or register to post comments
Macro that will import new files monthly
Forums
Hi,
I am fairly new to IDEA script, and I am trying to modify a macro so that it will import two new files monthly that we receive from another department. The file names are the same except for the date at the end which is why I have tried using an input box that you can see in part of my script attached. I am getting many syntax errors and am having trouble working around them. Is there a better way to go about this?
- Read more about Macro that will import new files monthly
- 17 comments
- Log in or register to post comments
Pivot table - How to add filter
Forums
Hello everyone,My file contains the number of tickets sold, the ticket price, type of payment, type of transaction, type of ticket and the date of the transaction.Using IDEAScript, I would like to produce 6 different tables showing the number of tickets and the enti
- Read more about Pivot table - How to add filter
- 1 comment
- Log in or register to post comments
Split tables according to a field value
Forums
Hi all :)
I have a table "TableOne" that contains n fields. In field "Fieldn" there are codes like C1, C2, C3 etc.
I would like to be able to split tables: TableOne_C1, TableOne_C2, and so on.
Basically like: on every change in the column X create an extract with the new value as table-suffix.
Any suggestions?
regards from Berlin
- Read more about Split tables according to a field value
- 6 comments
- Log in or register to post comments
Wrap character fields using script
Forums
Hi,
There is an option to wrap character fields under View. User has to select a column and click on this option to enable it.
I have to show a description field in my output file which is generated through idea script.
Width of this column is 200 and there are some other columns. While opening the output file, user will not be able to see other columns without moving scroll bar as the width of the column is high. Is there any way to wrap text of this column programmatically?
Thanks,
Shafeer
- Read more about Wrap character fields using script
- 3 comments
- Log in or register to post comments
Kill / Terminate / Quit complete script
Forums
Hey,
I want to put a statement into my errorhandler which terminates the complete script.
Is there such an easy statement?
Kind regards
David
- Read more about Kill / Terminate / Quit complete script
- 7 comments
- Log in or register to post comments