IDEAScripts

Zap ConsultingData analytics can test 100% of data to detect suspicious transactions for further investigation. Data analytics can also be used to examine, collate, and quantify transactions once an audit target area have been identified. GEL-1 is an example of an IDEAScript available on this website that can help to determine an audit target. Whistle-blowing and tips hotlines also provides high value areas to review and investigate. It is important for all organizations to have open communications and transparency with information that can be gathered to help narrow the search for the data analytical analyst.  One such service is Integrity Hotline™ (http://zapconsulting.ca/en-GB/integrityhotline) where they strive to provide organizations and their communities with a professional, anonymous, transparent, reporting mechanism to aid in the integrity of their business operations, detour financial frauds, while encouraging the organization’s community confidence and minimizing toxicity in the business environment. Integrity Hotline™ assists organizations in achieving positive corporate governance, with fairness, transparency and professionalism.

Template

Background: 

This is a template for starting out your scripts.

Add Comment to IDEA database

Background: 

This script gives an alternative way to add comments to your database whil

Add Filename

Background: 

This short script will add a filename field with the filename of the open file.  A second script has been included that now allows you to do multiple files at the same time.

Word Parser

Background: 

Script to take the words from within a column of a file and parse them to

Add Counting Column

Background: 

This script will add a new column that will count the number of records based on a field that is selected by the user.

Fill Down Utility

Background: 

This script will allow you to fill empty cells within a database from information contained in the previous cell.

Mine Sweeper

Background: 

Try the well know Mine Sweeper game through IDEAscript.

Sudoku

Background: 

Sudoku game for IDEA through IDEAScript.

Copy Header Info

Background: 

The script will copy the header info from one file to another file.  This can be used when importing an excel file in which the data is over several tabs but the header info is only on the first tab.  The script will take the header info from the first and copy it to the second file.

The script was updated on March 17, 2016.  It now has an option to copy the old header name to the field description so that information is not lost.

Export Delimited File

Background: 

This script gives additional options for anyone wishing to export an IDEA file in a delimited format.

2015-08-15 - Updated the script so that the if you user select to include field names that they are separated by the selected field separator and not the ",".  Also added code to format numbers, it seems that if you had a number like 12.10 it would be stored in the text file as 12.1, this has been fixed.

Pages