Search Results for: acl
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. Even if you don’t use ACL, you might gain … Continue reading
In case you missed it, ACL released the next version of their Acerno product, renamed it ACL Excel Add-in, and made it FREE! So I thought I’d update my review. For my original review of Acerno, see A Review of ACL Acerno. It … 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