Knowledge Base
About DataloyRelease NotesAPI DocumentationJava VMS Documentation
Release 8.5
Release 8.5
  • Knowledge Base
  • Voyage Management System
    • VMS: Step-By-Step Guides
      • Vessels
        • Create Vessels
        • Copy Vessel
        • Find Vessels
        • Voyages & Port Calls
        • Main Vessel Description
        • Speed & Consumption
        • Load & Discharge Rates
          • Manage Load And Discharge Rates
        • Internal Data
        • AIS & Weather Reports
        • AIS-subscription
        • View Vessel Route from Previous Port to Next Port
      • Voyages
        • Create New Voyages
          • Create Voyage Charterer
          • Create Time Charter Out
          • Create Voyage From Template
          • Create Voyage Without Cargo
        • Find Voyages
        • Maintain Voyages
          • Overview
            • Vessel
            • Cargo
            • TC
            • Schedule
            • Profit/Loss Summary
              • Analysis
            • Speed & Consumption
          • Cargo
          • Bunkers
          • Various Cost/Revenue
          • Organisational Data
          • Invoices
          • Downtimes
          • Related
          • Voyage Functionalities
            • Converting Voyage to Template
            • Change Voyage Status
            • Swap Vessel
            • Configure Voyage as a “Last TC Voyage”
            • Change Voyage Reference Number/Voyage Number and Voyage Starting Year
            • Voyage Comparison
        • TC Voyages
        • Create Laytime Calculations
        • Delete Voyages
        • Voyage Map
        • Voyage Schedule
        • Voyage Edit Schedule
        • Voyage Alternative Routes
        • Voyage Functions
          • Sensitivity Analysis
          • Intake Calculation
        • Long Time Charter (TC) Voyage
        • Voyage Bunkers
        • Voyage full-screen
          • Data grid
            • Port Calls Grid
            • Cargoes Grid
            • Cargo Ports Grid
            • Various Grid
      • Cargoes
        • Create New Cargoes
          • Create Cargo
          • Create Cargo From CoA Template
          • Create Cargo on TC Voyages
          • Create Cargo by Importing from Excel
          • Create Cargo From Existing Cargo
        • Find Cargoes
        • Maintain Cargoes
          • Cargo drawer
            • Main Details
            • Sub-cargoes
            • Various Cost/Revenue
            • Commissions
            • Freight Rate Tiers
            • Payment Terms
            • Comments
            • Cargo Drawer Actions
              • Allocate Cargo
              • Change Cargo Status
              • Delete Cargo
              • Relet Cargo
              • Convert Cargo to Relet/Non-Relet
              • Transship and Preship Cargo
              • Transfer Cargo
              • Connect Cargo to CoA
              • Remove CoA from Cargo
        • Template Cargoes
        • Capacity Plan
        • Sub-cargo
        • View Cargo History
      • Port Calls
        • Find Port Calls
        • Maintain Port Calls
          • Days Extra In Port
          • Speed Order
        • Port Call Drawer
          • Overview (And Bunkers)
            • Use Port Cost from Service Orders
              • Automating the Use (Port) Cost from Service order
            • Use Handling Cost from Service Orders
          • Service Orders
          • Bunker Orders
          • Vessel Reports
          • Port Log
            • Stoppages
        • Register Reports
          • Register Noon Reports
          • Register Arrivals
          • Register Berths
          • Register Unberths
          • Register In Port Reports
          • Register Departures
        • Custom Port Calls: 'At Sea'
      • Port Costs
        • Find Port Costs
        • Maintain Port Costs
        • View Service Orders of Port Costs
      • Contracts of Affreightment
        • Find a CoA
        • Create a CoA
        • Maintain a CoA
        • Contract of Affreightment Lines
          • Find CoA Lines
          • Create CoA Lines
          • Maintain CoA Lines
            • Template Cargoes
              • Find Template Cargoes
              • Create Template Cargoes
              • Maintain Template Cargoes
      • Time Charter Contracts
        • Create Time Charter Contracts
        • Maintain Time Charter Contracts
          • Duration and Rates
            • Create Duration and Rates
          • Notices
          • Comissions
          • Payment Terms
          • View Speed & Consumption
          • View Voyages
        • Print Statement of Account
      • Broker Commissions
        • Create Commissions
        • Find Broker Commission
        • Maintain Broker Commission
      • Bunker Orders
        • Create Bunker Orders
          • Create from a port call
          • Create bunker order from scratch
        • Maintain Bunker Orders
        • Stem Bunker Orders
        • Register Delivery Against a Bunker Order
        • Cancel Bunker Order
        • Delete Bunker Order
      • Service Orders
        • Create a Service Order
        • Maintain Service Orders
        • Handling Cost Allocation
        • Delete Service Order
      • Laytime Calculations
        • Create Laytime Calculation
        • Find Laytime Calculation
        • Delete Laytime Calculation
        • Maintain Laytime Calculation
          • Status
          • Drawer Fields
          • Manage Cargo Ports
            • Cargo Port Fields
            • Statement Of Facts
              • Event
            • Timesheet
      • Bills of Lading
        • Create Bills of Lading
        • Attachments
        • Edit Bills of Lading
        • Delete Bills of Lading
        • Print Bills of Lading
        • Print Sea Waybills
      • Downtimes
        • Create Downtime
        • Find Downtime
        • Maintain Downtime
          • Status
          • Overview
          • Various Cost/Revenue
          • Delete Downtime
      • Vessel Reports
        • Find Vessel Reports
        • Create Vessel Reports
      • Voyage Analysis Dashboard
        • Log In
        • Viewing and Managing Deviated Voyages
          • Viewing and Managing Deviated Voyages
          • Viewing Post Voyage Analysis Detail
          • No Freight Received
      • Invoices
        • Invoices List
        • Pending Invoices
        • Assembling Invoices
        • Invoice Drawer
        • Printing Invoices
        • Reversing an Invoice
      • Bunker Transactions
      • Accruals
        • Accruals
          • Batch Post Accruals
          • Generate Accruals
          • Find Accruals
          • Maintain Accruals
        • Bunker Stock Adjustments List
          • Batch Post Bunker Stock Adjustments
          • Bunker Stock Adjustment Drawer
        • Actuals list
        • Time Correction list
      • Status Transitions
      • Webhook Subscriptions
        • Create Webhook Subscription
        • Find Webhook Subscription
        • Maintain Webhook Subscription
          • Overview
          • Notification
      • Setup
        • Users
          • Create Users
            • Create a Vessel Master user
          • Maintain Users
            • Change User Passwords
          • Find Users
          • Disable Users
          • Multi-Factor Authentication (MFA)
            • Guardian Multi-Factor Authentication (MFA)
        • Security Roles
          • Find Security Roles
          • Create Security Role
          • Maintain Security Roles
        • Security Groups
          • Security Group Aliases
          • Find Security Groups
          • Create Security Group
          • Maintain Security Groups
        • System Settings
          • General
          • Invoicing Preferences
        • Data Control
        • Widgets
      • Master Data
        • Banks
        • Bunker Categories
        • Bunker Types
        • Business Partners
          • Manage Business Partners
        • Companies
          • Manage Companies
        • Events
        • Ice Class
        • Individuals
        • Port
        • Restricted Areas
        • Taxes
        • Various Costs and Revenues
        • Vessel Types
        • Commodities
      • EU ETS Compliance
      • Fuel EU
      • Attachments
      • Audit Log
      • Comments
      • Notifications
      • Field Validations
      • Sorting and Filtering Lists
      • Customising List Columns
      • Export to Excel Sheet
      • Widgets
    • Oracle Database Compatibility
  • Fleet Allocation & Scheduling
    • FAS: Step-By-Step Guides
      • Capacity Plan
      • Fleet Plans
        • Open Positions Board
        • Scheduler Board
        • Cargo Management Board
          • Cargo Actions
        • FAS Voyages List
        • FAS Cargoes List
        • Voyage Actions
      • Scenarios
        • Find Scenario
        • Create Scenario
        • Maintain Scenario
        • Copy Scenario
      • Budgets
        • Create Budget Scenario
        • Template Voyages
          • Create Template Voyages
          • Find Template Voyages
          • Maintain Template Voyages
        • Budgeted Voyages
          • Find Budgeted Voyages
          • Bulk Updating Budgeted Voyages
    • Create Voyages (JVMS)
      • Create Commitment
      • Create Commitment from CoA
      • Create Commitment from Voyage Estimate
  • Dataloy Distance Table (DDT)
    • About Dataloy Distances
    • Routing and routing options
    • Custom Point using Latitude and Longitude
    • High-Risk Area (HRA) / Piracy Routing
    • Distances API
    • Distances Change Log
  • Dataloy Systems AS
    • Privacy Policy
    • GDPR Statement
    • Release Notes
