Usually, I’m the one doing the auditing, but this time, I (Mack) was the one who was audited.
It was a great experience for me.
Well, sort of. No one likes being audited (ahem). But it gave me a fresh perspective of how others feel when I audit them.
This is the first of 3 posts; this post contains some background info on the project that was audited, and the second one discusses the audit and the results, and in the third post, I describe my perspective on the whole thing, and some takeaways.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Case Files, Data Analytics, Scripting (ACL)
Tagged as acl, Audit, auditee, automation, CAE, fine, fraud, regulator, schedule, script
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 was add one more file to the folder. ACL refused to load that one file.
Syntax error.
WTS?
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology
Tagged as bob, error, import, length, name, script, syntax, table, too long
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 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 →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, bypass, check, computed, conditional, conventions, duplicates, ESCAPE, fail, field, first, found, ignore, invalid, log, pause, review, script, second line, test, unable
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 →
Like this:
Like Loading...
Filed under ACL, Scripting (ACL), Written by Skyyler
Tagged as acl, datetime, delimited, error, field, format, import, log, script
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.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Scripting (ACL), Top 10, Written by Skyyler
Tagged as acl, benford, dream, forum, freak, script, sleep, terminate
When 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 →
Like this:
Like Loading...
Filed under Audit, Free, How to..., Technology, Written by Skyyler
Tagged as acl, chunk, file, import, reduce, script, splitter
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 →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, add, boot camp, CCF, character, column, computed field, conditional, country, customer, c_, default, expression, format, formula, function, length, manual, region, sales, script, skyyler, start, string, SUBSTR, syntax, text, tip, type, video, what is
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 →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as add, close, comment, computed, define, field, safety, script, table
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.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as as, easy, edit, export, extract, field, first, import, join, records, script, table, ten, width
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 using ACL to it’s fullest, nor are you making the best use of your time.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Free, Free Download, Scripting (ACL), Written by Skyyler
Tagged as acl, Anke Giegandt, best practice, command, Conference, create, design, download, error, free, log, Presentations, recorder, script, syntax, table history, table history incomplete
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:
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Scripting (ACL), Written by Skyyler
Tagged as acl, command, computed, extract, field, group, kevin, keywork, optimize, presort, script, search, tips
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 manually or via script. We’ll tackle the script version first.
This post is in response to Les’ question about reordering fields in a table.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as change order, computed, custom, default, field, manual, script, table, view
When checking system access, make sure you look at all the different items that affect the user’s access. For example, the user might need one or more of the following:
- Application ID
- Application role or group
- Membership in an local server group, Active Directory (AD) group, or UNIX Group
- Access to the application’s share and/or folder on the server
- Database ID
- Database role, including access permissions (read/write)
- Other permission (from a home-grown application code or enterprise identify management system)
Continue reading →
Like this:
Like Loading...
Filed under Audit, How to..., Security, Technology
Tagged as access, active, AD, admin, application, Audit, batch, confidential, contractor, data, database, directory, employee, file, financial, folder, format, generic, group, hipaa, HR, ID, LDAP, log, membership, new, non-personal, OS, PCI, permission, personal, role, script, setup, share, sox, system, Unix, user
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 profile, she talks about being “hell-bent” and “extreme” and taking vacations that involve “starving” and “afraid”. This is not your grandmother’s CEO, and maybe that’s the point. Either way, it doesn’t give me any comfort.

Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Written by Skyyler
Tagged as 9.3, acerno, acl, afraid, arbutus, ceo, competition, crown, data analytics, direction, fierce, hard to use, hellbent, help files, IDEA, larry ellison, laura schulz, log, profile, script, starving, step out the back jack, tweet, user interface, workpapers
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 Wizard. Yes, you can create such a script, and I’m going to teach you how!
The good news is that it’s so much easier than you think. The bad news is that it doesn’t APPEAR easy, but it really is, because ACL does the heavy lifting for you. I promise that if you hang in there, you’ll so be a pro. Just try it once, and you’ll be hooked!
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, automate, data definition, error, field, file, How to..., ignore, import, load, safety, script, table, wizard
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.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Excel, Free, How to..., Scripting (ACL), Technology, Top 10
Tagged as acerno, acl, AuditNet, bootcamp, builder, coderre, computed field, data analytics, error, expression, freeze, function, history, import, index, join, list, log, message, script, social networking, table layout, teach yourself, tips, Top 10, training, tricks, youtube
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 ACL customer or even have a copy of ACL.
The purpose of the series, according to ACL, is to teach basic skills and deal with common problems that ACL users encounter. Each session lasts about 30-40 minutes, followed by a Q&A session. The bootcamp is led by Shane Grimm (see his blog comment here).
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Free
Tagged as access, acl, bootcamp, cpe, data, free, join, log, relation, script, shane grimm, table, training, trick, troubleshoot, webinar
On my walk to work, I cross a lot of 1-way streets. I always look both ways. Sometimes, when a friend or colleague is walking with me, I get teased me about this. I always reply with this question: Have you ever driven down a 1-way street the wrong way? For some reason, I never get a reply and another subject surfaces.
When I crossed one of those streets the other day, I realized that some people look at audit/security/risk the same way. They only look one way because of the people or rules or controls or norms that govern the activity. They fail to think outside of the cubicle and look the other way–the path seldom traveled.
Continue reading →
Like this:
Like Loading...
Filed under Audit
Tagged as add, admin, approved, control, list, look, monitor, one-way street, review, script, super user, terminate, test, value, vlookup, wrong way
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 →
Share this:
Like this:
6 Comments
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as add, close, comment, computed, define, field, safety, script, table