Importing your existing data
Customers, suppliers, items, opening balances and open orders - loaded from a spreadsheet and checked before anything is written.
Everything is loaded from one screen, Workspace → Data import. Pick what the file holds, download the template for it, fill the template in and upload it as a CSV or Excel file.
Load it in this order
- Masters first - units, locations, contacts, suppliers and products. Everything else refers to them.
- Then the position you arrive with - opening stock, what customers owe you, what you owe suppliers, and purchase and sales orders that are still open.
- Then anything particular to your trade - supplier rates, estimation rates and bill-of-quantities lines, or a charity's donation history.
The screen only offers what your workspace can use: opening stock needs the inventory module switched on, for instance, and a donation history needs donations.
Check first, then import
An upload runs one of two ways. Check only reads the whole file and lists every row that would fail - its row number, the column and the reason - and writes nothing. A real import writes every good row and skips the bad ones, so one mistake does not cost you the other four thousand rows.
If an import stops half-way
Each row is saved on its own, and the platform remembers which rows of a file it has already loaded. Upload the same file again and it carries on from where it stopped rather than loading anything twice.
Every run stays on the screen with its result - how many rows were new, updated, unchanged or had problems - along with who ran it and when.
Tip: Run Check only on every file, however small. It writes nothing, and it is the one way to see every problem in a file at once.