Relationships

If you're using Publisher, and the Publisher DataGrab Connector, unfortunately Relationship fields inside of a Grid field do not import. We have not been able to find a working solution and apologize for the inconvenience.

In order for imports into a relationship field to work, it will need to be able to find existing entries to relate to, meaning importing relationships is usually a 2 step process. This usually means configuring 2 different imports with 2 different files. The first import contains all of the entries you're expecting to be assigned to a Relationship field, and the 2nd import would contain the configuration for the Relationship field itself to create the assignments.

When importing multiple relationships into a single Relationship field, you must use a single XML node or JSON property to assign all the relationships, for example:

<entries>
  <entry>
    <related>Entry One, Entry Two</related>
  </entry>
  ...
</entries>

The following formats will not work:

<entries>
  <entry>
    <related>
      <title>Entry One</title>
    </related>
    <related>
      <title>Entry Two</title>
    </related>
  </entry>
  ...
</entries>

<entries>
  <entry>
    <related>
      <title>Entry One</title>
      <title>Entry Two</title>
    </related>
  </entry>
  ...
</entries>

There are multiple characters you can choose as the separator.

The example above illustrates importing by title, but you can also use IDs if you know what they are. For example if 3|10|23 is the value of one of the CSV columns, JSON or XML nodes, and you mapped that field to a Relationship field in ExpressionEngine, then the imported entry will be assigned 3, 10, and 23 assigned as a relationship.