Skip to main content
Version: 2.2.0

ASDOWNTIME - Downtime record import

This import template allows:

  • Starting a downtime record;
  • Finishing a downtime record.

For the insertion of each one of these items, the standard documented below must be followed.

Insert asset type security data

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
106 - Code of the SoftExpert Asset component
FGOPTIONXNUMERIC2Code of the operation to be performed:
23 - Start a downtime record;
24 - Finish a downtime record.
NMFIELD01XTEXT255Asset ID #. Separate with ";" if multiple assets are added. Example:
Asset_1;Asset_2;Asset_3
NMFIELD02TEXT255Downtime reason ID #
NMFIELD03TEXT255Downtime start date. The expected format must be YYYY-MM-DD (Year-Month-Day).
If this is an import via spreadsheet, format the cell as text; otherwise, the import will not be successful.
NMFIELD04TEXT255Downtime start time
NMFIELD05TEXT255Downtime end date. The expected format must be YYYY-MM-DD (Year-Month-Day).
If this is an import via spreadsheet, format the cell as text; otherwise, the import will not be successful.
NMFIELD06TEXT255Downtime end time
DSFIELD01TEXT4000Comment
info

Note:

  • X¹ - Required if the "FGOPTION" field is equal to 23.
  • X³ - Required if the ``"FGOPTION" field is equal to 23, and/or the "Start date" and/or "Start time" fields are completed.
  • X³ - Required when the "FGOPTION" field(s) is(are) equal to 24 and/or the “End date” and/or "End time" is(are) filled.