Excel Import (Worker) dialog

For further information on the Excel import settings, see chapters:

Settings

Mapping Administration

Comparison Criteria

If nothing else has been defined when customizing your FACTON system, the "Worker ID" is used as comparison characteristic for workers.

Supported link types

The import supports the assignment of work steps, origins (locations), cost centers, activity types, processes, shift models and validities.

Import groups

The specification of an import group for workers is optional.

Special features of imports

  • Shift model

    If you have defined additional calculation parameters in the system settings for shift models and/or workers, they will be exported as well.

  • Cost rate

    The rates are hourly rates with the total value and the variable portion. The total value and the variable portion are set using the "Value total" and "Value variable" fields.

    You can also enter a time unit for the cost rate in order to import minute rates. In FACTON, time is always converted to the hourly value.

 

Figure: Excel Import (Worker) dialog, Mapping Workers

Figure: Excel Import (Worker) dialog, Mapping Workers Validities

Logs

Further Information see Logs category