Scripting: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) (→C#) |
Jkuehlthau (talk | contribs) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 10: | Line 10: | ||
*[[Using Starfish Scripting Class Properties & Methods in C#]] | *[[Using Starfish Scripting Class Properties & Methods in C#]] | ||
*[[Upload a file to FTP]] | *[[Upload a file to FTP]] | ||
*[[ | *[[Log and Ignore Row Error]] | ||
==C# Field Scripting Examples== | ==C# Field Scripting Examples== | ||
Line 16: | Line 16: | ||
*[[Download File]] | *[[Download File]] | ||
*[[Working with MultiSelect Lists]] | *[[Working with MultiSelect Lists]] | ||
*[[Convert String to ASCII85]] | |||
=Javascript= | =Javascript= | ||
*[[Examples of using Starfish Class Functions In Javascript]] | *[[Examples of using Starfish Class Functions In Javascript]] | ||
*[https://www.regextester.com/|Online Regex Tester] | *[https://www.regextester.com/| Online Regex Tester] | ||
*[https://www.regextester.com/96249|Regular Exp Detect URLs in text with JavaScript] | *[https://www.regextester.com/96249| Regular Exp Detect URLs in text with JavaScript] | ||
=VBScript= | =VBScript= |
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/