Run the Clean Data utility automatically using the Windows Task Scheduler - Intergraph Smart P&ID - 11 HF 29 - Help - Hexagon

When you run the utility using the Windows Task Scheduler or the command prompt, you can repair and report drawings in projects from different sites. However, before running the utility, you must provide the necessary site, plant, and project details in an Excel file format.

• For a plant with projects, such as an as-built plant, the plant and project names are different. If the plant does not have any projects, enter the plant name in the plant and project columns. The plant and project names that you enter in the Excel file are case-sensitive.

  Where do I find the plant and project names?

  There are different ways to obtain the necessary plant and project names. In general, look for the corresponding icons in the Plant Structures hierarchy. Each icon represents a unique plant or project.

  Icon	Indicates
  	Plant
  	Project This node is visible only if the plant has projects.

  Using Drawing Manager

  From the File menu, select Open database to see all the available plants and projects under the active site. In the list, the root node represents the plant. If the plant has projects, the sub-node represents a project.

  Using Smart Engineering Manager

  If you are an administrator or if you have necessary access to Smart Engineering Manager, you can see a comprehensive list of plants and projects under the active site.

  In the tree view, expand the Plant Structures node and look for the corresponding plant and project icons.

• The Clean Data utility only runs if a license is available.

• Except gaps, the utility repairs and deletes orphaned model items and OPCs.

Create the Excel file

1. Open Microsoft Excel on your computer.

2. In the first row, create the INI file path, plant, and project column headers.

3. In the Excel sheet, fill in the rows with the necessary details for each project that you want to analyze.

   

4. Save the Excel file in a location of your choice.

Schedule a recurring task

1. Open Windows Task Scheduler.

2. In the Task Scheduler > Actions pane, select Create Basic Task.

3. Enter a name and description for the task, and then select Next.

4. For a recurring task, choose either Daily, Weekly, or Monthly, depending on how often you want to run the Clean Data utility.

5. Select Next.

6. Depending on your choice, configure specific settings such as the start time, frequency, and days of the week or month.

7. Select Next.

8. Choose Start a program, and then select Next.

9. Browse and select the DelMorpItemsConsole.exe.

10. In the Add arguments (optional) box, type Command "[Excel file path]".

    Replace [Excel file path] with the actual path. For example, Command "C:\Users\Documents\MyExcelFile.xlsx".

11. Select Next, and then select Finish.

For information on the repair and cleanup process status, check the log files located in the %temp% folder. The SPDelOrpModItems.log file contains general log messages, whereas the DBCleanup_[project name].txt file contains log messages about deleted orphaned records.