Working with Cross References (Xref files)

Working with Cross References (Xref files)

Working with Cross References (Xref files)

Xref files servermany purposes. The most common case is as foreign key lookups. Another common case is to use Xrefs as pick list lookups. Tables can be created manually. They can be created by importing the data. Or, they are created by the system using Starfish.XRefWrite() method.


Use the following steps to access sand modify an Xref table:




  1. Navigate to the Projects Xref Lists. Two lists will need to be updated to reflect process flow across each system.


  1. Select leadstatustype
  2. Modify the cross reference pairs as required to reflect your workflow


  1. Select Leadcycle Stage – Creatio to HubSpot
  2. Modify the cross reference pairs as required to reflect your workflow 

    • Related Articles

    • Cross-reference (Xref)

      Starfish ETL has built-in methods for maintaining relationships between different systems. Put simply, you will be storing an ID from your Origin, and the new corresponding ID from your destination for the record. For example, if you are migrating ...
    • Check for duplicates using xref

      I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the Attachments table. I had a before operation that would read and write to the ...
    • Working with Starfish Variables

       Starfish variables can be used to store configurable information used by jobs and scripts. In the example below, several Variables have been defined. Use the following steps to walk through Viewing variables Selecting and changing a variable ...
    • Working with MultiSelect Lists

      For this example we use SugarCRM, where MultiSelect fields are supplied as a JSON string, i.e. [{"value1","value2"} First, I check to make sure my origin value ('reg') and existing value in Sugar ('existing') are not empty, as either case is easy to ...
    • Look in many xref lists for an origin ID

      Function ScriptedField Dim newid Dim oldid oldid = "@@ORG:OLDID@@" newid = XrefRead("Accounts",oldid) If Len(newid) = 0 Then newid = XrefRead("Contacts",oldid) End If If Len(newid) = 0 Then newid = XrefRead("Opportunities",oldid) End If If Len(newid) ...