Scripting

Starfish Scripting Resources

• Starfish Scripting Class
• Execute When

Global Scripts

To create a Global script, click on the VBScript Global or .NET GLobal button in the Mapping ribbon:

C#

• Parse XML
• Using Starfish Scripting Class Properties & Methods in C#
• Upload a file to FTP
• Log and Ignore Row Error
• Using C# Global Methods

C# Field Scripting Examples

• Convert Time Zone
• Download File
• Working with MultiSelect Lists
• Convert String to ASCII85

Javascript

• Examples of using Starfish Class Functions In Javascript
• Online Regex Tester
• Regular Exp Detect URLs in text with JavaScript

VBScript

VBScript Resources

• https://www.w3schools.com/asp/asp_ref_vbscript_functions.asp
• VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp

Sample Global VB Script Functions

• Format Phone Number
• Clean String Functions - Remove Unwanted Characters

Field Scripting Examples

• Check for bad email address
• Convert state abbreviations to full name with VBScript
• Look in many xref lists for an origin ID
• Parse text and look up ID based on result
• Write Null instead of Blank

Job Scripting Examples

• Check for duplicates using xref
• Interact with the local file system
• Pull data from a source and write to file
• Retrieve Records Modified After Last Run DateTime
• Use Before Save and After Save operations to loop through a single origin record multiple times
• Use the same job to loop through multiple origins
• Using Row Hashing for Incremental Integrations

JSON

• Validate and parse JSON: http://jsonlint.com/