Data Import permissions and troubleshooting
Permissions
Company Admins can always use Data Import. Other users need these permissions:
| Permission | Lets them |
|---|---|
DataImport.View | See the Import menu, dashboard, templates and results |
DataImport.Execute | Run an import, resume it, and do a trial run |
DataImport.Undo | Reverse a finished import |
| The target area's permission | Import 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
.xlsfiles are not accepted. Save as.xlsxor CSV UTF-8. - Larger files must be split and imported one after another.
Troubleshooting
| Symptom | Cause | Fix |
|---|---|---|
| No Import menu | Not licensed, or you lack View permission | Ask your administrator |
| Old Excel files (.xls) are not supported | Unsupported format | Save as .xlsx or CSV UTF-8 |
| File too large or too many rows | Over the limits | Split the file |
| The column header appears twice | Duplicate headings | Rename one heading |
| Another Data Import is already in progress | One import per company | Open it, or use Discard it and continue here |
| Previewed a file, cannot upload a fixed one | The preview holds the slot | Discard & Start Over; matching is kept |
| A required field has no column mapped | Not mapped | Go back to Match columns |
| Update did nothing | Wrong key column, or Add new only | Check matching and mode |
| Trial run shows failures the review did not | Expected: the trial checks lookups and database rules | Fix those rows |
| Nothing was removed, a record is now referenced | Something created since points at a new record | Remove or reassign it, then reverse again |
| Server memory is too high | Very large file | Split 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. :::
Learn more about Biznsbook Data Import on biznsbook.com.