Audimation Services has been acquired by CaseWare International Learn More.

X
Icon


Let IDEA Liberate You with the Updated Utilities App!


Oct 2020, shortly after the release of IDEA 11.2 – CaseWare posted a new SmartAnalyzer app to Passport, CWI Utilities. The Utilities app offered a bundle of 13 smart utilities for performing common audit tasks in a faster, easier way. Bundling some of the most used macros from the IDEA Script Vault into a single app helped to boost user productivity by increasing efficiency.

Now, they’re back with 6 additional utilities!

Description

The CWI Utilities App is a series of 19 useful scripts bundled together in a single SmartAnalyzer application. These utilities have been requested by auditors in order to perform many common tasks easily. Contained in this package are scripts that will provide the following functionality:

  • Accumulated Total
  • Add FILENAME Field to All Project Databases
  • Add Status Fields
  • Append Prefix or Suffix to Field Names
  • Copy Field Names
  • Cross Join **
  • Date Creation Database
  • Export Multiple Databases
  • Export Multiple Databases to a Single Excel File **
  • Fill Empty Cells
  • Generate Audit Numbers Indexed by Date
  • Identify Empty/Repetitive Data Fields
  • Join and Compare Fields
  • Multi-File Import **
  • Remove Extra Carriage Returns **
  • Replace Illegal Ampersand Characters **
  • Sequential Numbering **
  • Split Text File
  • Text Delimited Export Without Quotes

To learn more, review the Usage Documentation or check out the Utilities v1 Datasheet.

** Added July 2021

64-Bit IDEA v11.1 or later required


Best Practices , Tech Tip



Posted By

By Kris Willison
Kris joined the Professional Services team in January of 2015 as a Solutions Specialist. She has an extensive background in Software and Database Development accumulated from thirty years in IT support with twenty years’ experience in database development, cleanup, audit and migration using Microsoft Access. In her time with Audimation, she has received client praise for her “Top Tier” engagement on Monitor and Scripting projects. Kris enjoys looking at problems from new angles to determine the most efficient means of meeting the clients’ needs. Kris has been breeding/showing purebred Balinese cats since 1972 and Oriental Longhairs since 1996. She also hosts one of the largest online pedigree database sites for Siamese and related breeds with nearly 600 users worldwide.


Related Posts
Infusing Python into Your Analysis with IDEA
Oct 06 The tech community often refers to Python as the official programming language for non-programmers. It’s free and easy to learn (even if you don’t know wher...
Improving Critical Thinking Through Data Analysis
Jul 27 Originally published in the June 2017 issue of Strategic Finance. Written by Kurt Reding, Wichita State University, & Carolyn Newman, Audimation Services ...
Tech Tip: Filling Empty Cells
Oct 23 Importing data that is not formatted correctly can drain hours of your analysis time. An IDEA user was working with general ledger detail that required an accou...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×