Import tips and best practices
A few habits prevent most import problems.
Before you upload
- Start with 5 to 10 rows to test the whole journey.
- Follow the load order.
- Use the template and its dropdowns, and delete the sample rows.
- Save old
.xlsfiles as.xlsxor CSV UTF-8. - Keep codes and keys unique, so the right record is matched.
Pick the right mode
- Add new only for a first load.
- Add or update to correct and re-run. Running the same file twice updates the same records and duplicates nothing.
- Update existing only for corrections to records you already have.
Pick a failure policy
- All or nothing for anything that touches money.
- Partial success for large master-data migrations where you want to make progress and fix the stragglers.
Before you run
- Check the New / Update / Rejected labels. Mostly Update on a fresh load means the key is matching existing records.
- Use Run a trial first.
- Remember that reversing cannot restore overwritten values.
:::info Why is my import waiting? Only one import per company runs at a time, and the import workers are shared by all companies. :::
Learn more about Biznsbook Data Import on biznsbook.com.