Appearance
Import and export
Platform settingsDataImport and exportPermission:
settings.integrations.vieworsettings.integrations.manageOpen in Roari ERP (new tab)Also known as
- CSV import
- bulk upload
- data migration
- data load
- mass update
- template
- export to CSV
- download data
- upload file
- spreadsheet
Load master data from CSV files (items, customers, vendors, employees, users, chart of accounts, opening stock …) and download it again as CSV. Every file is checked before anything is saved, so you can see and fix errors first. Use it to migrate from another system or to update many records at once.
Import data from a CSV file
- Go to SettingsImport and export.
- In Import, under What are you importing?, pick the data, for example Items. The columns the file needs are listed in order.
- Select Download template to get an empty CSV with the right header row. Fill it in your spreadsheet and save it as CSV (UTF-8), one record per row.
- Select Next.
- Drop the file on the upload area, or select it to browse. The first row must hold the column names.
- Wait while the file is checked. The Check step shows how many rows are ready, how many have errors, and the first rows of the file. A row with errors has a red diamond; point at a red cell to see the problem. All problems lists every error by row and column.
- Either fix the file and select Upload another file, or select Import … rows to import the good rows. Rows with errors are skipped.
The last step says how many records were imported and how many rows were skipped. The import is added to Recent imports. Select Import more data to start again, or Start over at any step before the import.
Nothing is saved until you select Import … rows.
TIP
Imports create new records and update existing ones: a row whose code (item code, username, asset tag …) already exists updates that record. Export first, edit the file and import it back to change many records at once.
Export data to CSV
- In Export, pick the Data.
- Select Download CSV. The file has every record of that kind, in the same columns as the import template.
Recent imports
| Column | Shows |
|---|---|
| When | When the import ran. |
| Data | What was imported. |
| File | The file name. |
| Imported | Rows imported. |
| Skipped | Rows skipped because of errors. |
| Result | Previewed (checked, not imported yet), Invalid (no row could be imported), Processing (a large file importing in the background), Committed (imported) or Failed. |
| By | Who ran it. |
Finished imports are removed after the period set in Data retention.
Limits
- CSV only, UTF-8, comma-separated, with a header row.
- Up to 50,000 rows per file. The server accepts files of up to 10 MB.
- Large files are imported in the background; the result appears under Recent imports.
- Custom fields have their own columns, named after their key; see Custom fields.
What you can import
The list depends on the modules you have and your permissions. It includes, among others: Items, Item categories, Units of measure, Users, Chart of accounts, Customers, Vendors, Exchange rates, Warehouses, Locations, Opening stock, Employees, Org units, Public holidays, BOMs, Routings, Work centres, Projects, Project tasks (WBS), Price lists, Leads, Vendor contracts, Vendor catalogue, Assets, Asset meters, Meter readings, Carriers, Freight rates, HS codes and country of origin, Risks, Inspection plans and Measuring instruments.
Differences by role
- Account admin sees both panels. The page needs Permission:
settings.integrations.viewor Permission:settings.integrations.manage. - Each kind of data also needs the permission to manage it (for example catalogue items), so the list shows only what you may change.
Related
- Imports and exports: CSV across the app, list exports
- Custom fields
- Items
- Users
- Set up a new organisation
