Skip to main content

How to Import Data in Fogwing CMMS

Learn about master data import in fogwing CMMS.

Written by Harry

Overview

Fogwing CMMS offers an enhanced Data Import feature designed to simplify and accelerate the process of onboarding master data into the platform. With the latest improvements, users can now import Assets, Parts, and Checklist Templates using predefined templates.
​

The enhanced interface provides a more streamlined and user-friendly import experience, making it easier to manage data uploads. Additionally, the platform supports Asset-Part Mapping, allowing users to associate parts with their respective assets during the data import process.
​

These enhancements simplify initial data setup, reduce manual effort, improve data accuracy, and help organizations get started with Fogwing CMMS more efficiently.
​
​Note: Data import functionality is available to Admin users.

1. Supported Data Import

Fogwing CMMS supports the following data import processes through the Import Wizard:

  • Asset Master Data Import: Import asset details, including asset codes, names, categories, locations, and other relevant information.

  • Parts Master Data Import: Import spare parts and inventory details, including part codes, names, units of measurement, stock quantities, and other relevant information.

  • Asset–Parts Mapping: Import mapping information to establish relationships between assets and their associated spare parts, simplifying asset-wise spare parts management.

  • Checklist Import: Import existing checklist templates into Fogwing CMMS to digitize maintenance inspections and standardize maintenance execution processes.

2. Prepare Your Data for Import

Before importing data into Fogwing CMMS, ensure that your data is properly formatted using the respective CSV templates.
​

Follow these guidelines:

  1. Download the CSV Template: Use the predefined template provided by Fogwing CMMS for the respective data type.

  2. Follow the Template Structure: Do not modify the column headers or change the predefined template structure.

  3. Fill in Mandatory Fields: Ensure all required fields are populated with valid information.

  4. Maintain Unique Codes: Ensure that Asset Codes and Part Codes are unique wherever applicable.

  5. Validate Data: Remove duplicate records, correct formatting errors, and verify that the information is accurate.

  6. Save in CSV Format: Save the completed file in CSV format before uploading it.

Important: Incorrect formatting, missing mandatory fields, or duplicate records may result in import validation errors.

3. Steps to Import Data in Fogwing CMMS

Follow the steps below to import your master data.
​

Step 1: Log in to Fogwing CMMS
Log in to your Fogwing CMMS account:


​Step 2: Navigate to Settings

From the main navigation menu, click on Settings.
​

Step 3: Open Data Import

Navigate to Account Settings and select the Data Import section.


​Step 4: Click on Let's Import

On the Data Import page, click the Let's Import button to start the new import process.
​


​Step 5: Select Import Process
On the Import Wizard page, select the type of data you want to import from the following options:

  • Asset Master Data

  • Parts Master Data

  • Asset–Parts Mapping

  • Checklist

Select the required import process and click Next to proceed.
​


​Step 6: Upload the CSV File

Choose the appropriate CSV file containing your prepared data and click the Submit button to initiate the import process.
​

Step 6: Validate the Uploaded File

After uploading the CSV file, the system automatically validates the data to identify any errors or missing information.

  • The system checks the uploaded file against the required format and validation rules.

  • If any errors are identified, review and correct the highlighted issues before proceeding.

  • Once all validations are completed successfully, the system displays a Validation Successful message.
    ​


​Step 7: Review & Submit

After successful validation, review the uploaded data and its preview to ensure everything is correct. Once verified, click Submit to proceed with the import.
​


​Step 8: Track Import Status

After submitting the file, you can monitor the import status on the Data Import page.

The import status will initially appear as In Progress and will change to Processed once the import process is
​


4. Important Guidelines

Before proceeding with the import, keep the following points in mind:

  • Use only the predefined CSV templates.

  • Do not modify the column headers.

  • Ensure that all mandatory fields contain valid information.

  • Verify that asset and part codes follow the supported naming conventions.

  • Check for duplicate records before uploading.

  • Review the data carefully to avoid import errors.

5. Need Assistance?

If you need assistance with preparing your import files or importing data into Fogwing CMMS, contact our support team.
​

Did this answer your question?