Setting up the Time Sheet Module
      Back to home
      1. Knowledge Base
      2. Time Sheets
      3. Setting up the Time Sheet Module

      Import Time Sheet User Groups and Time Sheet Entry Types

      You may import Time Sheet User Groups and Time Sheet Entry Types. This can assist when setting up or maintaining your system.

      Introduction

      Import Time Sheet User Groups

      Import Time Sheet Entry Types

      Introduction

      You may import Time Sheet User Groups and Time Sheet entry Types from a spreadsheet file, to assist in efficiently setting up or maintaining these records.

      To create a file to work from, you can export either a file with the existing records or a blank template file. These will show you the fields that are used. Then you can edit the file and reimport it.

      Return to Top of Page

      Import Time Sheet User Groups

      You may export a file containing the existing data for your Time Sheet User Groups, edit it and reimport your changes.

      Alternatively, you may export a blank template file for your Time Sheet User Groups, edit it and reimport your changes.

      1. To export a file with your existing Time Sheet User Groups:

      • Go to Time Sheet > User Groups.
      • Click More Actions.
      • Click Export.
      This will create a file containing the existing records, which you may edit or add to.

      • Open the spreadsheet file and add the details to be imported for new Time Sheet User Groups.
      • Save your spreadsheet changes.
      OR:

      2. To export a blank template file:

      • Go to Time Sheet > User Groups.
      • Click More Actions.
      • Click Import.
      • Click Download Template.

      This will create a blank file with the required fields that you can complete to be imported.

      • Open the spreadsheet file and add the details to be imported for new Time Sheet User Groups.
      • Save your spreadsheet changes.

      To import your file:

      • Go back to Time Sheet > User Groups
      • Click More Actions.
      • Click Import.
      • Browse to locate the file or drag it to the selection dialog.


      • Click Next to view the preview screen.
      This will display the records that are ready to be updated with a status of Ready to Update.


      • Click Next to import the file.

      This will show the records that have been successfully imported, with a Status of Updated.

      • Click Close.

      The newly imported data will now be displayed.

        Return to Top of Page

      Import Time Sheet Entry Types

      You may export a file containing the existing data for your Time Sheet Entry Types, edit it and reimport your changes.

      Alternatively, you may export a blank template file for your Time Sheet Entry Types, edit it and reimport your changes.

      To export a file with your existing Time Sheet Entry Types:

      • Go to Time Sheet > Entry Types.
      • Click More Actions.
      • Click Export.

      This will create a file containing the existing records, which you may edit or add to.

      • Open the spreadsheet file and add the details to be imported for new Time Sheet Entry Types.
      • Save your spreadsheet changes.

      OR:

      To export a blank template file:

      • Go to Time Sheet > Entry Types.
      • Click More Actions.
      • Click Import.
      • Click Download Template.

      This will create a blank file with the required fields that you can complete to be imported.

       

      To import your file:

      • Go back to Time Sheet > Entry Types
      • Click More Actions.
      • Click Import.
      • Browse to locate the file or drag it to the selection dialog.

      • Click Next to view the preview screen.
      This will display the records that are ready to be updated with status of Ready to Update.


      • Click Next to import the file.

      This will show the records that have been successfully imported, with a Status of Updated.

      Return to Top of Page

      Note: For both the Time Sheet User Group and the Time Sheet Entry Type, the Code is the identifier for the record.

      • The Code will not be changed.
      • If the Code on the spreadsheet to import already exists in the database, then the details will be updated.
      • If the Code does not already exist in the database, it will be added.

      Return to Top of Page

      Need more help? We’re here! We hope our article was helpful! If you need more info or want to connect, drop us an email at support@lentune.com.

      Thank you. We love to hear from you!

      Last updated: 18 May 2022