Description
The DA-Payroll statistics is implemented as an APM plugin. How to install the plug in see section Houskeeping below. The following requirements are implemented.
Compatible
Compatible with APM 2019.50 or higher*
*Requires cross reference table; PW001P01_XREF
Location
After installing the plug-in the plug in is available in the following location
Tools > Export > DA Payroll Statistics
User Interface
Houskeeping
Interface:
The DA_Payroll Statistics plug ins uses the following interfae definitions:
| Interface Code | Description |
|---|---|
| DA_STAT | General interface |
| DA_ | |
To define the interface goto:
Setup > General Codes > Interfaces
DADFDS
ADFSA
ADF
D
Download the Plug-In
http://download.adonis.no/files/upgrade/PersonnelManager/Plugins/Replicator/APL/
UpdatePack_APL_2020.01.10.1.cab
Installing the plugin
See : Installing and distributing the Replicator plug-in
Plugin Parameters
A plug-in will request certain parameters like authentication details, server url, names etc. These parameters are different from plug-in to plugin, before scheduling the plug-in the administrator need to set the correct parameters.
- In the right Panel of the replicator manager expand the plug-in and select plugin parameters
In the right-hand screen select the site and add the parameters manually. 
Plugin specific parameters for the Apollo Interface
Below you find the plugin specific parameters, note the parameters are case sensitive.
Parameter | Description |
|---|---|
CLIENTID | Authentication parameter (ADONIS_Crew) |
CLIENTSECRET | Authentication parameter (Contact Apollo) |
COMPANYCODE | Authentication parameter (Contact Apollo) |
DATABASE | Adonis Database |
SERVER_NAME | Database Server |
| XREF_SEASERVICE | XREF Code identifying the seaservice |
| XREF | Interface name. |
| DAYSAHEAD | Number of days the interface should "look ahead" to identify crew members that are planned to go onboard. |
| STARTDATE | Possible to give particular start date from which the system should select crew members. Should only be used to synchronize both systems during the initialization phase. Leave blank after synchronizing both systems. . |
| RESETDATE | Parameter used during the initializing or if a full download is needed 1 - reload all data from APOLLO yyyy-mm-dd (e.g. 2019-01-15) - reload all modification given after a particular date. Use this after restoring APM and repopulate the database with the lates Apollo information. |
Cross reference (XREF) Setup
In Adonis the functionality exist to link all general code and levels in the organization structure to a 3rd part code. Before starting the plugin the Administrator need to add Apollo XREF codes.
In the general codes > Interfaces
Create the a new interface Apollo, Add this to the Plugin parameter XREF.
This is used by the plugin to determine which XREF codes to use.
The following XREF Codes are used:
General Codes: Color, Ranks, Competences, Travel Documents
Organization Structure: Company, Vessel
Monitoring Surveillance
Status last execution.
To retrieve the latest interface execution status, open the replicator monitor
In the left pane select the Apollo interface plugin in the status menu. It is located directly below the Adonis Replicator status. In the right pane you will find the status of the last execution.
Execution Log:
In the directory where the Apollo plug in is installed you find the log file containing the status of the last 4 weeks of execution.
Open the file aplint.log using notepad, and you find the latest entries at the bottom of the log file.
Reset the replication
Run the following SQL
UPDATE PWINTERFACETASK
SET LastImport= NULL
WHERE TASK='APOLLO_TASK' and SiteNr=<site# of active site>
This update statement will force the system to import all information from Apollo.