Configure shift field import rules

The Shift 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 shift value already defined in FH by setting rules on the import properties for the fields.

1. (If it is not already open) Open the external data import definition for the FireRescue1 Academy data file.

   1. Choose Administration → Database Administration → Import from External Data Source.

      The External Data Imports dialog box appears.

      

   2. 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.

      

2. Configure the main training record as to where to pull the shift value from for the training class.

   1. On the Fields tab, select the TRN_MAIN  SHIFT row, then click Open.

      The External Data Import Field Properties dialog box appears.

      

   2. Click the Rules tab.

      

   3. Specify where to pull the shift value from.

      The data in the FireRescue1 Academy data file.

      1. (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.

      2. Click the Source Field tab.

      3. In the Fields column, click the row for field 3.

         This selection indicates which column in the TRN_MAIN row in the FireRescue1 Academy data file to pull the value from.

      4. Click Save, and then click Close.
      The shift value defined in FH in an attendee's staff record.

      Note: The attendee chosen for the default shift value is the first attendee listed in the data import file. The shift value in the attendee's staff record appears in the Staff dialog box, on the Basic tab, in Shift.

      1. (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.

      2. Select Replace field with a literal value or expression.

         The Replace field with literal value or expression dialog box appears.

         

      3. Replace any existing value or expression with the following expression.

         xlate('stf_main', 'stf_main.staff_id',data(1), 'Shift')

      4. Click OK.

         The dialog box closes.

      5. Click Save, and then click Close.
3. Configure the training details record as to where to pull the shift value from.

   1. On the Fields tab, select the TRN_DET  SHIFT row, then click Open.

      The External Data Import Field Properties dialog box appears.

      

   2. Click the Rules tab.

      

   3. Specify where to pull the shift value from.

      The data in the FireRescue1 Academy data file.

      1. (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.

      2. Click the Source Field tab.

      3. In the Fields column, click the row for field 3.

         This selection indicates which column in the TRN_DET row in the FireRescue1 Academy data file to pull the value from.

      4. Click Save, and then click Close.
      The shift value defined in FH in an attendee's staff record.

      Note: The attendee chosen for the default shift value is the first attendee listed in the data import file. The shift value in the attendee's staff record appears in the Staff dialog box, on the Basic tab, in Shift.

      1. (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.

      2. Select Replace field with a literal value or expression.

         The Replace field with literal value or expression dialog box appears.

         

      3. Replace any existing value or expression with the following expression.

         xlate('stf_main', 'stf_main.staff_id',data(1), 'Shift')

      4. Click OK.

         The dialog box closes.

      5. Click Save, and then click Close.