Mapping and import…

[Joshua George]

#19032

Hi,

I'm trying to load data into Lenvica HRMS with mapping. The device mapping is done. But I don't see data imported.

Please help.

Josh

[Biju]

#19776

Hi Josh,

I'll explain it for you.

So, you have some text data as seen below:
2008102911294000081
2008102911304000480
2008102911314000501
2008102911354000430
2008102911444000081

Each row represents a punch from an employee. You generated this data out of a time attendance device, so each row tells you when an employee punched IN or OUT.

Now, with mapping, you specify what each character in a row stands for. For example, see the first row in the data.
2008102911294000081

The first 4 characters stands for the year, the next two for the month, the next two for the date and so on. So you finally arrive at a mapping string: YYYYMMDDHHNNBBBBBBC

Now, the BBBBBB stands for badge number. This has to match with the badge number you specify for each employee (Employee – Employee – Employment – Badge Number). See the attachment.

When you import one row with your text file, Lenvica HRMS will look for a matching badge number, if found, it will be considered as a punch from that employee.

Let me summarize:

1. Each row in your text data represents one punch from an employee.
2. Make sure the badge number(BBBBBB) in the text data matches with badge number of an employee(123456)
3. After an import, see 'Raw Punch' report under 'Time Registration' to see if the data is properly imported.
4. If (3) shows the data, you can see the data under 'Attendance – Attendance' also.

Hope this helps.

Biju.

---

Attachments:

[Author]

Posts