General discussion

I just added a series of 11 videos on my YouTube channel that walk you through creating a dialog in IDEAScript.  All the total time for the 11 videos is about two hours.  The vidoes cover the following:

CaseWare has updated their OUtliers Detection utility.  You can get the update from the IDEA lab (http://ideascripting.com/IDEA_Lab/idea-lab-home-page).

Hello All
 
Thanks Brian for this helpful site, it has really helped me a lot of times!
 
I would like to ask you the following:   I have a set of scripts that I run monthly in diferent projects, of course I do not copy the scripts to every project, but I run them from a specific folder. 

- deleted because the problem was solved. One of the imported variables crashed IDEA every time.
Anyway I want to thank you, Brian for setting up this site. It helped me out a lot. Please keep it up.

Good afternoon, Brian. I am a forensic accountant with a large CPA firm. I have been given IDEA as a tool for use in an investigation that involves 10s of thousands of documents. This matter will be going to court, and I would like to be able to pull various PDF documents up on a screen as necessary in the evidence phase. Is IDEA able to embed PDF files so that they can be accessed in their original condition and called up on the screen? If not, what complementary application would be required to accomplish this? My compliments on the quality of your site.

This script will allow you to add a prefix or a suffix to all your field names.  This is great when performing a join or Visual Connector and don't want the entire file name to be included.

http://ideascripting.com/ideascript/add-prefix-suffix-field-names

Hi Brian,
I want append a column name with its tagged field name. But while am appending this through script. Its appending with each row value.
eg: if tagged field name is "CF". Then I need to append a new column with "CF". 

This script will add a total field to the file and you can either create a running total on the entire file or on a combination of up to 8 different fields.

http://ideascripting.com/ideascript/add-totals-column

Just added a new script.  This one will be handy when you are performing appends.  The script will compare the primary file with all the append files and generate a report of any append fields in the that are different from the primary file but with the same file name.  These will need to be changed before the append can be run successfully.

http://ideascripting.com/ideascript/append-file-report

Nice article about using IDEA date functions for fraud investigations.

https://www.themis-analyticstraining.com/idea-date-functions/