Create a job - SmartPlant Foundation - IM Update 48 - Help - Hexagon

You can create jobs that manage the automation of the import, validation, and export of data into selected target systems, such as SmartPlant Foundation. The basis for each job is the job definition defined in Data Validator Administration, which combines all the settings into one job. The JobDef-PumpList job definition includes the import definition, validation rules, export mapping, and target system information that we have created to process the sample input file and load the validated data into the target system.

1. Log on to SmartPlant Dashboard as SDVUser.

2. Click Data Validator Job Management.

3. Click Create new job .

4. In the Create New Job dialog box, type Job to import pumps as the description for the job.

5. Select JobDef-PumpList from the Job Definition list.

6. Select SPFTGT from the Target System for Validation list.

7. Select SPFTGT from the Target Systems for Export list.

8. Click Next.

9. On the Target System Configuration page, select PlantA.

10. On the Files to Import page, click Browse to a file to attach to locate the PUMP-LIST.csv file, and click Open to attach the file to the import definition.

    You can find the PUMP-LIST.csv file on Smart Community. For more information, see Find sample data on Smart Community.

11. Click Next. View the Summary, and check the details.

12. Click Finish.

View job progress and approve the validation step

1. Select the job you previously created, Job to import pumps. Click Refresh jobs , if the job is not displayed.

2. On the Progress tab, click Refresh the selected job .

3. Once the validation status is set to Completed Validation, click the Summary tab to check if any errors or warnings are reported. Four errors and zero warnings are displayed.

4. Click Download validation report and save the validation report to a location of your choice. The report is downloaded as a Microsoft Excel file.

5. Open and review details about the job validation summary information in Microsoft Excel.

   

   

   

   • Although only two tags failed validation, the report shows that four rules have failed. This is because the name rule failed for one tag, and this resulted in the error propagating up to the object resulting in another two rules failing. The check pressure rule failed on the other tag, and this resulted in the error propagating up to the object resulting in another two rules failing.

   • Although two tags failed validation, it is up to the user running the job to determine what action needs to be taken. The choices are to get the user who submitted the CSV file to correct the issues, and only export the data if it passes all tests, or to export the tags that currently pass the validation now, then correct the failed tags later in a revised CSV file. In this example, the tags that pass validation will be exported without having the CSV file corrected.

6. Click Approve Workflow Step to allow the valid data to load into the target system.

7. Click OK.

8. Click Refresh the selected job .

9. On completion of the job, the Status on the job is set to Completed.