Scripting: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Jkuehlthau (talk | contribs) |
||
(26 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== | ||
* | *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 | ||
==Sample Global VB Script Functions== | ==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]] | *[[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]] | ||
Line 22: | 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/ |
Latest revision as of 18:08, 22 September 2023
Starfish Scripting Resources
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
C# Field Scripting Examples
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
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/