You can opt to use an alternate reference field as the job identifier instead of using employees’ names. Using Reference Field as a Job Identifier When the data is imported, the system will identify the employee using their ‘Surname, Firstname’, and will then look to find a job with that Customer. Using a reference field as the job identifier.Using the first name and surname as the job identifier.There are two methods for identifying employees when data is imported using the Fieldglass importer: To allow us to map to the correct job for your employees you need to create an importer for each of your Customers sending you a file from Fieldglass. Please contact for assistance with this.Ĭonfiguring the Importer Create Customer Specific Importers If there is a consistent error it may be possible to adjust this using Astute Payroll’s Rules Engine. If the interpretation that is provided is incorrect you will need to either ask your client to change the way that they are interpreting the data or manually amend the data in Astute Payroll. You will need to ensure that the date format doesn’t change when the file is opened in Microsoft Excel.įieldglass converts the hours that your employees have worked into units of pay.įor example 9.00am to 5.00pm could become 7.6 units of ST Hrs and 0.4 units of OT Hrs. csv open the file in Microsoft Excel, click ‘Save As’, and Select Type ’CSV (Comma delimited)’. Copy the data from the format that you have been provided into a spreadsheet and save it as a.Enquire whether you can get the information in the format or.If your file type or format is different it will not work with this importer. Fieldglass should provide you with the file in this format. You will need to ensure that the file you are importing is in a. csv file containing interpreted data in a specific format. This importer has been created to import a.

This data may come out in different formats. If you have employees working within these organisations, you will likely be receiving a data file exported out of Fieldglass detailing the work completed by your employees. Fieldglass is a workforce management tool used by a range of organisations.

Fieldglass timesheet login