Skip to end of banner
Go to start of banner

Import Calling Ports/ Itineraries

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 9 Current »

Contents

Introduction

It is possible to import a batch of ports to Crew Change module using .csv file (see How to Prepare 'Import Ports' File section).

The purpose of this import functionality is to provide you an option to import future calling ports for many/all vessels in one batch job.

If the actual calling port is not known, you will need a corresponding Port Code in the system e.g. like TBD, meaning To be decided. Are you using Helicopter Shift?, the Port Code needs to reflect your code for helicopter shift.

For users who work with this functionality, an administrator should set up corresponding access rights for the routine 610 Import Itineraries in ACC:

How to import:

  1. To import calling ports, you should open Crew Change > Calling Ports view and click Import button under Manage menu:

  2. In the window that appears, please select the File Name you are importing, define a column separator. The field separator in the file can be a comma (,) or semicolon (;).

  3. You can select the option Skip first row, if you don't want the first row to be imported. For example, if the first row in the import file shows columns names.

  4. Click Import button to start importing or Close to cancel. When the Import button is clicked, the program checks if all port and vessel codes are valid.

  5. When the import is completed successfully, you'll see corresponding message. If one or several codes are invalid, the system lists them and skips the import.

  6. You can click Summary button to check Import Log.

  7. Click Close button.

How to prepare an import

It is possible to import crew changes for the same vessel & the same date but with different time.

To do this you need to create an excel file for import, for example:

Here are the fields available for import. Some are mandatory, some are not.

Column

Description

Mandatory (Y/N)

Value

Column A

Vessel short name

Y

You can find it in Organization Structure > Vessel Properties > Identification.

Сolumn B

Port code

Y

  1. You will find the port codes in Modules > Ports:

Column C

ETA date

Y

yyyy-mm-dd - mandatory date format

Column В

ETA time

Y

hh:mm:ss - mandatory time format

Column У

ETD date

Y

yyyy-mm-dd - mandatory date format

Column F

ETD time

Y

hh:mm:ss - mandatory time format

Column G

Preferred port

N

[Y] or [N]

How to set correct date/time format in batch

ETA/ETD Date

  1. Select all values in column > right-click > Format Cells.

  2. Date category > [yyyy-mm-dd] type > OK

ETA/ETD Time

  1. Select all values in column > right-click > Format Cells.

  2. Custom category > define correct type = [hh:mm:ss] > OK

How to save an import file

The import file should be saved in csv. format. To save:

  1. Click File:

  2. Click Save As > This PC > select CSV (Comma delimited) format > click Save.

  • No labels