...
By clicking icon under Manage menu, you will be switched to The Crew Change Module help manual.
Import Calling Ports
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).
For users who work with this functionality, an administrator should set up corresponding access rights for the routine 610 Import Itineraries in ACC:
...
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 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.
Prepare 'Import Ports' File
It is possible to import crew changes for the same vessel & the same date but with different time.
Step 1: You should input all necessary data into excel file, for example:
...
Column A: Vessel short name.
You can find it in Organization Structure > Vessel Properties > Identification:
...
...
Column B: Port code
You will find the port codes in Modules > Ports:
...
Column C: ETA date [yyyy-mm-dd] – mandatory date format
...
...
Column E: ETD date [yyyy-mm-dd] – mandatory date format
...
Column F: ETD time [hh:mm:ss] – mandatory time format
...
Column G: Preferred port [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
Step 2: Save this file in csv. format on your computer:
Click File:
...
Click Save As > This PC > select CSV (Comma delimited) format > click Save.
...