This import template makes it possible to:
▪Start a downtime record; ▪Finish a downtime record.
To insert each of these items, it is necessary to follow the standard documented below.
Insert security data of the asset type
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
Sequential code - Identifies an item to be imported into SoftExpert Suite.
|
FGIMPORT
|
X
|
NUMERIC
|
2
|
Import status:
1 – New;
2 – In progress;
3 – Finished;
4 – Error.
|
CDISOSYSTEM
|
X
|
NUMERIC
|
10
|
System code where the integration will be performed to:
106 – Asset component code
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
23 – Start a downtime record;
24 – Finish a downtime record.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Asset ID #. Separate with ";" if multiple assets are added. Example:
Asset_1;Asset_2;Asset_3
|
NMFIELD02
|
X¹
|
TEXT
|
255
|
Downtime reason ID #
|
NMFIELD03
|
X²
|
TEXT
|
255
|
Downtime start date. The expected format must be YYYY-MM-DD (Year-Month-Day).
If this is an import via spreadsheet, format the cell as a text; otherwise, the import will not be successful.
|
NMFIELD04
|
X²
|
TEXT
|
255
|
Downtime start time
|
NMFIELD05
|
X³
|
TEXT
|
255
|
Downtime end date. The expected format must be YYYY-MM-DD (Year-Month-Day).
If this is an import via spreadsheet, format the cell as a text; otherwise, the import will not be successful.
|
NMFIELD06
|
X³
|
TEXT
|
255
|
Downtime end time
|
DSFIELD01
|
|
TEXT
|
4000
|
Comments
|
|