Action Types

Action Types

The action type defines what type of operation will be performed. Variable-type actions create a user-defined variable for use throughout the job.

Action Type
Description
Variable/SQL
Set a variable through the execution of a SQL SELECT statement run against the Destination database. Set the variable value equal to the first column of the first row returned by the statement.
Variable/VBScript
Set a variable through the execution of a custom VBScript function. A shell function is provided called “ScriptedVariable”, the value of the variable will be what is returned out of the function. 
Variable/C#
Set a variable through the execution of a custom C# function. A shell function is provided called “ScriptedVariable()”, the value of the variable will be what is returned out of the function.
Variable/JavaScript
Set a variable through the execution of a custom JavaScript function. A shell function is provided called “scriptedVariable()”, the value of the variable will be what is returned out of the function.
Execute SQL
Execute any kind of statement against the Destination database. Useful for calling DELETE or UPDATE statements before or after a job for cleanup purposes.
VBScript Procedure
Execute any statements desired in a VBScript Sub. A shell sub called “VBScriptProcedure” is provided. Any kind of VBScript processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing.
C# Procedure
Execute any statements desired in a C# Sub. A shell sub called “ CSharpProcedure()” is provided. Any kind of C# processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing.
JavaScript Procedure
Execute any statements desired in a JavaScript Sub. A shell sub called “jsProcedure()” is provided. Any kind of JavaScript processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing.
Xref Write
​Writes to the selected Xref List given the provided old ID and new ID.


    • Related Articles

    • Table of Contents

      General Help Frequently Asked Questions Projects Renaming, Copying and Deleting Projects Renaming, Copying and Deleting Jobs Creating a Project Creating a New Job Jobs Create a New Job Renaming, Copying and Deleting Jobs Scheduling Jobs (IN PROGRESS) ...
    • Scripting Class Object

      From within VBScript operations (ScriptedVariable, VBScriptProcedure, ScriptedField) in additional to normal VBScript functions, the developer has access to a custom “Starfish” class. The tables below define its usage. This class may also be used ...
    • Executing Pre/Post-Process Operations

      Any number of functional operations can be performed before or after a job is processed. To set up the operations, first navigate to job within the project you wish to add the operations to. Once you have selected a job navigate to the mappings tab. ...
    • Working with Variables

      StarfishETL variables can be used to store configurable information used by jobs and scripts. In the example below, several Variables have been defined. Use the following steps to walk through Viewing variables Selecting and changing a variable ...
    • Pull data from a source and write to file

      With this map, I wanted to pull all accounts from a Sugar instance and dump a few fields into a pipe delineated file. In this map I used the same Sugar instance as both the Origin and Destination. There were no Stages created, so no action was taken ...