Summary

Use this command to import timebands from a third party software package or from a file that meets the format criteria.

You would use this command if you do not have Shifts and Tours set up in PayGlobal. For example, each departmental manager completes a spreadsheet of employee timebands, and then submits them to the payroll officer to import.

Pre-requisites

You can use this command only if:

• You have set up the following details on the Company Settings | Rostering | Import Timebands tab:
  • Timeband data path - If this path is not specified, then PayGlobal uses the Company Data | Import folder.
  • Import Type
  • Import file - This field must contain the actual file name and extension of the file to be imported.

The file that you want to import matches the Import Timebands settings.

Fields

Import Files:

Use the pick list to select the file that you want to import. For example, if Import Type = "CSV", Import file = "*csv", then you can select a CSV file in the Timeband data path or Import folder.

Detailed Log:

Yes/No field that determines the amount of information displayed in the audit log.

Merge timebands:

Yes/No field that determines how PayGlobal treats timebands in the import file if timebands already exist for the employee on that day.

• Yes (default setting)
  • If the timeband being imported overlaps an existing timeband, then PayGlobal will not import that timeband.
  • If the timeband being imported does not overlap with an existing timeband, then PayGlobal imports the timeband. As a result, you may have multiple timebands for an employee for that day.
• No

  The imported timebands replace the existing timebands for the employee on that date.

Imported Fields

The import file can contain up to 26 fields. The fields that can be imported are as follows

Validation Rules

When you import RosterTimeBands, PayGlobal applies the following rules:

• The timeband contained in an import file will only be imported if it does not overlap an existing timeband and Merge Timebands = "Yes".
• If Merge Timebands = "No", then the imported timeband overwrites the existing timeband for the employee for that day.