Tag Archives: script

ACL Import Fails, No Error?

import errorToday 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 was add one more file to the folder. ACL refused to load that one file.

Syntax error.

WTS?

Continue reading

Advertisements

Leave a comment

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

How to Review Your ACL Log

Review ACL logWhether 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 their log before the ACL project is relied upon.

(You can’t imagine the dumb mistakes my team and I found that saved us a lot of embarrassment later.)

Continue reading

2 Comments

Filed under ACL, 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, in subtraction), the log did not indicate anything was wrong. Continue reading

3 Comments

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

You Might be an ACL Freak if…

Dream ACLYou 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.

Continue reading

1 Comment

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

Free File-Splitter Program

Splits text filesWhen I ‘m trying to work with text files that are so big I can’t even open them with programs like Excel, Notepad, or PSPad, I reach for the FREE file-splitter program.

Continue reading

5 Comments

Filed under Audit, Free, How to..., Technology, 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 reading this post, you will find that will you use CCFs frequently.

So what’s the difference?

Continue reading

Leave a comment

Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL), 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? and How to Add a Computed Field (manually). Now let’s explore writing a script that adds computed fields to a table.

Continue reading

6 Comments

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