This import tool is used to import competences from an external source.
Preparation
Access
To access the utility, the user needs to have Write access to the routine 890 Import Competencies in Adonis Control Centre.
File format
Imported file must be of format .csv or a usual txt file.
If the file is a txt file the extension has to be .apm
| Field no | Field name | Comment | ||
|---|---|---|---|---|
| 1 | PIN | Mandatory | This field links the competence to a crew member. Imported value must exist in pw001p01 table | |
| 2 | CREATEDBY | Field to identify who added the competence to a pin (max 6 chars) | ||
| 3 | CREATETIME | YYYY-MM-DD HH:MM:SS | Field to identify when the competence was added to a pin | |
| 4 | CHANGEDBY | Field to identify who modified the competence record (max 6 chars) | ||
| 5 | HISTORICAL | Not displayed in APM. Can be used as internal flag | ||
| 6 | GROUPNO | Not displayed in APM. Can be used as internal grouping number. | ||
| 7 | CLIENTNO | Not displayed in APM. Can be used as internal grouping number. | ||
| 8 | SEQUENCENO | Not displayed in APM. Can be used as internal counter. | ||
| 9 | NOT IN USE | Not in use | ||
| 10 | UPDATEFLAGS | Not displayed in APM. Can be used as internal flag. | ||
| 11 | DATEFROM | YYYY-MM-DD | The date the competence was issued | |
| 12 | DATETO | YYYY-MM-DD | Free date input, e.g. to store the date when the certificate was emitted | |
| 13 | CODE | Mandatory | Max 10 chars | The code of the competence as in General Codes | Competence Codes. |
| 14 | ISSUEDBY | Max 10 chars | Free input to define the name of the issuer | |
| 15 | ISSUEDPLACE | Max 50 chars | Free input to define the place of issuer | |
| 16 | CNUMBER | Max 50 chars | Free input to define the number of document | |
| 17 | EXPIRYDATE | YYYY-MM-DD | The date the competence will expire | |
| 18 | COMMENTS | Max 250 chars | Free input for comments | |
| 19 | PLANNED | Y or N | Defines whether the competence state is planned or historical | |
| 20 | VALIDINCOUNTRY | ISO 2 Char | Country code if the competence has limited value | |
| 21 | RANK | Max 10 chars | Rank code of a crew member to link a competence to. The Rank code used must be defined in General codes - Personal Details | Ranks | |
| 22 | SCANNEDDOCNO | Sequence number of scanned document in the database. | ||
| 23 | SCANVALIDITY | Y or N | Defines if there exists a valid scan attached to the record or not | |
| 4 | EXPIRYNOTIFICATIONDATE | Not displayed in APM. Can be used as internal date. | ||
| 25 | NUMORGID | Define ID of the company or vessel. The imported number must correspond to the "Internal numorgid" found on company or vessel in the organization structure | ||
| 26 | ROUTE | Max 10 chars | Vessel location. The imported value must exist in General Codes - Replication Routes | Replication Route |
Step-by-Step import
When the file is prepared you are ready to import the file as follows:
- Go to Tools | Import | Competences
- In the dialogue window chose the following
- Filename - Fetch the file from where you have saved it
- Chose the separator used in the file. This can vary depending on the regional settings on the user's computer.
- Chose if you want to skip importing a record if the system finds that the person has an existing competence with same code. Note that this only checks the code and not the date from and expiry date of the record.
- Chose if the file should be Archived after the import.
- Click OK
- In the LogFile in the Dialogue window you can see if the import succeeded or if there were any errors.