Search Our Knowledge Base

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 designed the data included in the export.

If you need assistance creating custom export files, contact easy clocking technical support by calling 1 888 7831493 option 2 or email us at support@easyclocking.com

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:
    1. Name.- Here enter the column name for the CSV.
    2. Title.- This may be left blank, however the name column should be unique and different, but if you requirement needs certain columns named to be named the same, then use the title column for this purpose.
    3. Format.- This is normally blank, but for example you can enter F2 if you only need 2 decimals for the value being exported.
    4. 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 is not a value coming from the the db. Constant fields must be manually enter. 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.