Data Sync | Custom Exports

1) Overview
2) Create custom exports
3) Provider Format Options

i) Format strings
ii) String Filters

4) Custom export example
5) Use custom payroll exports
6) Use custom billing exports

 


🔍 RELATED ARTICLES

Reports | Payroll Costs
Reports | Roster Costs


 

1) Overview

The custom export feature can be used to build an export format file specific to an organisation. This means that development work is not always necessary if an integration with a new product is required.

Custom exports enable organisations to control the format used to export their data to 3rd party applications. Having the ability to do this is cheaper and more flexible than other methods. This functionality enable organisations to create or modify a custom export file whenever the need arises.

 


NOTE: This feature is not enabled by default. Please contact support@easyemployer.com to discuss your requirements and evaluate if this feature can satisfy your organisation's needs.


 

2) Create custom exports

Follow these steps to access custom exports:

3) File name / Provider format options

i) Format strings

The options available for the file name and the provider are called format strings. Format strings allow having user specified output in different parts of Easy Employer.

The syntax of a format string is as follows (including the curly brackets): {my_query_string}

  • An example of this is the format string {now}, which gives the current unix timestamp (a way to track time as a running total of seconds) which produces a result similar to this: 1620958228 (you can check  Epoch Converter to see what date this example refers to).

As shown above, {now} is not human readable, so we can apply a string filter to present the unix timestamp in a more human friendly format:

  • date - {now|date} = 16th Jul 2014 12:00am

The above string filter is used by adding the | (bar/pipe character) followed by the name of the filter date.

This makes the output readable, but it is also possible to provide more information to the filter with a filter parameter:

  • date - {now|date:d/m/Y} = 16/6/2014

By using the filter parameter :d/m/Y, the format for the date filter has been set to day, month and year separated by a forward slash.

 

ii) String filters

They can be used in conjunction with query strings that are used in Easy Employer (remember to put a | (bar/pipe) before the filter, e.g., {my_query_string|filter}).

Filter Description Filter Parameters
date use a specific date or time format Takes a date string the follows PHP’s string format convention.
PHP: DateTimeInterface::format - Manual
initials only show initials Integer - Number of characters to include per work
upper convert to upper-case N/A
lower convert to lower-case N/A
prepend prepend a string to format value (Default '-') String - string value to be prepended
append append a string format value (Default '-') String - string value to be appended
replace replace all occurrences of the search string with the replacement string 2 parameters (…|replace:value1,value2) String - the string to search for to replace String - the value the string should be replaced with
round round to a decimal place Integer - the number of decimal places to round to
roundf round to a decimal place, preserving the decimal length Integer - the number of decimal places to round to
padr right pads the input with a character to match a determined length 2 parameters (…|padr:value1,value2) Integer - the length to pad the string to String - the character to use to pad the string
padl left pads the input with a character to match a determined length 2 parameters (…|padl:value1,value2) Integer - the length to pad the string to String - the character to use to pad the string
trimr trims the right side of the input Integer - the length to trim the string to
triml trims the left side of the input Integer - the length to trim the string to
math applies a mathematical function to the input 2 parameters (…|math:value1,value2) String - the function to apply, one of:
  • add
  • subtract
  • multiply
  • divide
Number - the value to apply with the function

 

4) Custom export examples

i) Payroll cost-based export:

