ACL Training and Consulting by Paul Picard
User friendly interface between user data problems and ACL based solutions

 

Generic outline of  basic Scripting workshops

It is crucial that the scripting training sessions and workshops are adapted to the experience levels and goals of the participants.  This is a generic outline to build from. The workshops can go from very basic introduction scripting to what I call Extreme ACL Scripting that goes beyond the normal limits of ACL.

1.   Generic info about scripts

            What is a Script?

1.2         Why make some scripts?

1.3           Running  scripts in ACL

1.4           Script Planning

1.4.1      Know exactly what you want to do:

1.4.2      Verification

1.4.3      Modular design

1.4.4      Naming convention

1.5           Syntax

2.   Creating a script

2.1 Using commands in the log

2.2 Table history

2.3 Script Recorder

2.4 Manually create and edit a script

3.   Basic Commands

3.1           The Comment command

3.2           The Set command

3.3           Open and Close tables

3.4           Delete

3.5           Defining fields

3.5.1      Physical fields:

3.5.2      Simple computed field

3.5.3      Conditional computed field

3.6           The All parameter

3.7           Workspace

3.8           Save command

4        Do Script command within a script

4.1           The mechanics of the process

4.2         The IF command and the if parameter

If Command:

If parameter (command filter):

The If command with Do Script

4.3       Do Script [While] The while control.

5        Group…End  Command

A command very specific to ACL that controls the flow of complex processes and accelerates the multi tasking of commands on a table.

5.1 Commands that can be used within group

5.2 Simple groups

5.3 Variables in Group

5.4 Conditional Group

5.5 Nested Group

5.6 Loop command

6   User interface

6.1 Accept User Input

6.1.1 Dialog windows

7.1.2 Control quality of input

6.2 Keep user informed

8. Building generic scripts as templates

How to build scripts that can be easily be adapted to similar situations.

9. Building fully automated scripted solutions

From the data access to the formatted desired outputs.