Skip to main content

CertificatesList

General

This part is used to load all information about certificates in MXSuite.  The sheet is called “CertificatesList”.

Details fields

To fill the Excel file correctly, ensure that all fields are completed accurately. Below are the fields listed.

Field MAX Characters  Required Comment
Category 128 X Name of the category to which the certificate is connected
Name 128 X Name of the certificate
Number 128 X The number of the certificate
CertificateType
X Here can be given if an annual or intermediate survey is needed for this certificate.
In case that an annual as well as an intermediate survey is needed, enter both values
comma-separated like in the second example below.
Possible values are:
- None
- Annual
- Intermediate
- Annual, Intermediate
RenewalAfterValue


RenewalAfterIntervalType


DateOfIssue

The date of issue of the certificate (dots, but nl-NL)
DateOfExpiry


BirthDateOfShip


BeforeAnnualIntervalValue


BeforeAnnualIntervalType


AfterAnnualIntervalValue


AfterAnnualIntervalType


BeforeIntermediateIntervalValue


BeforeIntermediateIntervalType


AfterIntermediateIntervalValue


AfterIntermediateIntervalType


BeforeNoneIntervalValue


BeforeNoneIntervalType


BeforeLastSurveyIntervalValue


BeforeLastSurveyIntervalType


Storage


Comment


Example

image.png