Fogwing CMMS offers a streamlined way to manage and track parts in your maintenance system. The Data Import feature allows you to bulk upload parts information through a CSV file, simplifying the process of adding new parts to the fogwing system.
This feature is particularly useful for users who have a large inventory or need to migrate data from other systems into Fogwing CMMS.
Step 1: Download the CSV Template
To import parts, you will need to download a CSV template from the Fogwing system and fill it with the required details for each part. Make sure you have all the required information ready to be filled in the template.
Step 2: Fill in the Part Details
Once you’ve downloaded the template, it’s time to fill in the part details. Below, we’ve broken down each field in the CSV file and what you need to include to ensure a smooth import process.
1. Part_Code
Description: A unique code for each part.
Requirement: Must be unique, with no special characters other than hyphen (
-) or underscore (_).
2. Part_Name
Description: The name of the part.
Requirement: Must be unique, with a maximum of 40 characters.
3. Part_Variant
Description: The version or variant of the part.
Requirement: Optional, but can specify different versions of the part.
4. Part_Description
Description: A brief description of the part.
Requirement: Optional, but recommended for clarity.
5. Qty_in_Stock
Description: The current quantity of the part in stock.
Requirement: Only numeric values allowed.
6. UoM (Unit of Measurement)
Description: The unit of measurement for the part (e.g., pieces, kilograms).
Requirement: Specify the appropriate unit of measurement.
7. Minimum_Threshold
Description: The minimum stock quantity before reordering is triggered.
Requirement: Only numeric values allowed.
8. Storage_Location
Description: The physical location of the part in the warehouse or facility.
Requirement: Provide the specific storage location.
9. Supplier_Name
Description: The name of the supplier of the part.
Requirement: Enter the full name of the supplier.
10. Purchase_Cost
Description: The cost of purchasing the part.
Requirement: Only numeric values allowed.
11. Delivery_Time
Description: The number of days for delivery after ordering.
Requirement: Only numeric values allowed.
12. Minimum_Order
Description: The minimum quantity of parts that must be ordered from the supplier.
Requirement: Only numeric values allowed.
Step 3: Fill the Template and Verify Details
Once you have completed the template with all the required information, please take a moment to carefully review the details. It is crucial to verify the accuracy of the information on your end, as once the part details are uploaded to the Fogwing system, they cannot be reverted to their original state. Ensure all data is correct before proceeding to avoid any errors or irreversible changes.
Step 4: Data Verification and Upload Assistance
After you have verified the data, the Fogwing support team will assist you in validating the information and uploading the file to the system. This step is a critical part of the onboarding process, ensuring that all the details are properly processed and integrated into the system.
Step 5: Further Information on the Uploading Process
For more detailed guidance on how to upload the file, please refer to the link below. This will provide additional instructions and help you understand the process more clearly.
Need Assistance?
If you have any questions or need further assistance, please feel free to reach out to the Fogwing support team at [email protected]. We’re here to help!