@payloadcms/plugin-import-export: Issue with exporting relationship and array fields

[Phyo-Alpha]

So yesterday I added the import-export plugin to PayloadCMS to test it out, so far it working fine. However it got issue when exporting either relationship fields or array fields. For relationship fields it only exported the id and for array fields it exported the first index of the array in each of the row.

I want to know if there a way to customize how fields are handled when exporting, preprocess the data before the file is created.

This is what it look like for relationship fields.

And for array fields type, only the first index of the array fields are exported.

Notice that the column only have division 1, even though other divisions exist.

This is currently my config.

[DanRibbens]

Hello @Phyo-Alpha

We added a new feature that was released yesterday in v3.42.0. The plugin now allows you to add a new toCSV function that you can write to modify the data or return a different value.

Here is an example of a relationship field that adds the customRelationship_id and customRelationship_email to the csv:

{
  name: 'customRelationship',
  type: 'relationship',
  relationTo: 'users',
  custom: {
    'plugin-import-export': {
      toCSV: ({ value, columnName, row, siblingDoc, doc }) => {
        row[`${columnName}_id`] = value.id
        row[`${columnName}_email`] = value.email
      },
    },
  },
},

If you wanted to just change the value from id to email you would just return value.email.

We're working on the import half of the plugin and then docs will be added to the site.

[DanRibbens]

I'm not sure why only the first item of an array is being exported. It should export array data with columns like array_1_subfield, array_2_sufield.