Import Person

Owned by Sigrid Kviteberg
Last updated: Apr 11, 2024 by Daria Chebotaieva

The article explains how to import a .csv file that will create a new person or update an existing person. 

Description

The import routine can be found under Tools | Import | Persons

If importing data to an existing person it is important to be aware that a column containing a blank value will also overwrite the field when imported. E.g. a person who has data in Address line 1, however, ADDRESS1 is a column in the import but has a blank value. This will then overwrite existing data. 

Available Fields

Personal Details (table pw001p01)

PIN (integer)
CREATEDBY (6 symbols)
CREATETIME (DateTime)
NAME (180 symbols)
ADDRESS1 (40 symbols)
ADDRESS2 (40 symbols)
ADDRESS3 (40 symbols)
PERSONALIDNO (20 symbols)
SEX (1 symbol) - please use F/M
POSTCODE (100 symbols)
POSTPLACE (100 symbols)
INITIALS (15 symbols)
NATIONALITY (3 symbols)
DEPARTMENTCODE (10 symbols)
MANAGENTCODE (10 symbols)
UNIONCODE (10 symbols)
PERSONGROUPCODE (10 symbols)
CATHEGORYA (integer)
CATHEGORYB (integer)
CATHEGORYC (integer)
BIRTHDATE (DateTime)
DEATHDATE (DateTime)
EMPLOYMENTSTARTDATE (DateTime)
EMPLOYMENTENDDATE (DateTime)
RANK (10 symbols) - please note that the imported value must exist in General Codes -> Rank
DIVISION (integer)
CONTRACTSTARTDATE (DateTime)
CONTRACTENDDATE (DateTime)
CONTRACTEXPIRYDATE (DateTime)
PINDEFAULTRELIEF (integer)
CURRENCY (3 symbols) -
LEAVEPAYFACTOR (10 symbols)
BANKACCOUNTNO (35 symbols)
TRANSFERBALANCE (2 symbols)
HAIRCOLOR (10 symbols)
EYECOLOR (10 symbols)
HEIGHT (interger)
WEIGHT (interger)
TERMOFNOTICE (interger)
PLACEOFBIRTH (35 symbols)
MARITALSTATUS (10 symbols)
HOMEAIRPORT (60 symbols)
TRAVELTIME (12 symbols)
MARITIMEOFFICE (20 symbols)
BLOODGROUP (5 symbols)
EYESIGHT (10 symbols)
ALLERGY (25 symbols)
EXTERNALCOMPANY (15 symbols)
QUICKSELECTIONSWITCHES (20 symbols)
SEQUENCENO (integer) - used as a counter. Must be unique
UPDATEFLAGS (125 symbols)
SITEID (integer) - the internal number of the installation site to which a person belongs, e.g. 1 for office, 11-15 for vessels.
CLIENT (integer) - the code corresponding to field NUMORGID of an organization unit (concern/company/vessel etc)
UPDATEDTIME (DateTime)
UPDATEDBY (6 symbols)
PICTURENO (integer)
ALTERNATIVEPIN (15 symbols)
ADDRESS_COUNTRY (2 symbols)
DEATHPLACE (20 symbols)
DEATHREASON (20 symbols)
CONTRACTTYPE (10 symbols)
STOPREASON (60 symbols)
SHIFTCODE (10 symbols)
SHIFTSTART (DateTime)
SHIFTVESSEL (integer)
CREWPOOL (10 symbols)
PAYROLLSTATUS (10 symbols)
PAYROLLTYPE (10 symbols)
TELEPHONE (100 symbols) - normally it is better to use one of fields from Telecommunication section (see below)
LEAVEDAYSFROMDATE (DateTime)
WORKINGSPOUCE (1 symbol) - please use Y/N
NOOFDEPENDANTS (2 symbols)
CURRENCYFORPAYMENT (3 symbols)
COSTPLACE (10 symbols)
TURNUSCODE (10 symbols)
SRCNO (25 symbols)
FIRSTNAME (50 symbols)
MIDDLENAME (50 symbols)
LASTNAME (50 symbols)
MAIDENNAME (30 symbols)
CALLINGNAME (30 symbols)
TITLENAME (15 symbols)
SUFFIXNAME (15 symbols)
PAYROLLVSL (integer)
COUNTRYOFBIRTH (2 symbols)
OTHERCITIZENSHIP (2 symbols)
AADDRESS1 (40 symbols) - additional address field under the Other folder
AADDRESS2 (40 symbols) - additional address field under the Other folder
AADDRESS3 (40 symbols) - additional address field under the Other folder
APOSTCODE (100 symbols) - additional post code field under the Other folder
APOSTPLACE (20 symbols) - additional post place field under the Other folder
AADDRESS_COUNTRY (2 symbols)
PORTSIGNON (20 symbols)
PORTSIGNOFF (20 symbols)
COSTGROUPCHANGEDATE (DateTime)
HOMEAIRPORT2 (60 symbols)
HOMEAIRPORT3 (60 symbols)
TRAVELTIME2 (12 symbols)
TRAVELTIME3 (12 symbols)
repl_ModifiedBySite (integer) - field for following up replication data
repl_ModifiedDate (DateTime) - field for following up replication data
REPL_GMTMODIFIEDDATE (DateTime) - field for following up replication data
EMAILPAYSLIP (1 symbol)
NOPAPERCOPY (1 symbol)
SHIFTEND (DateTime)
SESSIONID (integer) - field used for audit purpose
DBACTION (10 symbols) - field for storing database actions like INSERT/UPDATE
AUDIT_LINENR (integer) - field used for audit purpose
ADDRESS_STRNR (5 symbols)
AADDRESS_STRNR (5 symbols)
SMOKER (1 symbol) - please use Y/N
RELIGION (10 symbols)
PANTSKIRTSIZE (10 symbols)
SHIRTBLOUSESIZE (10 symbols)
SHOESIZE (10 symbols)
PPE_BOILERSUITE (10 symbols)
PPE_SAFETYSHOES (10 symbols)
PPE_HELMET (10 symbols)
PPE_SSUITE (10 symbols)

Passport details (table PW001P08)

PASSPORTCODE
PASSPORTNO
PASSPORTISSUEDATE
PASSPORTISSUEBY
PASSPORTEXPIRYDATE

Seamans' Book

SEAMANBOOKCODE
SEAMANBOOKNO
SEAMANBOOKISSUEDATE
SEAMANBOOKISSUEBY
SEAMANBOOKEXPIRYDATE
SEAMANBOOKISSUEPLACE

Telecommunication (PW001P0T)

OFFICEPHONE
OFFICEFAX
HOMEPHONE
MOBILEPHONE
TELEX
SATCOM
EMAIL
WEB

Notes (PW001P0N)

COMMENT LINE1
COMMENT LINE 2

Payroll (PW001P0Y)

Employment (PW001P0P)

Wages (PW001P0W)

Important Details

  1. If there the import fails, all the changes are rolled back and the import is considered failed. Every time an import takes place a result is recorded in 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.

  2. You should not use ' symbols, you can use either " symbols or not use quotes at all.

  3. If the Client field is not a part of the import - the imported person will be linked to the organization unit that is the current Open Client.

  4. It is possible to import persons using the Alternative Pin instead. If you do not define a pin in your import file, the system will check persons by alternative pins. If no person with such an alternative pin exists, a new person will be created, and a new pin according to the rules of Adonis Control Centre (standard when creating a new person) will be assigned to him, and he will get the alternative pin from the import file. If a person with such an alternative pin already exists, the record will be updated.