Powered by GitBook
On this page
  • Import Button
  • Import Cargoes from Excel
  • Validations before Creating
  • Requirements for Importing

Was this helpful?

Export as PDF
  1. Voyage Management System
  2. VMS: Step-By-Step Guides
  3. Cargoes
  4. Create New Cargoes

Create Cargo by Importing from Excel

PreviousCreate Cargo on TC VoyagesNextCreate Cargo From Existing Cargo

Was this helpful?

Import Button

From this version, you can now can create cargo(es) by uploading/import straight from an Excel worksheet. In the cargoes list, you can click on this import button:

Import Cargoes from Excel

Then, you can follow these steps:

  1. Click on the Import button displayed above

  2. A modal (or "dialog box") will pop-up:

All the fields are disabled until you upload/import a supported file (only .xlsx and .csv files). You can only import one file at a time, but one file can consist of many cargo rows!

  1. You can proceed by clicking the blue Upload File button.

  2. After choosing a supported file from you computer, you can view the filename to the right of the Upload File button, along with a "preview screen" below all the now-enabled fields:

All the required fields (*) must be filled in this step. As you go along with choosing the different fields from the dropdown menus, the "preview screen" will mark with a light-blue highlight on the fields have been selected. Meaning, you could upload your own customized Excel sheet with various header- and cell values, but you can then in the modal pick-and-choose which fields you actually want on the cargo, when creating it.

