Search Results for: acl
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
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
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
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.
ACL ‘robotics’ is ACL scripts dressed up in formal clothes with a designer label. It is NOT robotics. Continue reading
Renaming an ACL can cause problems if you don’t also rename the .fil data file associated with the table. Continue reading
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.
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
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
In my last post, I described Why Internal Auditors Should Care about Robotic Process Automation. In this post, I’ll explore whether RPA can replace analytic packages like ACL, IDEA, R, and Power BI. That might seem like a strange question, but a … Continue reading
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
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
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):
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
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
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
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.
If you have ever wanted to go to an ACL conference, this is the year to do it.
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
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
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
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.
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
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.
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
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:
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
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
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
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
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
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
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
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
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
Free ACL tutorials are available on YouTube, along with a lot of videos with talking heads. The tutorials walk you through how to do a couple tests, but I found the video resolution to be rather poor. Maybe it’s my … Continue reading
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
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.
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
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
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