Skip to main content

Data Import permissions and troubleshooting

Permissions​

Company Admins can always use Data Import. Other users need these permissions:

PermissionLets them
DataImport.ViewSee the Import menu, dashboard, templates and results
DataImport.ExecuteRun an import, resume it, and do a trial run
DataImport.UndoReverse a finished import
The target area's permissionImport into that area

Examples of target permissions: HRMS.CreateEmployee for employees, Accounting.CreateJournal for vouchers and opening balances, Accounting.ManageChartOfAccounts for the chart of accounts, Company.ManageParties for parties and CRM.Create for CRM. Types a user may not write to are not offered.

Limits​

  • CSV (.csv) or Excel (.xlsx) up to 20 MB.
  • Up to 50,000 rows per file, or 10,000 for finance vouchers and opening balances.
  • Older .xls files are not accepted. Save as .xlsx or CSV UTF-8.
  • Larger files must be split and imported one after another.

Troubleshooting​

SymptomCauseFix
No Import menuNot licensed, or you lack View permissionAsk your administrator
Old Excel files (.xls) are not supportedUnsupported formatSave as .xlsx or CSV UTF-8
File too large or too many rowsOver the limitsSplit the file
The column header appears twiceDuplicate headingsRename one heading
Another Data Import is already in progressOne import per companyOpen it, or use Discard it and continue here
Previewed a file, cannot upload a fixed oneThe preview holds the slotDiscard & Start Over; matching is kept
A required field has no column mappedNot mappedGo back to Match columns
Update did nothingWrong key column, or Add new onlyCheck matching and mode
Trial run shows failures the review did notExpected: the trial checks lookups and database rulesFix those rows
Nothing was removed, a record is now referencedSomething created since points at a new recordRemove or reassign it, then reverse again
Server memory is too highVery large fileSplit it, then Resume import if it had started

:::info Import history report Data Import History is under Reports → Operations & communication, with Excel, CSV and PDF: every import in a period with rows inserted, updated and failed, and the error summary. :::