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.
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.
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 | |
| City | Place | |
| PostalCode | Postcode | |
| Country | Address Country | |
| 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 | |
| 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.
|
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.
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:
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:
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 add the codes used by Resco 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 same count for the familiarization courses and drills downloaded from Resco. These familiarization courses and drill need to be linked to an Adonis Certificate or Course.
Monitoring Surveillance
Status last execution.
To retrieve the latest interface execution status, open the replicator monitor
In the left pane select the Resco 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 Resco plug in is installed you find the log file containing the status of the last 4 weeks of execution.
Open the file rescoint.log using notepad, and you find the latest entries at the bottom of the log file.