Importing Assets and Equipment

Introduction

In this article we will cover how you can bulk upload/ import your Assets and Equipment into the Fracttal system.

Equipment, also known as Assets or Physical Assets or Maintenance Significant Items can be bulk imported into the Fracttal system via a Excel based import sheet.

The system allows for an infinite amount of Equipment with an infinite amount of Parent-Child relationships to be formed. We do however recommend that you create no more than a 3 level equipment structure, Level 1 being the Main Equipment and Level 2 being the Sub-equipment and Level 3 being the Components.

The system can allow for multiple Equipment, each with various levels of Parent-Child relationships as displayed in the graphic above.

Importing Equipment

1. Access Import function

a. In the Fracttal main menu bar navigate to "Equipment" found under the Assets module

b. Click on the "Options" button 

c. Select "import"

2. Import Sheet

Data Fields

The following data fields/ headers can be imported for Equipment using the Fracttal bulk import function:

Importable Field	Restrictions/ Notes
Asset Name	Should not exceed 100 characters. Avoid using special characters
Asset Code	Try not to exceed 20 characters. This is not a limitation but helps with reporting if you don't have a lot of characters in your code
Make	Manufacturer
Model	Manufacturer model/ number
Serial Number	Unique serial number
Extra 1	User definable field. Often used to record equipment criticality ratings, but is essentially a grouping mechanism/ equipment differentiation field. Not to be mistaken with Custom field
Extra 2	See note on Extra 1
Barcode	Can be populated with equipment barcoded label data if applied to equipment
Type	Basically the asset type/ family the equipment belongs to
Group 1	Typically used to further delineate your asset types e.g. Type = Vehicle, Group 1 = Diesel
Group 2	See note on Group 1
Notes	Any internal notes or  technical details you want to add against the asset
Visible to all	This field should only contain Yes/ No. More for advanced users and if not populated will default to No meaning no user outside of the location/ facility the asset will be linked to will be able to see the asset.
Available	Advanced users only. This field should only contain Yes/ No. Used to specify if an asset is available for user or not.
Hours of average daily use	Use {hh:mm} format
Purchase Date	Use {yyyy/mm/dd} format
Parent Code	Refers to the Asset Code of the Location/ other Asset that this asset would be a child of in your asset hierarchy
Priority	Used to assign priority levels to your equipment.  If the Priority column is imported, it must contain a number with the following equivalence: Very high High Medium Low Very low
Cost Center	Refers to the cost center the asset will be linked to
Custom Field	Can only import custom fields you have specified in the system already. Can only import a single custom field.

 

Populate your import sheet with the required information

The following fields are required as a minimum [Orange]:

• Parent/Location Code [for this example the Tier 1 Site Code MS01]

• Facility Name

• Facility Code

The Following Fields are recommended [Yellow]:

• Type

• Group 1

• Group 2

The rest of the fields are available for import as additional data on the Facility [Green]

Import Sheet Formats

You can import your assets using the following document formats:

•  .xlsx, .xlsm, .xlsb, .ods, .xls, .xml

• The first line of the document should contain the titles of the columns/ column headers.

• There should be no formulas in any of the columns.

3. Import Data

a. From the drop-down, select the site that the data will be imported to [in this case Main Site {MS01}] 

Note: the Location "Main Site MS01" will remain the same regardless of which Level you are importing to, and should not be confused with the “Is Part of/Parent Location” field

b. Configure the Headers to match the import fields available in Fracttal with the column headers of your import sheet. 

Note: leave blank those fields which you wish not to import

c. When all the headers have been configured click the “Import” button to run the import

Delete Code

A Delete Code will appear after a successful import, use this code if you wish to reverse the import you just carried out.

This code will automatically be sent to the current active users email address. 

As back-up save the code by taking a screenshot or write down the code for safe keeping

.

4. View Completed Import

The Equipment have now been imported, notice the correlation between the import sheet you created, and the fields populated in the system

Click here to view an article on Equipment Register Navigation

Click here to view and article on Adding Equipment

• Related Articles

• Adding Equipment

  Equipment Register The Equipment Register houses All your Maintenance Significant Items [MSI] and Non MSI's in the Fracttal database. with a record of information about each item of plant, machinery and equipment employed by the organisation . ...

• Video - Assets & Equipment

  For fullscreen view, click on the open in full screen/ open in new tab icon bottom right of the video

• Assets - Custom Field Filters

  Custom Field Filters Custom Fields As you add information within Fracttal, you may encounter instances where you need to add additional important asset/ equipment data. Fracttal allows you to create custom fields and field types that can be recorded ...

• Importing Facilities

  Introduction  In this article we will cover how you can bulk upload/ import your Facilities into the Fracttal system. Facilities in Fracttal acts like a folder structure or a placeholder in which your companies Equipment, also know as Physical Assets ...

• Importing Tools

  Introduction In this article we will cover how you can bulk upload/ import Tools into the Fracttal system. Tools can be bulk imported into the Fracttal system via a Excel based import sheet.  The system allows for an infinite amount of Tools to be ...