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	Primary key - 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.