Skip to content

Can I upload an excel file with containers to load to a BAPLIE?

Yes. If you have an Excel spreadsheet with containers to load (also called a load list or loading plan), first make a BAPLIE file from it. Then add its containers to your BAPLIE in Move mode in 2D Bay View.

Before you start: Move mode needs the Vessel Operations add-on for your facility and Admin or Edit permission.

Step 1: make a load list BAPLIE with Import Excel

Section titled “Step 1: make a load list BAPLIE with Import Excel”
  1. Log in to your BAPLIE Viewer Online account.
  2. In the Function Menu on the left, open Import Excel.
  3. Follow the steps on the screen. For the details, see How to create a BAPLIE file from an Excel spreadsheet.

The spreadsheet needs at least these columns: container number, ISO code, carrier, status, POL (port of load), POD (port of discharge) and weight.

Step 2 of Import Excel: the list of information the worksheet must contain and the Choose File button

If your spreadsheet has no position column, map the position to a blank column. The system warns you that Bay Position should be 7 characters. Click Proceed to ignore these warnings.

  1. In the Function Menu, upload the BAPLIE file you want to change, or open it from the files that you already uploaded.
  2. Open Visualization and click 2D Bay View. In the Mode list, choose Move. For the details, see How to use the Move Containers feature in 2D Bay View.
  3. Click Load New. Then click From Previously Uploaded File.
  4. Choose the load list BAPLIE that you made. Click Add Containers To Stow List.
  5. All containers of the load list show in the Containers to move list on the right. Click a container in the list, or type an equipment ID in the FILTER BY… box to find one. Then click an empty slot in the bay to put the container there.
  6. Click FINISH in the top menu to update your BAPLIE file.