Review and run a trial
The review shows exactly what will happen before anything is saved.
Review your file
- After you click Continue, a progress page ("Checking every row") validates the whole file in the background. Reopening the review later is instant.
- The Review page shows a verdict (all rows ready, some rows have errors, or cannot run) and totals. For supported types each row is labelled New, Update (matches an existing record and will overwrite it) or Rejected (the chosen mode will not accept it).
- If you expected a fresh load and most rows say Update, your key column is matching existing records. Stop and check.
- A duplicate-key warning appears if two rows share a key, because the later row overwrites the earlier one. Under Add new only, a row whose key already exists is skipped, and the counts on the page already leave it out.
- Use Show only rows with errors to focus the grid. The first 500 rows are shown; the whole file is still checked.
Run a trial
- Click Run a trial first.
- Read the result. The trial runs the real import for the first batch of rows and then undoes it. It finds problems a cell-by-cell check cannot, such as a category that does not exist, a supplier spelled differently or a duplicate code.
- Fix any rows it flags. Trial failures that the review did not show are expected.
Nothing is saved by a trial.
Run the import
- When satisfied, click Import N rows and confirm.
- Not happy? Click Back to matching, or Discard & Start Over.
:::info Where the New, Update and Rejected labels appear They are shown for Items, Parties, Employees, Product Groups, Warehouses, Departments, Units of Measure, Designations and Chart of Accounts. :::
Learn more about Biznsbook Data Import on biznsbook.com.