Tip: it might be a good idea to change/create Header values in your Excel sheet by matching them to what we display in the above modal. E.g. Counterpart, Commodity, Cargo Quantity, Load Port, etc.

Remember that only the first row of your Excel sheet are the Header values! The rest are the cell values within their respective columns.

  1. You should now be able to see your newly created cargo at the top of the Unallocated cargoes list

Validations before Creating

We have two different types of validations in this modal. Either one, or both, of them will show up at the bottom of the modal, if encountering any inconsistencies while uploading:

(1) One is yellow-colored, and shows inconsistent data types in the cells of your Excel sheet:

This particular validation highlights the "Planned BL Date" column, and detects that two or more cells has inconsistent values within this column. E.g. one cell is read as a number value, while two cells are read as date values. In this case, the number-cell should be changed to a date value, so that the modal can read it properly as a date value. Make the change in your Excel sheet, and then re-upload the file.

This validation can highlight multiple columns with inconsistencies in data types, and not just one at a time.

(2) The other one is red-colored, and shows Reference or Master Data inconsistencies, i.e. data errors in your Excel sheet:

This particular validation highlights the "Commodity" column, and detects that "Row 2" within this column has a commodity named "Bananas" that does not exist in the system. In this case, you have two options:

a) replace "Bananas" with an existing Commodity in your Master Data, in your Excel sheet, and then re-upload the file

This validation can highlight multiple columns and rows with inconsistencies in Master Data or references, and not just one column and/or row at a time.

Requirements for Importing

Before actually creating a cargo by importing from an Excel worksheet, these requirements must be full-filled:

  • A supported Excel file must be uploaded/imported (only .xlsx and .csv files)

  • All required fields (*) must be filled in with supported values

  • No data types inconsistencies

  • No Master Data inconsistencies

  • No duplicate cargo references, or references to existing cargos

Once all of these requirements are full-filled, the Import button will be enabled, i.e. blue-colored, and you can then go ahead and create the cargo!

After choosing the different values into the fields, and you are full-filling all the below, then you can go ahead and create the cargo by clicking Import

b) create a new Commodity "Bananas" in your first, and then re-upload the file.

Master Data
requirements
Unallocated
Unallocated cargoes list with the Import button
Modal for importing unallocated cargoes form an Excel sheet
Modal after choosing a supported Excel file
Inconsistent data types validation message
Inconsistent reference or Master Data validation error message