Import deals from CSV: how it works
Turns a CSV file — from an exchange export, an OTC chat log or your own spreadsheet — into draft deals. You map the columns, preview every row with its errors and duplicates, and then create the drafts, which you confirm one by one.
Lesson 2 of 13 · How it works
How it works
Choose the «CSV file» or paste the text, then «Preview»; the columns are guessed and can be changed under «Columns» (date, side, asset symbol, network, quantity, rate, value, fee, Tx hash The unique id of a transaction on the blockchain; anyone can look it up in a block explorer. More words in the glossary, wallet, customer, reference).
Tick «The file shows the client's side» when buy means the client bought; the rows are then turned round to the desk's side.
Every row is checked: date, buy / sell, an asset in the catalog, an exact quantity, a rate or value, a valid tx hash and wallet address.
Duplicates are skipped: a tx hash already recorded or twice in the file.
«Create the drafts» saves the valid rows as drafts with source CSV import; nothing is confirmed or posted by the import.
Where to find it
- Import deals (CSV)
/admin/digital-assets/import
Settings that change it
- Assets & rates
/admin/digital-assets/assets
Checklist
Before you move on, check that you can:
- Open Import deals (CSV)
- Choose the CSV file or paste the text, then Preview; the columns are guessed and can be changed under…
- Tick The file shows the client's side when buy means the client bought; the rows are then turned round to…
- Every row is checked: date, buy / sell, an asset in the catalog, an exact quantity, a rate or value, a valid…
- Duplicates are skipped: a tx hash already recorded or twice in the file.
Tips and common mistakes
- The file may be at most 2 MB; split a long history into several files.
- Rows with an unknown symbol fail — add the asset with the same network first.