Search Results for: acl

ACL Table Already Open error message

Oh, I hate the Table Already Open ACL error message with a passion. And the Command Cancelled message (see the end of this post regarding that message). Usually, it means I did something stupid, and I can figure out what, … Continue reading

2 Comments

Filed under ACL, Audit, Data Analytics, How to...

My Favorite ACL Tricks

Here’s a couple of my favorite ACL tricks & treats that I use frequently to get me through the day a little faster and a little less frustrated. These tricks are the kind that they don’t teach you in class … Continue reading

5 Comments

Filed under ACL, Audit, Data Analytics, Free, How to..., Scripting (ACL)

Another Nail in ACL’s Coffin

Diligent’s acquisition of Galvanize (ACL) is another nail in the ACL analytics coffin. First, ACL acquired another company and created Galvanize. And we were told governance, risk, and compliance (GRC) would never be the same. And I told you that … Continue reading

25 Comments

Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology, Written by Skyyler

Is ACL Analytics Dying?

I fear that ACL Analytics is dying, and has been as long as I’ve been ranting about it. Making Laurie Schultz their CEO helped, but I don’t think it has been enough. NOTE: I wrote this well over a month … Continue reading

20 Comments

Filed under ACL, Audit, Data Analytics, Written by Skyyler

ACL Officially Changes Name & Spots

It’s official: ACL is changing its name AND its spots. I’ve claimed several times that ACL has left its first love (analytics) and doesn’t put enough work into their flagship product, ACL Analytics. Correction: their FORMER flagship product. At least … Continue reading

10 Comments

Filed under ACL, Data Analytics, Excel, Technology, Written by Skyyler

ACL Desktop Gone in 5 Years?

Rumors have it that ACL will no longer be available on the desktop (laptop, or other local machine) in 5 years. That is, according to an ACL user who attended the 2018 ACL Connections conference.

3 Comments

Filed under ACL, Audit, Data Analytics, Scripting (ACL), Written by Skyyler

ACL Robotics is NOT Robotics

ACL ‘robotics’ is ACL scripts dressed up in formal clothes with a designer label. It is NOT robotics. Continue reading

4 Comments

Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology

ACL Tip: Be Careful when Renaming Tables

Renaming an ACL can cause problems if you don’t also rename the .fil data file associated with the table. Continue reading

Leave a comment

Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL)

5 Things We Need from ACL in 2018

Here’s the 5 things I’m hoping will change in 2018 regarding ACL. They are all related to each other and feed off each other… Interesting.

9 Comments

Filed under ACL, Audit, Data Analytics, Excel, Scripting (ACL), Technology, Written by Skyyler

Quick Introduction to ACL

If you’ve ever wondered what Audit Command Language (ACL) is, here’s a quick way to find out. ACL has provided a quick, one-page introduction to ACL. And I mean quick. It doesn’t explain a lot, but it gives you a … Continue reading

3 Comments

Filed under ACL, Audit, Data Analytics, Technology

Deleting ACL Table Covers A Multitude of Sins

I’m not sure why, but sometimes deleting an ACL table or two covers a multitude of sins, errors, or just plain weird behavior. No, I don’t get any error messages. That’s the strange part. I’m talking about strange ACL behavior … Continue reading

2 Comments

Filed under ACL, How to..., Scripting (ACL)

Robotics to Replace ACL, Part 2

Previously I wrote Will Robotics (RPA) Replace ACL? The short answer is no, and I describe the reasons in that post. But that doesn’t mean someone won’t try. Shortly after I wrote my original robotics post, I encountered robotics vs. ACL, … Continue reading

2 Comments

Filed under ACL, Audit, Scripting (ACL), Technology

ACL Import Fails, No Error?

Today I was adding a new table to a scripted ACL project and kept getting an error. This project automatically opens a folder on the LAN, reads the files in the folder, and loads all of them. All I did … Continue reading

1 Comment

Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology

How to Review Your ACL Log

Whether you script your projects or use menu commands, you need to review your ACL log carefully. Good analysts review their results and the log as they work in ACL, after they think they are done, and have others review … Continue reading

3 Comments

Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

Why You Should Run ACL in a Virtual Machine

Running the desktop version of ACL in a virtual machine* (VM) has so many advantages, but I haven’t heard anyone else doing it. Consider the following advantages, listed in order of importance (to me):

11 Comments

Filed under ACL, Audit, Data Analytics, Technology

ACL: Automate Active Directory Downloads

Here’s a way to automate the download of data from Active Directory (AD), specifically group members, into ACL using adfind and the ACL Execute command. I’ll walk you through it step-by-step. This was posted before ACL released their own Active … Continue reading

2 Comments