Column Provider Explanation
User export code {user_export_code} The users export code
Shift start date {shift_start_date|date:d/m/Y} The shifts start date in the format dd/mm/yyyy
Shift end date {shift_end_date|date:d/m/Y} The shifts end date in the format dd/mm/yyyy
Shift start to end date {shift_start_date|date:Y/m/d} - {shift_end_date|date:Y/m/d} The shifts start to end date in the format yyyy/mm/dd - yyyy/mm/dd
Shift start time {shift_start_date|date:H:i} The shifts start time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Shift end time {shift_end_date|date:H:i} The shifts end time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Shift start to end time {shift_start_date|date:h:i A} - {shift_end_date|date:h:i A} The shifts start to end time in the 12-hour format of an hour with leading zeros, minutes with leading zeroes and uppercase Ante Meridien and Post Meridien
Shift break length in minutes {break_length|round:0} The shift break length in minutes rounded to 0 decimal places
Shift break length in hours {break_length|math:divide,60|round:2} The shifts length in hours rounded to 2 decimal places
Cost record start date {cost_start_date|date:d/m/Y} The cost records start date in the format dd/mm/yyyy
Cost record end date {cost_end_date|date:d/m/Y} The cost records end date in the format dd/mm/yyyy
Cost record start to end date {cost_start_date|date:Y/m/d} - {cost_end_date|date:Y/m/d} The cost recrods start to end date in the format yyyy/mm/dd - yyyy/mm/dd
Cost record start time {cost_start_date|date:H:i} The cost records start time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Cost record end time {cost_end_date|date:H:i} The cost records end time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Cost record start to end time {cost_start_date|date:h:i A} - {cost_end_date|date:h:i A} The cost records start to end time in the 12-hour format of an hour with leading zeros, minutes with leading zeroes and uppercase Ante Meridien and Post Meridien
Payroll cost code {cost_code} The award payroll categories payroll cost code
Payroll cost duration in hours {cost_duration|round:2} The cost duration in hours rounded to 2 decimal places
Payroll cost duration in minutes {cost_duration|math:multiply,60|round:0} The cost duration in minutes rounded to 0 decimal places
Payroll cost hours or units {cost_hours|round:2} The cost hours or units rounded to 2 decimal places
Cost type {cost_type} The cost record type
Cost effective hourly rate {effective_hourly_rate|round:4} The cost records effective hourly rate rounded to 4 decimal places
Cost total amount {cost_amount|round:4} The cost total amount rounded to 4 decimal places
Payroll entity cost centre {payroll_entity_cost_centre_code} The cost records payroll entity cost centre code
Site cost centre {site_cost_centre_code} The cost records site cost centre code
Role cost centre {role_cost_centre_code} The cost records role cost centre code
Payroll entity cost centre format generation {cost_centre_code} The cost records cost centre code generated from the format string set on the payroll entity

 

ii) Billing application export:

Column Provider Explanation
Transaction ID {transaction_id} Automatically generated transaction ID, starting value set in organisation -> settings -> applications
User export code {user_export_code} The users export code
User given name {given_names} The users given names
User surname {surname} The users surname
User labour details name {user_labour_details_name} The users labour details name
User labour details type {user_labour_details_type} The users labour details type
User labour details ABN {user_labour_details_abn} The users labour details ABN
User state {user_state_territory} The users labour details State
Shift clocked start date {start|date:d/m/Y} The shifts clocked start date in the format dd/mm/yyyy
hift clocked end date {end|date:d/m/Y} The shifts clocked end date in the format dd/mm/yyyy
Shift clocked start time {start|date:H:i} The shifts clocked start time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Shift clocked end time {end|date:H:i} The shifts clocked start time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Shift paid start date {paid_start|date:d/m/Y} The shifts paid start date in the format dd/mm/yyyy
Shift paid end date {paid_end|date:d/m/Y} The shifts paid end date in the format dd/mm/yyyy
Shift paid start time {start|date:H:i} The shifts paid start time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Shift paid end time {end|date:H:i} The shifts paid start time in 24-hour format of an hour with leading zeros and minutes with leading zeros
Shift units {units} The unit amount for the shift
Prioritised rate {prioritised_rate} The effective rate used in calculating the gross amount
Total billing amount {gross_amount} The billing rate multiplied by the unit amount for the shift
Tax rate based on custom entity {entity_tax_amount} The custom entity tax rate applied to the gross amount
Tax rate based on user {user_tax_amount} The users tax rate applied to the gross amount
User based total amount {cost_amount} The base hourly rate multiplied by the unit amount for the shift
Shift site {site} The site of the shift
Shift site address {addr} The site address of the shift
Site cost centre {site_cost_centre_code} The site cost_centre_code of the shift
Shift area {area} The area of the shift
Shift role {role} The role of the shift
Role cost centre {role_cost_centre_code} The role cost centre code of the shift
Role job code {role_job_code} The role job code of the shift
Calculated cost centre {cost_centre_code} The cost centre code prioritised from a custom entity on the shift, falling back to the role cost centre
Billing job code {billing_job_code} The billing job code from the first custom entity assigned to the shift that has this value set
Billing entity name {billing_entity_name} The name of the billing entity of the shift

 

5) Use custom payroll exports

Once a custom payroll export has been created it can be selected for use. This will occur on the settings page for a payroll entity.

6) Use custom billing exports

Once a custom billing export has been created it can be selected for use, in the settings page for a payroll entity.

Have more questions? Submit a request
Powered by Zendesk