Importing a file is the task every business user does and every application reimplements. This release ships one wizard, with every rule about the data decided on the server.
The steps
- File A click-or-drop chooser with an accepted-type list and a size limit, usable on its own anywhere a file is wanted.
- Read options with a live preview Separator, encoding, header row and the rest, with the parsed rows shown as the options change.
- Target An existing table or a new one.
- Columns Each column decided against the plan the server returns: mapped, converted, ignored.
- Run and result Progress while it loads, then the count and the refused rows downloadable as a CSV to fix and resubmit.
Formats
- Seven CSV, unload, XLS, XLSX, JSON, XML and Parquet.
The wizard carries no rule of its own. The server decides what a column can become, and the wizard shows the decision.