General discussion

Hi there,
I am new to IDEA and IDEA scripting.  I have a fairly extensive background though with using ACL and scripting in ACL.  I was wondering if there advice that you could give me on some approaches to help me get up to speed with learning how to script in IDEA and also the differences and comparisons between scripting in IDEA and ACL.
One of my first observations is it does seem like the script code for IDEA is longer than what is required in ACL for doing similar tasks.
Any advice, tips or assistance will be greatly appreciated.

Hello
I need to join 2 databases where the first has a date and the second has a period. The joining has to be done where the date of the first database is within the period of the second database.
So: database 1 has date 1 oct 2015, database 2 has 2 dates, date_from 5 jul 2015 and date_to 15 dec 2015 then the join is ok.
Has anyone any idea how to solve this in Idea, version 8 or 9?
Thanks !
Wim

I just noticed this morning that Caseware Analytics have a new white paper entitled: Driving Better Data Analysis: Moving Beyond Spreadsheets, it compares using a spreadsheet with using IDEA.  Good read for anyone wondering why they would use IDEA instead of Excel.  (http://www.casewareanalytics.com/sites/default/files/whitepapers/caseware_analytics_driving_better_data_analysis_web.pdf)

Hi, If my post has not its place in here, I will remove it. I would like to be advised on the computer characteristics essential for Idea software. Indeed, I have the possibility to change my work PC soon the which has 8 GB of RAM. We have now millions of data to analyze, and my portable PC takes a lot of time to execute one task. And it kind of became monotask...Could you tell me which characteristics need to be optimized for IDEA software ? -Memory RAM ?   -Processor ? -Type of hardrive ? -Portable computer or desktop computer ?

Hi Brian
I have an annoying issue. In the file explorer one can see the name of the database, the number of records, size, date modified and date created.
 
Several times in the past I suddenly got a huge size for the name of the database field and I had to scroll quite a lot to the right to see the other fields. Needless to say that I could not find a way to shrink back the size of this very large field (in normal situation you can set the size of each field easily).

I am looking at automating scripts using 'Task Schedular" (Windows 7). I can get the script to open, but not run.
Can anyone help me out?
 
Regards
 
John

I have a problem copy selected range of cells from one excel workbook to another using IDEA
The following code sometimes works and sometimes does not. I cannot figure out what is wrong anf how to fix it.
BTW - Using seperate set of source and destination workbook and worksheet objects did not help.
 
any suggestion how to correct the code will be greatly appreciated. THANK YOU
 
Dim ex As Object 'Excel object
Dim wb As Object  'Excel Workbook
Dim ws As Object  'Excel Worksheet

Hi,I am relatively new to IDEAScripting and am having trouble extracting databases using "Start" and "End" dates which the user has input through a Dialog box. The user inputs MM/DD/YYYY as a string in a textbox and then I wanted to perform a database extraction with the "Transaction Date" being greater than the starting date and less than the ending dates.

After over a year I finally wrote a new blog post.  I need time to do more of these.  So this blog is about how to localize your script.  I would enjoy any comments you might have it.  You can find the link on the front page.

This slideshow shows the differences between using Excel and a Data Analytics Tool like IDEA.

https://www.slideshare.net/slideshow/embed_code/48485593