Scripting: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(22 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]]
=C#=
*[[Parse XML]]
*[[Using Starfish Scripting Class Properties & Methods in C#]]
*[[Upload a file to FTP]]
*[[Log and Ignore Row Error]]
==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=
==VBScript Resources==
==VBScript Resources==
*http://www.w3schools.com/asp/vbscript_ref_functions.asp
*https://www.w3schools.com/asp/asp_ref_vbscript_functions.asp
*VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp
*VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp


Line 13: Line 33:


==Field Scripting Examples==
==Field Scripting Examples==
*[[Check for bad email address]]
*[[Convert state abbreviations to full name with VBScript]]
*[[Convert state abbreviations to full name with VBScript]]
*[[Look in many xref lists for an origin ID]]
*[[Look in many xref lists for an origin ID]]
Line 24: Line 45:
*[[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 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]]
*[[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