Versions Compared

Old Version 8

changes.mady.by.user Daria Chebotaieva

Saved on

compared with

New Version Current

changes.mady.by.user Daria Chebotaieva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Table of Contents
minLevel1
maxLevel1

Description

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

Info

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)

Expand

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)

Expand

PASSPORTCODE
PASSPORTNO
PASSPORTISSUEDATE
PASSPORTISSUEBY
PASSPORTEXPIRYDATE

Seamans' Book

Expand

SEAMANBOOKCODE
SEAMANBOOKNO
SEAMANBOOKISSUEDATE
SEAMANBOOKISSUEBY
SEAMANBOOKEXPIRYDATE
SEAMANBOOKISSUEPLACE

Telecommunication (PW001P0T)

Expand

OFFICEPHONE
OFFICEFAX
HOMEPHONE
MOBILEPHONE
TELEX
SATCOM
EMAIL
WEB

Notes (PW001P0N)

Expand

COMMENT LINE1
COMMENT LINE 2

Payroll (PW001P0Y)

Expand

LEAVEPAY
PAYROLLPERIODLOCK
LAYOUTSLIP
REGIONTAXADVANCE
TAXTABLE
TAXPERCENTAGE
TAXDEDUCTIONCODE
TAXFREELIMIT
SEAMANSALLOWANCE
WAGESOPTIONS
DAYSEMPLOYED
LEAVEPAYSTARTBALANCE
PAYCOUNTRY
PAYSWIFTCODE
PAYNAME
PAYADDRESS1
PAYADDRESS2
PAYADDRESS3
PAYPOSTCODE
PAYROLLNATIONALITY

Employment (PW001P0P)

Expand

POSITIONID
SENIORITYSTARTDATE
SENIORITYSTARTDATE
SENIORITYSTARTDATE
SENIORITYENDDATE
SENIORITYENDDATE
SENIORITYENDDATE
SENIORITYYEARS
POSITIONFRACTION
PAYSCALETABLE - validation for existing setup values
PAYSCALECODE - validation for existing setup values

Wages (PW001P0W)

Expand

WAGEPERMONTH
WAGEPERHOUR_B
WAGEPERHOUR_C

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.