Filed under ACL, Audit, How to..., Scripting (ACL), Technology, Written by Skyyler

Review of ACL Excel Add-in, Now FREE! (NOT)

What a joke! Continue reading

4 Comments

Filed under ACL, Audit, Data Analytics, Excel, Free, Free Download

ACL Tip: Beware of ORs and ANDs

Whenever you use OR and AND operators in ACL (or other software, for that matter), be careful to ensure that you receive the results that you are looking for. Assume you have Table1, which contains 100 loan transactions. 10 of … Continue reading

Leave a comment

Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

ACL Error: Not all Fields Imported via Script

Recently, I  ran an import script to import a delimited file into ACL, but the last 10 fields were not imported. And I didn’t know it right away, because I received no error message. In addition (or should I say, … Continue reading

4 Comments

Filed under ACL, Scripting (ACL), Written by Skyyler

You Might be an ACL Freak if…

You might be an Audit Command Language (ACL) freak if more than 2 of the following are true: At work, you have a second computer (or virtual machine) just for running ACL.

1 Comment

Filed under ACL, Audit, Data Analytics, Scripting (ACL), Top 10, Written by Skyyler

Great Training at the 2014 ACL Conference

If you have ever wanted to go to an ACL conference, this is the year to do it.

1 Comment

Filed under ACL, Written by Skyyler

Teach Yourself ACL UPDATED

If you’re trying to learn ACL on your own, Teach Yourself ACL, the widest read post on this blog, has been updated. ACL revised their website, which broke many of the links. Those are now fixed. Until ACL does the … Continue reading

Leave a comment

Filed under ACL, Written by Skyyler

ACL: How to Add a Conditional Computed Field

In ACL, a conditional computed field (CCF), is basically a regular computed field with some fireworks. It looks and acts much like a regular computed field, but has some extra parts that do some extra work. Fortunately, the extras are NOT complicated, and after … Continue reading

2 Comments

Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

5 Things I Hate About ACL

I have 5 things I really hate about ACL.  No, these aren’t critical issues, but I deal with them constantly, and they waste my time. All of them deal with the user interface.

11 Comments

Filed under ACL, Audit, Data Analytics, Technology, Top 10, Written by Skyyler

ACL Error: Cannot Export to Excel

Next time you get the cannot perform export to Excel error in ACL, try one of the 3 solutions described below.  The full text of the error is:  Cannot perform the export. You can export fields with maximum of 254 characters … Continue reading

1 Comment

Filed under ACL, Audit, Data Analytics, Excel, How to..., Written by Skyyler

Can Skyyler Not Write About ACL?

If you’re new to the blog in 2013, you might think that Skyyler is only an ACL gear-head. But he DOES write about non-ACL topics. Occasionally.

3 Comments

Filed under Written by Skyyler

ACL: How to Add Computed Fields via Script

Once you’ve mastered creating computed fields, you’re ready to add computed fields to a table via script. It is easier than it sounds. If you need some background on computed fields, see my previous posts, What is a Computed Field? … Continue reading

6 Comments

Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

ACL: Edit Scripts Easily

As soon as you create an ACL script, you often have to add to it or edit it. There’s an easy way to do it.

6 Comments

Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

ACL: How to Create Your Own Scripts

Creating scripts (and editing them) is not as hard as many of you believe them to be. Sure, it takes practice and time to learn the basics, but YOU can do it. If you don’t learn scripting, you are NOT … Continue reading

5 Comments

Filed under ACL, Data Analytics, Free, Free Download, Scripting (ACL), Written by Skyyler

Optimize ACL Scripts

Have you been following the “Optimizing Script Performance” series on the ACL Blog? aclkevin has been offering some great tips. In case you missed them:

Leave a comment

Filed under ACL, Data Analytics, Scripting (ACL), Written by Skyyler

ACL: Add a Custom View to a Table

Adding a custom view to an ACL table comes in handy when you want to 1) change the order of the fields in an ACL table, or 2) view a select number of fields. You can add a custom view … Continue reading

4 Comments

Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

ACL: How to Add a Computed Field

If you’ve been wondering how to add a computed field to an existing ACL table, you’re at the right place. I’ll take you through it step-by-step. In ACL tip: What is a Computed Field?, I defined computed fields and provided … Continue reading

18 Comments

Filed under ACL, Data Analytics, Free, Free Download, How to..., Written by Skyyler

New ACL CEO, New Fierce Direction?

The profile article of the new ALC CEO, Laura Schultz, indicates a new direction at the company, but I’m not sure what that direction is. Here’s why: 1. ACL tweeted that Schultz is  “fiercely determined” (see below), and in the … Continue reading

2 Comments

Filed under ACL, Data Analytics, Written by Skyyler

ACL tip: Create a File Import Script

