Import Containers

The Import Containers action is used to add new containers to the system or update existing ones based on data from an importing file. This action is available from the More Actions submenu.

File Upload and Format Selection

  • Clicking the button opens a window for selecting a CSV file from the local device.

  • The window also includes a Splitter setting to define how columns are separated (e.g., comma or semicolon).

Mapping Fields

After selecting a CSV file and confirming with , a field-mapping window appears. This step is used to match columns from the file with corresponding properties in the system.

  • If the file contains headers (column names), the system attempts to match them automatically.

  • If the file starts directly with values instead of headers, the system displays the first row of values. Mappings must then be assigned manually based on content.

  • Enable the Import First Row checkbox to skip the first row during import (recommended if the first row contains headers).

Import Process

After confirming the mapping, the system processes the file line by line, with each row representing a single container.

  • If a container with the same number already exists, the system updates its data.

  • If the container number does not match the required format XXXX1234567 (4 letters + 7 digits), it will not be imported.

  • When the import process finishes, a summary window provides details on created, updated, and ignored containers.

Example CSV File Structure
  1. Column-Based Format

    • Each field is placed in its own column. This format ensures proper mapping and is easier to review during import.

    • In this case, select semicolon as the delimiter in the Splitter setting.

    ContainerName

    Status

    ContainerType

    Length

    Height

    MaxLoad

    ABCD1234567

    Leased

    RH

    30

    50

    500

    EFGH7654321

    Leased

    RH

    30

    50

    500

  2. Row-Based Format

    • All values are placed in a single row, separated by commas.

    • In this case, select comma as the delimiter in the Splitter setting.

    ContainerName, Status, ContainerType, Length, Height, MaxLoad

    ABCD1234567, Leased, RH, 30, 50, 500

    EFGH7654321, Leased, RH, 30, 50, 500