Problem/Goal/Question. A few sentence about this, whats the problem/goal and why this article is important. Then more indebt information if needed. 

Import Activities (Tools > Import > Activities)

The utility provides a swift way of importing activities from an external CSV file. The file should contain one header line that lists columns titles and then lines with information about activities in a corresponding order. Pieces of information are to be separated by one of 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; etc

Note:
1. Dates should follow a format YYYYMMDD.
2. Please include 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 entries with 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.

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.

__________________________________________________________________________________________

An import file should contain one or more of the columns listed below. Please note that normally you should include at least columns PIN (or ALTERNATIVEPIN), CODE, RANK, NUMORGID.

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 the 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-seaservice activities during import". If it is selected in the Global Settings (Database > Maintenance > Global Settings), Modules And Datagroups, Activities, all the current (without date to) non-seaservice 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.