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
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
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
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 on cells (like A1 and A2), but computed fields operate on fields.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to..., Written by Skyyler
Tagged as acl, character, computed field, customer, expression, format, formula, function, length, region, skyyler, start, string, SUBSTR, syntax, text, tip, type, what is