QHSE Support - (Site Map) TIRA > Import Data Examples >  > Import Grades into Locations Table

The methods outline here can be used on the following tables:

 

•Companies

•Locations

•Designations

•Departments

 

The following procedure will allow user to import names into the Designations and Grades table via records in a spreadsheet or text file.

 

Open the Grades input form.

 

 

PLEASE NOTE: The example show here is from our Accident Investigation and Management software AIM.  However the principle is the same.

 

For TIRA, please ignore the ID field, this will be calculated automatically.

 

 

Click on the black star in the new record field.

 

Next open your preferred import file.

 

Option 1. Via Spreadsheet.

 

 

Right click on the highlighted text and select copy

 

Option 2. Via Text file.

 

 

Right click in the highlighted (blue) text and select copy

 

 

Check the white triangle on the black background is still displayed.  Note: this must always the bottom most (new) record. 

 

 

Now use the cntr + v keys to paste in your records

 

AIM offers a yes / on proceed massage box.

 

 

As we have not specified the field names in the records being pasted, this warning can be ignored.

 

 

Select yes to import your records or no to abandon.

 

 

Table shows records successfully pasted into grades table.

On Safe Lines  - Help file v8.0.00 : Copyright © 2020 On Safe Lines