Locations

 

Import Locations 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 Locations table via records in a spreadsheet or text file.

 

Open the Locations input form.

 

 

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

 

 

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 locations table.

On Safe Lines QHSE Software Help file v7.1.01 : Copyright © 2003-2019 On Safe Lines QHSE Software Ltd