CSV & spreadsheets
Flat files remain the fastest path from legacy systems into Primicornis.
Recommended pipeline
- Profile — open the CSV, check for duplicate headers, inconsistent currencies, embedded commas.
- Normalize — trim whitespace, standardize ISO dates, collapse ambiguous labels.
- Map — align headers to property keys (use the analyzer endpoint to preview errors).
- Dry-run —
analyzewithoutapply. - Commit — import run with logged statistics.
File prep
| Step | Detail |
|---|---|
| Encoding | UTF-8 without BOM |
| Delimiter | Comma or TSV (declare explicitly in UI/API) |
| Primary key | Provide external ID column for idempotent upserts |
| Relations | Either separate join files or encoded foreign keys (slug or UUID) |
Spreadsheet hygiene
Remove filter views before export, freeze header row, and never import calculated columns that won’t exist in Primicornis unless you recreate them as plain fields.
Error handling
Expect row-level errors on first import — capture them, fix source data, and rerun only the failing scope when possible.