Navigation: Integration via database > Published interfaces > Maintenance >
This import template makes it possible to insert:
▪Data of a corrective maintenance.
To insert each of these items, it is necessary to follow the standard documented below.
Insert
Column
Required
Type
Precision
Description
OIDINTERFACE
X
TEXT
32
Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORT
NUMERIC
2
Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEM
10
System code where the integration will be performed to:
126 – Code of component SE Maintenance.
FGOPTION
Code of the operation to be performed:
1 – Create a corrective maintenance.
NMFIELD01
255
Activity ID # (Generated automatically if not entered).
NMFIELD02
Standard activity ID #.
NMFIELD03
Asset ID #
Note: For multiple assets, insert the identifiers separated by ';'.
(E.g.: ASSET1;ASSET2)
NMFIELD04
Execution 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.
NMFIELD05
Execution start time.
NMFIELD06
Actual percentage (%).
NMFIELD07
X1
Service center ID #.
NMFIELD08
Technician ID #.
NMFIELD09
X2
From:
▪responsible method
To:
▪priority evaluation method
NMFIELD10
The ID of the process that you wish to associate with the activity. Only for workflow.
NMFIELD11
1 - Workflow.
DSFIELD01
X3
4000
Example:
identifier_of_attribute1=value_of_attribute1;
identifier_of_attribute2=value_of_attribute2;
identifier_of_attribute3=value_of_attribute3.
Example with a multivalued attribute:
identifier_of_attribute1=value1_of_attribute1,value2_of_attribute1,value3_of_attibute1
Note: For attributes with a numeric value, the decimal place separator must be '.'.
For date fields, the value must have the “Y-M-D” (Year-Month-Day) format.
DSFIELD02
X4
For quantitative method:
▪For list of values: [id criterion 1]=[id result1];[id criterion 2]=[id result2]
▪For indeterminate value: [id criterion 1]=[value 1];[id criterion 2]=[value 2]
▪Mix: [id criterion 1]=[id result1];[id criterion 2]=[value 2]
For simple listing method:
▪[id result]
X² - Required if it is not entered in the standard activity.
X² - Required if the DSFIELD02 field is filled.
x³ - Required if the standard activity has a required attribute.
X4 - Required if the NMFIELD09 field is filled.