Configure station field import rules
The Station
field has also been added as data sent from FireRescue1 Academy for FH CMS. You can choose pull the data in this field from the FireRescue1 Academy import file, or you can choose to use a station value already defined in FH by setting rules on the import properties for the fields.
-
(If it is not already open) Open the external data import definition for the FireRescue1 Academy data file.
-
Choose Administration → Database Administration → Import from External Data Source.
The External Data Imports dialog box appears.
-
Select
FireEMS Academy
, then click Properties.The External Data Import Properties dialog box appears, and lists the fields in your current FireRescue1 Academy import utility.
-
-
Configure the main training record as to where to pull the station value from for the training class.
-
On the Fields tab, select the
TRN_MAIN STATION
row, then click Open.The External Data Import Field Properties dialog box appears.
-
Click the Rules tab.
-
Specify where to pull the station value from.
The data in the FireRescue1 Academy data file.-
(If it is selected) Clear Replace field with a literal value or expression.
With this field cleared, FH ignores any rule that might be defined for it, and data imported from the FireRescue1 Academy data file is not overridden by the rule.
- Click the Source Field tab.
-
In the Fields column, click the row for field
2
.This selection indicates which column in the
TRN_MAIN
row in the FireRescue1 Academy data file to pull the value from. - Click Save, and then click Close.
The station value defined in FH in either an attendee's staff record or in the workstation's location.Note: The attendee chosen for the default station value is the first attendee listed in the data import file.
- The station value in the attendee's staff record appears in the Staff dialog box, on the Basic tab, in Station.
- The station value in the attendee's staff record appears in the Workstation Options dialog box, on the General → Startup & Navigation tab, in the Workstation Location section.
-
(If it is selected) Clear Replace field with a literal value or expression.
This will force the Replace field with literal value or expression dialog box to appear the next time the field is selected, and display any value or expression assigned to the field.
-
Select Replace field with a literal value or expression.
The Replace field with literal value or expression dialog box appears.
-
Depending on where you want the station value to be pulled from, replace any existing value or expression with one of the following expressions.
Pull value from Us this expression The staff record xlate('stf_main', 'stf_main.staff_id',data(1), 'Station')
The workstation's location goApp.Workstation.Station
-
Click OK.
The dialog box closes.
- Click Save, and then click Close.
-
-
-
Configure the training details record as to where to pull the station value from.
-
On the Fields tab, select the
TRN_DET STATION
row, then click Open.The External Data Import Field Properties dialog box appears.
-
Click the Rules tab.
-
Specify where to pull the station value from.
The data in the FireRescue1 Academy data file.-
(If it is selected) Clear Replace field with a literal value or expression.
With this field cleared, FH ignores any rule that might be defined for it, and data imported from the FireRescue1 Academy data file is not overridden by the rule.
- Click the Source Field tab.
-
In the Fields column, click the row for field
2
.This selection indicates which column in the
TRN_DET
row in the FireRescue1 Academy data file to pull the value from. - Click Save, and then click Close.
The station value defined in FH in either an attendee's staff record or in the workstation's location.Note: The attendee chosen for the default station value is the first attendee listed in the data import file.
- The station value in the attendee's staff record appears in the Staff dialog box, on the Basic tab, in Station.
- The station value in the attendee's staff record appears in the Workstation Options dialog box, on the General → Startup & Navigation tab, in the Workstation Location section.
-
(If it is selected) Clear Replace field with a literal value or expression.
This will force the Replace field with literal value or expression dialog box to appear the next time the field is selected, and display any value or expression assigned to the field.
-
Select Replace field with a literal value or expression.
The Replace field with literal value or expression dialog box appears.
-
Depending on where you want the station value to be pulled from, replace any existing value or expression with one of the following expressions.
Pull value from Us this expression The staff record xlate('stf_main', 'stf_main.staff_id',data(1), 'Station')
The workstation's location goApp.Workstation.Station
-
Click OK.
The dialog box closes.
- Click Save, and then click Close.
-
-
- Continue with Configure shift field import rules.