Documentation
Use Primentra
Getting Started
Data Grid
Approvals
Set up
Modeling
Business Rules
Users & Roles
Sign-in & Security
Install and run
Installation
Administration
Integration & API
Architecture
Migrate from MDS
Migrating from MDS

Export

On this page

Export downloads the entity you are looking at. Click it in the toolbar and pick a format.

The Export button with the JSON, CSV and XLSX menu open
The Export button with the JSON, CSV and XLSX menu open(click to enlarge)

The three formats

FormatUse it for
JSONReloading the data into Primentra. Wrapped in an envelope with the model name, the entity name and a timestamp
CSVAnything that reads comma-separated text. Values holding a comma, a quote or a newline are quoted and escaped. A negative number is written as it is, with no apostrophe in front
XLSXExcel. Real cell types, so dates sort and subtract as dates. A Decimal of more than 15 digits is written as text, because Excel would round a number

The file is named after the entity and the moment it was written — entity_export_YYYY-MM-DD_HHMMSS, for example branch_export_2026-08-15_143207.xlsx.

What is exported

  • No rows checked — the whole entity, every page, fetched from the database
  • Rows checked — only those rows. The button reads Export (N) to make that clear

Column filters and the search box do not narrow the export. Check the rows you want, or export everything and filter in the spreadsheet.

A column your role has set to None is not in the file, in any format. See Roles & Permissions.

How the columns are written

Reference columns become three columns

A reference attribute is exported three times over. A Supplier column produces:

HeaderHolds
Supplier{ACME} Acme Ltd — exactly what the grid shows
Supplier CodeACME
Supplier NameAcme Ltd

All three round-trip: the import wizard accepts the combined form, the bare code and the bare name. The two extra columns exist because a spreadsheet is easier to work with when the code can be read without splitting text.

If your entity already has an attribute called Supplier Code, the header appears twice and the import wizard offers two identical columns to map. Rename one of them if that happens.

Yes/No columns export their label

A Yes/No column is exported as 1 and 0, whatever labels the grid shows for it. So a file you export is a file you can import again.

Paste that label back and it is understood, with one exception: custom labels are not accepted on paste. Use yes or no instead.

Date columns

CSV and XLSX write dates in the column's own configured format, with no time component, so a file can be edited in Excel and pasted straight back through Paste rows.

XLSX goes one step further: a date is written as a real date cell with a matching number format, not as text that merely looks like a date. A derived column pointing at a date uses the format of the attribute it reads.

JSON keeps the raw stored value, because JSON is meant to be re-imported rather than read.

Derived columns

Derived columns are exported with their resolved value. They cannot be imported back, because they are calculated. See Derived Columns.

Exporting a whole model

To move an entire model — entities, attributes and data — use the model export instead of running one grid export per entity. See Model Export / Import.