Skip to main content

CertificatesList

General

This part is used to load all information about drillscertificates in MXSuite.  The sheet is called “SafetyList”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 drillcertificate is connected
Name 128 X Name of the drillcertificate
SignOffTemplateNumber 1024128 X IfThe therenumber are questions that need to be filled when signing off a drill, writeof the questions here certificate
IsFixedIntervalCertificateType

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

If the drill has a fixed interval, set this option True.  Otherwise, fill in option as False.  Reference this link for more explanation
IntervalValue
X If the drill has a time interval, fill in here the value of days/week/months. IntervalType
X

Fill in here the type of interval.  Possible values are:

    Days Weeks Months StartPeriodValue
    X

    Fill here the number of days when the drill can be done before the duedate

    StartPeriodType
    X

    Fill in here the type of interval.  Possible values are:

      Days Weeks Months DueDateRenewalAfterIntervalType


      DateOfIssue

      The due date of the drill. Written in the date-time formatissue of the PCcertificate that importstheDateOfExpiry file


      BirthDateOfShip


      BeforeAnnualIntervalValue


      BeforeAnnualIntervalType


      AfterAnnualIntervalValue


      AfterAnnualIntervalType


      BeforeIntermediateIntervalValue


      BeforeIntermediateIntervalType


      AfterIntermediateIntervalValue


      AfterIntermediateIntervalType


      BeforeNoneIntervalValue


      BeforeNoneIntervalType


      BeforeLastSurveyIntervalValue


      BeforeLastSurveyIntervalType


      Storage


      Comment


      Example

      image.pngimage.png