...
It is possible to import a batch of ports to Crew Change module using .csv file (see How to Prepare 'Import Ports' File section).It is convenient when you need to input big amounts of records (for example, to define Itineraries for several vessels for a year/several years)
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:
To import calling ports, you should open Crew Change > Calling Ports view and click Import button under Manage menu:
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 (;).
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.
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.
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.
You can click Summary button to check Import Log.
Click Close button.
For the itineraries to be successfully imported, both ETA and ETD dates are mandatory. If one of the dates is missing, the itinerary is not imported. In case dates are available in the import file, but time of ETA and/or ETD is missing, then the record is imported with 00:00:00 for the ETA, and 23:59:59.99 for the ETD.
How to prepare an import
It is possible to import crew changes for the same vessel & the same date but with different time.
...
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 |
|
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
Select all values in column > right-click > Format Cells.
Date category > [yyyy-mm-dd] type > OK
...
ETA/ETD Time
Select all values in column > right-click > Format Cells.
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:
Click File:
Click Save As > This PC > select CSV (Comma delimited) format > click Save.
