Jarltech Manual Import
The manual import page allows you to upload and process Jarltech catalog and price files (CSV/TXT) directly in Business Central.
Opening the Page
- Via search: Jarltech Manual Import
- Via the Dashboard → Manual Import
How It Works
The manual import provides an alternative to the automatic Blob Storage import:
- Select file — Upload a CSV or TXT file from your local computer
- Choose import type — Specify the type of data to import
- Review preview — Recognized data rows are displayed
- Start import — Data is written to the merchantCENTRAL Supplier Data table
Import Types
| Type | Description | File Format |
|---|---|---|
| Price List | Item prices with purchase price and RRP | CSV (semicolon-separated) |
| Stock Levels | Availability and delivery times | CSV (semicolon-separated) |
| Full Catalog | Complete item master with all fields | CSV (semicolon-separated) |
Fields
| Field | Description |
|---|---|
| Import Type | Type of data to import. |
| File Name | Name of the uploaded file. |
| Encoding | Character encoding of the file (default: UTF-8). |
| Separator | Delimiter character (default: semicolon). |
| Has Header Row | Indicates whether the first row contains column headers. |
| Lines Found | Number of recognized data rows. |
| Lines Imported | Number of successfully imported rows. |
| Lines Skipped | Number of skipped rows (e.g., duplicates). |
Actions
| Action | Description |
|---|---|
| Select File | Opens the file selection dialog. |
| Start Import | Starts processing the selected file. |
| Preview | Shows the first 20 rows of the file for review. |
Supported File Formats
Price List (Standard Format)
ItemNo;Description;PurchasePrice;RRP;Currency;Weight
JT-001234;Barcode Scanner XL;89.50;129.00;EUR;0.350
JT-001235;Label Printer Pro;245.00;349.00;EUR;2.100
Stock Levels
ItemNo;Stock;Available;DeliveryTime
JT-001234;150;142;1-2 days
JT-001235;0;0;2-3 weeks
Tips
Automatic Import Preferred
For regular operations, we recommend the automatic import via Azure Blob Storage (configurable in the Setup). The manual import serves as a fallback or for special cases.
Encoding
Jarltech files use UTF-8 by default. If umlauts are not displayed correctly, switch to Windows-1252.
Large Files
The import shows a progress dialog for files with more than 100 rows. Processing is transaction-safe — if an error occurs, the entire import is rolled back.