Versions Compared

Key

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

Description

Data sync between APM and Resco

Latest Version

2023.1020.0.1011

Release Date

Download Path

Download

Type

Replicator Plugin

Description

Res Company is a leading provider of reservation and property management systems tailored specifically to suit the needs of the cruise industry. For more information see :  https://rescompany.com

The objective with this interface is reduce the workload to only have one point of data entry, and eliminate the need to update / insert the same information in both Adonis and Resco

This interface is designed to be used onboard and executed as Replicator Plugin. 

Table of Contents
minLevel1
maxLevel7
excludeContents

Change Log: 

Expand

Version

Date

Description

2023.20.0.11

 

The PW001P05 counter will be used to generate SEQUENCENO for a new competence record

Process Flow

Adonis is the master system with regards to maintaining crew data, Information maintained in Resco is are the familiarization and introduction courses.  This can be course like know your ship to specific position introduction courses like:  How to behave in the Dining room. 

Info

Onboard Drills

Information and functionality related to onboard drill / Crew Station bills exist in Adonis. The information flow from Resco to Adonis is optional


Planned vs Current

A crew members information is send from Adonis to Resco when is planned to come onboard in the next 20 days from today and his data will be synchronized until the person actually signs off. The 20 days are defined by the plugin parameter DAYSGAP


Adonis - > Resco

Crew

Source: Datagroup Personnel Details

Resco Field

Adonis

Comment

CrewNo

PIN

Padded with 0's if length is less then 6

ExternalId

PIN


PositionId

XREF value of position in organization

See housekeeping section

EmbarkDate

Seaservice activity date from


EmbarkPort

Crew change port Sign On List


DisembarkDate

Seaservice DateTo if null then Seaservice Estimated End Date


DisembarkPort

Crew Change Port Sign on List


FirstName

First name


LastName

Last Name


Gender

Sex


Height

Height


Weight

Weight


EyeColor

XREF for Color

See housekeeping section

HairColor

XREF for Color

See housekeeping section

MaritialStatus

XREF for marital status code

See housekeeping section

BirthDate

Birth Date


BirthPlace

Birth Place


Nationality

nationality ISO 3166-1 alpha code for


SONReasonID

XREF code for embarkation reasons

See housekeeping section

SignOffReasonID

XREF code for disembarkation reasons

See housekeeping section

Picture

PassPhoto (BASE64)



Address

Source: Datagroup Personnel Details

Resco Field

Adonis

Comment

Type

'H'

Identifying home address

Street

Address1
Address2


City

Place


PostalCode

Postcode


Country

Address Country


Email

Teleno

Teletype=7

Phone

Teleno

Teletype=2

Mobile

Teleno

Teletype03

Emergency Contact Information 

Source: Datagroup Next of Kin

Resco Field

Adonis

Comment

Fullname

Name

Depending on the global options this can exist out First and last name or Title Last Name, Firstname

Street

Address 1


Relation

Relation Text

Relation text as defined in general codes

City

Place


PostalCode

PostCode


Country

Country


Email

Teleno

Teletype=7

Phone

Teleno

Teletype=2

Mobile

Teleno

Teletype=3

Medical Certificate Information

Source: Datagroup Medical 

To identify the medical certificate codes identifying Medical, Foodhandling, Cholera, YellowFever, and Smallpox, the interface uses the XREF Code to find the correct Certificate. 


Resco Field

Adonis

Comment

MedicalExpiryDate

expirydate

Identified with XREFCODE MEDICAL

FoodHandlingExpiryDate

expirydate

Identified with XREFCODE FOODHNDL

VaccinationDateCholer

expirydate

Identified with XREFCODE CHOLERA

VaccinationDateYellowFever

expirydate

Identified with XREFCODE YELLOW

VaccinationDateSmallPox

expirydate

Identified with XREFCODE SMALLPOX

Travel Documents

The following documents are exported Passport, Seamansbook, one or more VISA'S. 

Seamansbook and Passport are identified by the 'travel document' document type: Passport and Visa 

The visa travel document codes are identified XREF Code VISA. All travel document where the XREF code equals VISA are exported as visa documents. 

