EC - Exports - Custom Export
The custom export feature in Easy Clocking is designed to allow exporting the information as per your company requirements. It allows choosing what data you want to include in the file.
It is very flexible and advanced that even if you require to sum and add fields or use a combination of both, it has a portion called “Transformation” where using Python coding, you can design the data included in the export.
How to create custom exports
- Click on Export
- Click on Custom Export
- Click on Columns and here you must enter what values to include in the file
- To add values click on Columns then click on Add Column
- For each column enter the following:
- Name - Here enter the column name for the CSV.
- Title - This may be left blank, however the name column should be unique and different, but if your requirement needs certain columns named to be named the same, then use the title column for this purpose.
- Format - This is normally blank, but for example you can enter F2 if you only need 2 decimals for the value being exported.
- Type - Select the value type which could be one of the following:
- Data Field - Used when the source comes originally from the db.
- Constant Field - Used when it is not a value coming from the the db. Constant fields must be manually entered.
For example: Pay Codes or Earning Codes which are different for each payroll provider. - Transformation - Used when the value source comes from a transformation using Python coding.
- Format Base - Used for specific formats.
- Once the columns have been added, then click under Period to select the dates for the export
- Click on User to select the User to export information for.
- Then click Preview to preview the file or Click Export to generate the CSV file.