Our company has RFID enter-leave system which writes events into sql server. I wrote a python script which runs every something and reads current date events from sqlserver database and writes it to the odoo postgres hr.attendance table, calculating worked_hours and filtering already present rows. What are other tables I need to write data o to have complete checkin checkout with green icon indication? Also maybe there are other more straightforward ways to perform checkin from external souce?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Бухгалтерия
- Склад
- PoS
- Проекты
- MRP
Этот вопрос был отмечен
1
Ответить
2730
Представления
Hi,
Seems you are already in the right track, we just need to import the attendance data to hr.attendance table with all the information's.
To check in from external options there is no other ways, we have to write own scripts/codes to import the data between odoo and attendance source.
Thanks
Не оставайтесь в стороне – присоединяйтесь к обсуждению!
Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!
Регистрация| Похожие посты | Ответы | Просмотры | Активность | |
|---|---|---|---|---|
|
0
апр. 21
|
3210 | ||
|
2
окт. 25
|
710 | ||
|
1
окт. 25
|
6111 | ||
|
3
сент. 25
|
2335 | ||
|
2
сент. 25
|
3875 |
What i finally did is
1. Write or update event at hr_attendance table
2. Update hr_employee table fields - last_check_in or last_check_out, write_date, last_attendance_id
after that the attendance indication icon updates immediately