MNPLANACT - Activity plan import
This import template allows inserting/editing:
- Verification/Preventive maintenance/Calibration plan data.
For the insertion of each one of these items, the standard documented below must be followed.
Insert/Edit
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 | Code of the system for which the integration will be performed: 109 - Code of the SoftExpert Asset component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 21 - Add activity plan; 22 - Edit activity plan. |
NMFIELD01 | X¹ | TEXT | 255 | Plan type: 1 - Verification; 2 - Preventive maintenance; 3 - Calibration. |
NMFIELD02 | X | TEXT | 255 | Plan ID # |
NMFIELD03 | X¹ | TEXT | 255 | Plan name |
NMFIELD04 | X¹ | TEXT | 255 | Standard activity ID # |
NMFIELD05 | X¹ | TEXT | 255 | Plan configuration: 1 - Inherit activity data; 2 - Copy activity data. |
NMFIELD06 | X¹ | TEXT | 255 | Asset ID #. For multiple assets, separate the identifiers with semicolons. E.g.: ASSET01ID;ASSET02ID;ASSET03ID |
NMFIELD07 | X¹ | TEXT | 255 | ID # of the team responsible for the plan |
NMFIELD08 | X² | TEXT | 255 | ID # of the team responsible for planning |
NMFIELD09 | X² | TEXT | 255 | ID # of the team responsible for execution |
NMFIELD10 | TEXT | 255 | Date-based frequency: 1 - Enable; 2 - Disable. | |
NMFIELD11 | X³ | TEXT | 255 | Frequency type: 1 - Execution date; 2 - First use; 3 - Usage time. |
NMFIELD12 | X³ | TEXT | 255 | Frequency |
NMFIELD13 | X³ | TEXT | 255 | Frequency unit: 1 - Day(s); 2 - Week(s); 3 - Month(s); 4 - Year(s); 5 - Working day(s). |
NMFIELD14 | X³ | TEXT | 255 | Date display: 1 - Month/Day/Year; 2 - Month/Year. |
NMFIELD15 | X³ | TEXT | 255 | Date of the next execution. 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. |
NMFIELD16 | TEXT | 255 | Calendar ID # | |
NMFIELD17 | TEXT | 255 | Frequency based on asset meter: 1 - Enable; 2 - Disable. | |
NMFIELD18 | X⁴ | TEXT | 255 | Frequency |
NMFIELD19 | X⁴ | TEXT | 255 | Anticipation |
NMFIELD20 | X⁴ | TEXT | 255 | Next execution |
NMFIELD21 | TEXT | 255 | Create activity automatically: 1 - Enable; 2 - Disable. | |
NMFIELD22 | X⁵ | TEXT | 255 | Activity step created automatically: 1 - Planning; 2 - To be started. |
NMFIELD23 | X⁵ | TEXT | 255 | Number of days in advance for the automatic activity to be created |
NMFIELD24 | X⁶ | TEXT | 255 | Evaluation method ID # |
NMFIELD25 | X⁵ | TEXT | 255 | Continue to create activities automatically even if there already are pending activities? 1 - Yes; 2 - No. |
NMFIELD30 | TEXT | 255 | Number of days in advance for notification between 0 and 999. | |
DSFIELD01 | X⁷ | TEXT | 255 | For quantitative method: ▪For list of values: [criterion 1 id]=[result 1 id];[criterion 2 id]=[result 2 id] ▪For indeterminate value: [criterion 1 id]=[value 1];[criterion 2 id]=[value2] ▪Mixing: [criterion 1 id]=[result 1 id];[criterion 2 id]=[value 2] For simple listing method: ▪[result id] |
info
Note:
- X¹ - Required for insertion.
- X² - Required for insertion if the plan configuration is copy.
- X³ - Required if the date-based frequency is enabled.
- X⁴ - Required if the meter-based frequency is enabled.
- X⁵ - Required if the option to create activity automatically is enabled.
- X⁶ - Required if the
DSFIELD01
field is completed. - X⁷ - Required if the
NMFIELD24
field is completed.