Search Results for: acl

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

16 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

9 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

3 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

2 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

Leave a comment

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

1 Comment

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

Leave a 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

2 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):

10 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. Even if you don’t use ACL, you might gain … Continue reading

1 Comment

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

Review of ACL Excel Add-in, Now FREE!

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

4 Comments

Filed under ACL, Audit, Data Analytics, Excel

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

3 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

Leave a comment

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

Leave a 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.

1 Comment

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

22 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, Data Analytics, Top 10