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

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:

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.

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	You will find the port codes in Modules > Ports:
Column C	ETA date	Y	yyyy-mm-dd - mandatory date format
Column В	ETA time	N	hh:mm:ss - mandatory time format
Column У	ETD date	Y	yyyy-mm-dd - mandatory date format
Column F	ETD time	N	hh:mm:ss - mandatory time format
Column G	Preferred port	N	[Y] or [N]