For the passport, seamansbook and all visa's the following data is exported; 


Resco Field

Adonis

Comment

DocumentId

Document No


IssueDate

Date Issued


IssuePlace

Issued Where


IssueCountry

Issue Country


ExpiryDate

Expiry Date


Multiple Certificates / Competences

All Competence codes linked to a Resco XREF where the XREF Code can be found in Resco are exported. 

For each competence record the following information is exported: 

Resco Field

Adonis

Comment

IssueDate

Date from


IssuePlace

Valid In Country

The interface exports the country name. Resco has not country link in the multiple certificates.

ExpiryDate

Expiry Date


ResourceExternalId

Scanned doc no id

Resco will use an API call to display the external document.

Resco - > Adonis 

Training (Familiarization courses) 

Target: Datagroup Competences

Resco Field

Adonis

Comment

Code

XREF.CODE

The XREF code is used to find the competence code to be used when adding / updating a record in the competence datagroup

SessionDate

Date from


SessionDate + Duration

Date to

this identifies the length fo course. Duration is measured in minutes

Expiry

EXPIRYDATE

If Expiry=S then use the Seaservice Date to or Seaservice Todateestimated

Else use DateFrom + the Default Expiry Date retrieved from the competence definition.

Image Modified


Houskeeping

Download the Plug-In

http://download.adonis.no/files/upgrade/PersonnelManager/Plugins/Replicator/RSC/

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 Resco Interface

Below you find the plugin specific parameters, note the parameters are case sensitive. 

Parameter

Description

Server

Name of the SQL Server

Database

Adonis Database

WSUser

"User Name" Resco Service

WSPassword

"Password" Resco Service

WSUrl

URL Resco Service.

XREF

Interface name used in Adonis to identify the XREF Codes.

DAYSGAP

Interval in days from today's date in which the system will detect planned seaservices.

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 Resco XREF codes. 

In the general codes > Interfaces
Create the a new interface RESCO, Add this to the Plugin parameter XREF.

Image RemovedImage Added

  

This is used by the plugin to determine which XREF codes to use.  

The following XREF Codes are used: 

Marital Status: 
Identify  by using the XREF Code which Adonis Marital status identifies; 

Divorced, Single, Married and Other using the following XREF codes: 
D,S,M AND O

Sample:

Image RemovedImage Added


Position/Ranks

In the general code; Ranks,  each Rank that is linked to a position onboard need to be linked to rank code used in Resco.

Sample:

Image RemovedImage Added

Medical Certificate

To identify the medical certificate codes identifying Medical, Foodhandling, Cholera, YellowFever, and Smallpox, the interface uses the XREF Code to find the correct Certificate. 

The medical certificates in Resco is not implemented in a table structure but are implemented as fixed fields.  To find the correct expiry dates for each medical certificate the following XREF codes are used by the plugin.

Xref Code

Resco Field

MEDICAL

MedicalExpiryDate

FOODHNDL

FoodHandlingExpiryDate

CHOLERA

VaccinationDateCholera

YELLOW

VaccinationDateYellowFever

SMALLPOX

VaccinationDateSmallPox

Sample: 

Travel Documents

To identify the visa documents, add the word VISA in the XREF comment field and the codes Resco used in the XREF.CODE field.  

Competences and On-board familiarization courses

All competence records that are part of the interface need to be linked to the corresponding Resco Code. The exact count for the familiarization courses and drills downloaded from Resco.  These familiarization courses and drills must be linked to an Adonis Certificate or Course.

Image RemovedImage Added

Monitoring Surveillance

Status last execution.

To retrieve the latest interface execution status, open the replicator monitor 

Image RemovedImage Added

Select the Resco interface plugin in the status menu in the left pane.  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 Resco plug-in is installed, you find the log file containing the status of the last four weeks of execution.   

Open the file rescoint.log using notepad, and you find the latest entries at the bottom of the log file.

  




Panel
titleRelated Pages
Filter by label (Content by label)
showSpacefalse
cqllabel in ( "replicator" , "plugin" , "oracle" , "resco" ) and space = currentSpace ( )