Navigation:  Setting up TOOLMINDER > Import External Data >

Import Asset

Previous pageReturn to chapter overviewNext page

Importing of Asset records will automatically create new Product and Address records that are missing from TOOLMINDER.

 

The Worksheet name in the Excel spreadsheet must be called Asset.

 

Mandatory

Column

Description

Example

 

Product Type

The type of product

 

T : Power Tool

V : Vehicle

H : Hand Tool

L : Lifting Equipment

P : PPE

C : Consumable

G : Generic Item

T

 

Manufacturer

Manufacturer of the product

Makita

YES

Model No

The model number of the product

8271DWPE

 

Description

The description of the product

12V 10MM COMBI DRILL

 

Site

Name of the site where the asset is located

Head Office

 

Location

Location on the site where the asset is located

Warehouse

 

Room

Room the asset is located

Goods In

YES

Asset No

Number you have assigned to the asset so you can identify it

IDE-001

 

Serial No

Manufacturer or supplier serial number

1234/421-1232

 

Reg No

Registration Number of the Vehicle

 

 

VIN

Vehicle Identification Number

 

YES

Vibration Type

Type of vibration

 

HAV  : Hand Arm Vibration

WBV : Whole Body Vibration

 

NOTE
This field in only mandatory if a vibration record is being saved for the asset

HAV

 

Source Of Vibration

Source of the Vibration value

Manufacturer

 

Task

Task being performed during Vibration testing

Hammer Drilling

 

Magnitude

Vibration level in m/sec²

10.5

 

X Axis

WBV X-Axis

 

 

Y Axis

WBV Y-Axis

 

 

Z Axis

WBV Z-Axis

 

 

VDV

WBV VDV

 

 

Axis Include Uncertainty

Include Uncertainty Value K-Factor

 

 

Consumable

The consumable fitted during the test

 

 

Seat Type

Type of seat

 

 

Accelerometer Mounting

The position where the Accelerometer was  mounted during the monitoring

 

HAV

T : Trigger Grip

H : Single Handle Grip

L : Left Grip

R : Right Grip

S : Support Grip

B : Body

 

WBV

Seat

Floor

T

 

Standard

The Standard to which the test was performed

ISO 5349

 

Test Date

Date the Vibration test was performed

25/12/2011

 

Test No

The unique test number to identify the test

1234

 

Temp No

A temporary Id number

9876

 

Duration Of Test

The duration of the test (hh:mm)

00:15

 

Test Engineer

Name of the engineer who performed the test

John Smith

 

Operator

Name of the operator who used the Tool during the test

Richard Heart

 

Noise

Average Noise in dB(A) monitored during the vibration testing

82

 

Temperature

The measured temperature while the test was performed in  °C

26

 

1 Key

Name for the key value,  free text up to 40 characters

Colour

 

1 Value

Value of the key, free text up to 40 characters

Blue

 

2 Key

 

 

 

2 Value

 

 

 

3 Key

 

 

 

3 Value

 

 

 

4 Key

 

 

 

4 Value

 

 

 

5 Key

 

 

 

5 Value

 

 

 

6 Key

 

 

 

6 Value

 

 

 

7 Key

 

 

 

7 Value

 

 

 

8 Key

 

 

 

8 Value

 

 

 

9 Key

 

 

 

9 Value

 

 

 

10 Key

 

 

 

10 Value