Write Null instead of Blank

Write Null instead of Blank

By default, Starfish will write a blank, "", value to the destination. If you instead want to write Null, you must use a script for this.

Function ScriptedField
  ScriptedField = "@@ORG:law_firm_c@@"
  if len(ScriptedField) = 0 then
    ScriptedField = vbNullChar
  end if
End Function

If you would prefer that no value at all gets written to the destination field, check the "Skip Blank Writes" box under Manage Stages for that stage.


Another option is to use a special code, @@CHR:DBNULL@@, which will force the writing of a NULL to the destination. You can use this in scripts or as a hardcoded value as illustrated below:

    • Related Articles

    • Pull data from a source and write to file

      With this map, I wanted to pull all accounts from a Sugar instance and dump a few fields into a pipe delineated file. In this map I used the same Sugar instance as both the Origin and Destination. There were no Stages created, so no action was taken ...

    • Creating a New Stage

      Creating a Stage Under the mappings tab there is a bar titled stages. At the very end of the stages bar (on the right of the screen) there is a button with a + and what looks like a bulleted list, click this button and the New StarfishETL Stage menu ...

    • SugarCRM REST Connector

      SugarCRM REST Origin Use JSONLint to validate JSON: https://jsonlint.com/. Sample Origin Filters See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ Note the [{...}] surrounding the filter. This is required. ...

    • Salesforce Connector

      Additional Documentation This Connector is based on the Salesforce ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RFG/ado/ Salesforce Origin Case as Origin Table You ...

    • Queued Stages

      Queued Stages are a useful feature for aggregating data or supplying "structured" data. Often systems will expect to have data bundled up and submitted all at once. A good example of this is how many ERP systems expect Sales Orders to be submitted. ...