Description

The import can be found under Tools > Import > Activities.

The data must be separated by one of the allowed separators: semicolon (;), comma (,), tab symbol, vertical line (|), or character with code 255.

An example of an import file:

PIN;ALTERNATIVEPIN;CODE;RANK;NUMORGID;DATEFROM;DATETO;PLACEFROM;PLACETO;DAYS;LEAVEDAYS;PAYSCALETABLE;PAYSCALECODE;COSTPLACE
123456;98765;ONB;MAS;100045;20050625;20050831;HOUSTIN;ROTTERDAM; 

Notes

1. Dates should follow a format YYYYMMDD.
2. Please include the NUMORGID field in an import file in order to link an activity to a corresponding organization unit.
3. If an option Archive is selected, an import file will be renamed and moved to a corresponding folder after import.
4. If an option Skip entry with an existing correspondent entry is selected, the utility will check whether an activity with such data exists already and in this case does not create a new one.

Open

After clicking OK you will be shown a list of the columns extracted from the import file. Click OK. If during import the utility cannot recognize an activity code or rank, you will be suggested selecting a code or a rank from a corresponding list.

__________________________________________________________________________________________

The below columns are available for import. Columns in bold are mandatory. As an option to PIN it is possible to use ALTERNATIVEPIN.

PIN
ALTERNATIVEPIN
CODE
RANK
NUMORGID
DATEFROM
DATETO
PLACEFROM
PLACETO
DAYS
LEAVEDAYS
PAYSCALETABLE
PAYSCALECODE
COSTPLACE,
VESSEL,
ACTIVITY_GROUP,
CERTIFICATE_DATE,
COMMENT,
SIGN_OFF_REASON

NOTE: Starting from version 2.40, all the changes are rolled back and the import is considered failed if some error occurs during import (for example, import files contain incorrect data). Every time import takes place a result is recorded into the database. It indicates if the import was successful and which file was imported. A user is not allowed to import the same file more than once.

Version 2.40 introduces a new option "Close non-sea-service activities during import". If it is selected in the Global Settings (Database > Maintenance > Global Settings), Modules And Datagroups, Activities, all the current (without a date to) non-sea-service activities and activities with code "EOC" will be closed during import, and the date to will be equal to the date from of the imported file.