Scripting: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) No edit summary |
No edit summary |
||
Line 22: | Line 22: | ||
*[[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]] | ||
*[[Using Row Hashing for Incremental Integrations]] |
Revision as of 13:22, 30 October 2015
Starfish Scripting Resources
VBScript
VBScript Resources
- http://www.w3schools.com/asp/vbscript_ref_functions.asp
- VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp
Sample Global VB Script Functions
Field Scripting Examples
- Convert state abbreviations to full name with VBScript
- 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
- Using Row Hashing for Incremental Integrations