...
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.
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.