Did you know that you can create a script to import a file into ACL? That you can automate loading a table? I’m talking about the File > New > Table command in ACL, also known as the Data Definition … Continue reading

23 Comments

Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

ACL Error: Working Directory Does Not Have Write Access

On occasion, I have received the following ACL error: The working directory does not have write access permission (see below). Simply said, it means: the working directory is not working; something is not write. :) Seriously, the working directory is … Continue reading

6 Comments

Filed under ACL, Data Analytics, How to..., Written by Skyyler

Error: ACL Desktop cannot complete this function

When you’re trying to load a new file into an ACL table, you’ll sometimes get this error:: “Application error. ACL Desktop cannot complete this function…contact ACL Technical Support…” (see below). Here’s the situations in which I’ve encountered this error, and … Continue reading

5 Comments

Filed under ACL, Data Analytics, Written by Skyyler

Master List of ACL Articles and Tips

To make these posts easier to find (and link to), here’s a list of all the ACL posts on this blog in alphabetical order, and by most popular. I’ll add other posts as they are written.

4 Comments

Filed under ACL, Audit, Data Analytics, Excel, Free, How to..., Scripting (ACL), Technology, Top 10

ACL tip: Quickly View/Print Table Layout

To quickly view or print the table layout in ACL, type dis in the ACL command line (dis is short for display). The table layout contains information about the fields in a table, such as field names, field type (ASCII, … Continue reading

Leave a comment

Filed under ACL, Audit, Data Analytics, How to...

A Review of ACL Acerno

I haven’t been able to find any reviews of ACL Acerno, so I decided I better get to it. What is Acerno? According to ACL’s website, ACL Acerno is a Microsoft Excel Add-in that allows you to efficiently and easily … Continue reading

5 Comments

Filed under ACL, Audit, Data Analytics, Excel, Poll, Written by Skyyler

ACL tip: Prefix Computed Fields with c_

It’s a best practice to prefix all computed fields with “c_” (e.g., c_Region) for the following reasons: 1) Computed fields are not original data, and you should always keep this in mind. You should scrutinize the values in computed fields … Continue reading

Leave a comment

Filed under ACL, Data Analytics, Written by Skyyler

ACL tip: What is a Computed Field?

A computed field is a field in an ACL table that you create using expressions. An ACL expression is similar to a Microsoft Excel formula [e.g., =SUM(A1:A2)] in that it contains at least one function [like SUM]. Excel formulas operate … Continue reading

3 Comments

Filed under ACL, Audit, Data Analytics, How to..., Written by Skyyler

Free ACL Bootcamp Training – from ACL!

ACL is offering FREE training as part of their bootcamp series, which started in September 2011. The training consists of a video presentation that includes ACL demos. The best part is that you do NOT have to be a current … Continue reading

1 Comment

Filed under ACL, Audit, Data Analytics, Free

ACL: Strange Message in Log

If you’re an ACL user, I sure hope you read your ACL project logs and approach the JOIN command carefully. I recently received a good reminder. For an explanation of ACL, see this post.

Leave a comment

Filed under ACL, Data Analytics, Written by Skyyler

ACL tip: “Unfreezing ACL”

Occasionally when using ACL, the application appears to freeze when I open a dialog box. So I restart ACL and it works fine until I repeat the action that “froze” it in the first place. For me, it always happens … Continue reading

8 Comments

Filed under ACL, Audit, Data Analytics, How to..., Written by Skyyler

ACL tip: Rerun a Join Easily

Rerunning an ACL join command is much easier than most people realize.  And everyone using ACL screws up joining two tables more often than he’ll admit. It goes like this: You painfully select the primary keys, the secondary keys, the … Continue reading

Leave a comment

Filed under ACL, Audit, Data Analytics, How to...

New, Cheap ACL Training

ACL.com just launched virtual classroom training in North America. Check it out at http://www.acl.com/virtual_classroom (if that doesn’t work, try here, as they keep changing the URLs). Sorry, but the virtual classroom was discontinued, according to ACL. See Nav’s comment about … Continue reading

1 Comment

Filed under ACL, Audit, Data Analytics, How to...

Free ACL Benford’s Law Training (Online)

I found a website where a group from the Business School of the University of Colorado Denver is offering free online training for ACL running Benford’s Law analysis on data. This training was offerred for a limited time and has … Continue reading

4 Comments

Filed under ACL, Audit, Data Analytics, Free

Teach Yourself ACL

You can teach yourself how to use Audit Command Language (ACL), the data analytics software from http://www.highbond.com. ACL is used by internal auditors and others to:

45 Comments

Filed under ACL, Audit, Data Analytics, Free, Free Download, How to..., Scripting (ACL), Technology, Written by Skyyler