Importing FLOCs with Piping Specs

This article explains the MiRO Piping Classification importer. The Piping Classification importer enables you to (bulk) add and edit a set of Specs tied to Flocs of type "PIPE-FLOC". In addition the Importer can be used to (bulk) create new Flocs with these Specs defined. 

The Piping Classification is achieved be defining Specifications on the PIPE-FLOCs as shown in the below image.

Export for Import - Creating the Excel Spreadsheet

In order to import the FLOC and SPEC data, you first need to create an Excel file. This is done through the Export for Import function.

• Go to the FLOC Main Screen (grid list).
• Select the desired FLOCs that you wish to update.
• Click the Export button.

• Click here to export for Import Piping Classification.

• A spreadsheet will be download containing the data of the selected FLOCs.
• Update the data (e.g., the SPEC values) as required. You can also add new FLOCs to the list. Take Note:
  • Be careful to leave all columns (and their headings) in place, including the blue placeholder columns as these are needed to ensure a successful alignment on import (else you will get errors during Step 3 of the import).
  • The spec data can be of type string (e.g., von, nach, Medium) or numeric (e.g., Pmax1, Pmax2, PS1, PS2), but some also have available dropdowns with a predefined list of values, e.g.,  WGK, Fluidgruppe.

• Save your file when done.

Importing the Spreadsheet

When your FLOC data have been Exported for Imported, update and saved, then you are ready to start the import.

• Go to the FLOC Main Screen (grid list) and click the Import button. Alternatively go directly to Settings \ Data Transfer \ Import Data.

• Select the Piping Classification Import Type.

• Click Browse.

• Select your save Excel spreadsheet.
• Click Next.

• Then continue to click Next until the import is Done. See Importing Data via Settings.

Bulk Floc Creation

You can also do and Export for Import to create a template for (bulk) creating new FLOCs with Spec values set:

• Do an Export for Import for any example FLOC of type "PIPE-FLOC". 
• Then add all your new FLOCs with applicable data to the Excel spreadsheet. Don't forget the FLOC IDs!
• Delete the row with the original example FLOC.
• Save the file.
• Import the Excel spreadsheet.

Spec Inheritance

The MiRO specific FLOC Specs are by default inherited by the FLOC's Equipment. When inheritance is set, the Equipment Spec values will automatically be updated when the FLOC Spec values change, irrespective of whether they are changed manual or via the importer.

Importer visibility

If this importer is not visible please request support as this importer needs to specifically be activated for MiRO.