Import / Export issue when there is a relationship field

English Forum Issue Report
1

* Describe the bug

Hi,
Import / Export records plugin seems only recognize fields added prior to adding relationship field in the table.
Once you add relationship column, any field you add to the table will not appear on excel template and unable to import or export data using “Import records” or “Export records” plugin.
You can still import or export data without error, but all fields added later will be ignored.

* Environment

  • NocoBase version: 1.8.25
  • Database type and version: MariaDB
  • OS: Ubuntu 25.04
  • Deployment Methods: Docker
  • Docker image version: nocobase/nocobase:latest-full
  • NodeJS version:

* How To Reproduce

  1. Add some normal fields
  2. Add a relationship field
  3. Add some normal fields
  4. Try Import or Export excel data.
  5. The excel sheet will only have fields that you’ve added at step1.

Expected behavior

Any fields that can be imported or exported should appear on excel sheet and not ignored during the import or export process.

Screenshots

Logs

2

You’re right, fields added after creating a relationship are not recognized in the Import/Export template.
If you need to include those fields, you can first add the data into the related table, and then link them by using the relationship field during the import process.

3

Thanks for the reply.
So it means that I have to add all normal fields first, then add relationship fields in order to use import / export capability?
Even if I have the data in a related table before adding relationship fields, it won’t show up in the excel sheet…

Appreciate if you could show an example of how you handle it.