MNMAINTCORRECT – Corrective maintenance import

Insert

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:

126 – Code of component SE Maintenance.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 – Create a corrective maintenance.

NMFIELD01

X

TEXT

255

Activity ID # (Generated automatically if not entered).

NMFIELD02

X

TEXT

255

Standard activity ID #.

NMFIELD03

X

TEXT

255

Asset ID #

Note: For multiple assets, insert the identifiers separated by ';'.

(E.g.: ASSET1;ASSET2)

NMFIELD04

X

TEXT

255

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

X

TEXT

255

Execution start time.

NMFIELD06

X

TEXT

255

Actual percentage (%).

NMFIELD07

X1

TEXT

255

Service center ID #.

NMFIELD08

X1

TEXT

255

Technician ID #.

NMFIELD09

X2

TEXT

255

From:

▪responsible method

To:

▪priority evaluation method

NMFIELD10

TEXT

255

The ID of the process that you wish to associate with the activity. Only for workflow.

NMFIELD11

TEXT

255

1 - Workflow.

DSFIELD01

X3

TEXT

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

TEXT

4000

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]