Scripting: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(32 intermediate revisions by 3 users not shown)
Line 2: Line 2:
*[[Starfish Scripting Class]]
*[[Starfish Scripting Class]]
*[[Execute When]]
*[[Execute When]]
==Global Scripts==
To create a Global script, click on the VBScript Global or .NET GLobal button in the Mapping ribbon:<br>
[[File:Starfish_mapping_ribbon.png]]


=VBScript Resources=
=C#=
*http://www.w3schools.com/asp/vbscript_ref_functions.asp
*[[Parse XML]]
*[[Using Starfish Scripting Class Properties & Methods in C#]]
*[[Upload a file to FTP]]
*[[Log and Ignore Row Error]]


=Sample Global VB Script Functions=
==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]]
*[https://www.regextester.com/|Online Regex Tester]
*[https://www.regextester.com/96249|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]]
*[[Format Phone Number]]
*[[Clean String Functions - Remove Unwanted Characters]]


=Field Scripting Examples=
==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]]
*[[Parse text and look up ID based on result]]
*[[Write Null instead of Blank]]
*[[Write Null instead of Blank]]


=Job Scripting Examples=
==Job Scripting Examples==
*[[Check for duplicates using xref]]
*[[Interact with the local file system]]
*[[Pull data from a source and write to file]]
*[[Pull data from a source and write to file]]
*[[Retrieve Records Modified After Last Run DateTime]]
*[[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/

Revision as of 02:33, 26 February 2021

Starfish Scripting Resources

Global Scripts

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

C#

C# Field Scripting Examples

Javascript

VBScript

VBScript Resources

Sample Global VB Script Functions

Field Scripting Examples

Job Scripting Examples

JSON