00 Day
00 Hour
00 Min
00 Sec

Need attendance Import template

Home Forums HRM Need attendance Import template

Viewing 10 reply threads
  • Author
    Posts
    • #1865
      amer
      Participant

      I still getting error every time importing attendance sheet, so I need a template for that

    • #1945
      Anonymous
      Inactive

      Hello @amer,

      Please make sure you are using a valid CSV file. I have just tested a random CSV file. After uploading the file, the system will ask you to select the header where is the employee ID and date/time is located.

      So the structure of the CSV file is not an issue. Only 2 things that you need to keep in mind is-

      1. Employee ID – it can be set on employee profile.
      2. Date Time Format – 2016-01-03 08:58:19 (Y-M-D H:M:S). Note that the time has to be in 24-hour format.

      If you are still having issues after following the above instructions, you can mail me the CSV file to [email protected] and I will make a template for you πŸ™‚

    • #1947
      amer
      Participant

      Thanks a lot,
      I think that this is for check-in, what about check-out?

    • #1949
      Anonymous
      Inactive

      We have tested some common devices and they create a new row when a new entry is posted. So we count the very first and last entry of the same day to calculate the check-in and checkout time.

      So if you have 2 or more rows for the same employee ID, then the system will pickup the check-in and check out time automatically.

    • #2490
      developer
      Participant

      how is the check out format, can you amend no 2.

      1. Employee ID – it can be set on employee profile.
      2. Date Time Format – 2016-01-03 08:58:19 (Y-M-D H:M:S). Note that the time has to be in 24-hour format.

    • #2497
      Anonymous
      Inactive

      Hello @developer,

      I did not understand your last reply. If you need a reference file, this doc has a link for you https://wperp.com/docs/hrm-add-ons/attendance-management/ to download a sample CSV file.

    • #3517
      Vipermarx
      Participant

      Hi guys, may I know what is device no. on the template?

    • #3548
      Anonymous
      Inactive

      Hello Vipermarx,

      This template is not from any device. We have just made a general format which everyone can use and convert their data easily.

    • #6125
      islam
      Participant

      hi ,
      also with me plugin still output [file type not support ] how can i fix this error plz

    • #6128
      Shawon Chowdhury
      Moderator

      @islam,

      As you have contacted us at “[email protected]” so we are going to follow that ticket for this issue. Thanks πŸ™‚

    • #6129
      Shawon Chowdhury
      Moderator

      @All,
      Just removed the old “sample CSV file” from the documentation and added the latest CSV file so that no one suffers for it in future.

      Thanks πŸ™‚

Viewing 10 reply threads
  • The forum ‘HRM’ is closed to new topics and replies.

Contact Us

Reach out to us for any inquiry

You must enter full name
You must enter email
You must enter message

We received your query

We will reply to you very soon :)