Skip to main content

Prism Attendance Data Collector

Efficient and seamless attendance data processing is crucial for accurate workforce management. This document outlines various methods of integrating devices for attendance tracking, the necessary data requirements, and the automated processing framework.

  • Automated Attendance Tracking: Reducing manual entry errors by integrating biometric and IoT-enabled devices.
  • Data Synchronization: Ensuring real-time data consistency between multiple sources, including databases and external systems.
  • Enterprise Resource Planning (ERP) Integration: Matching employee IDs with ERP records to maintain accuracy.
  • Secure Authentication: Utilizing biometric data (fingerprint, face recognition, NFC cards) for secure identification.
  • Cross-Platform Compatibility: Supporting multiple database environments (MySQL, MSSQL) for data processing.

To create an automated, reliable, and efficient attendance data processing system that minimizes manual intervention and ensures accuracy by leveraging device integration and data processing methodologies.

Explanation of Data Processing & Integration​

Attendance Data Receiving Methods:
  • Manual Entry: Single and batch entry for attendance records.
  • Entry from Device: Data reception via POST API.
  • Entry Upload: Supports both device data uploads and manual entries.
  • File Reader: Processing attendance logs from external files.
  • Pull via Script: Extracting data through automated scripts.
  • Push via PrismADC Mobile App: Direct transmission from mobile-based attendance systems.
  • Database Integration: Supporting MySQL and MSSQL environments.
  • EVTX Log Parsing: Attendance data extraction from system event logs.
Required Information for Data Processing:
  • Employee ID: Must match ERP records.
  • Authentication Methods: Fingerprint, facial recognition, NFC card.
  • Network Connectivity: Attendance data captured over the internet/intranet via IP/Device Serial.
  • Valid Records: Ensuring valid employee records, timestamp accuracy, and URL integrity.
Data Receiving & Posting:
  • EVTX or Active Directory File Processing: Automating log-based attendance tracking.
  • PrismADC Push API: Facilitating seamless and direct data push from devices.
PrismADC Architecture:
  • Fully automated attendance data processing.
  • Devices directly push attendance records without intermediaries.
  • No human intervention required for data handling.
  • Supports all ADMS-compliant devices.

Key Features​

  • Fully Automated Process: Eliminates manual data entry errors.
  • Multiple Integration Methods: Supports APIs, scripts, and direct database entry.
  • Secure Data Handling: Biometric authentication ensures high security.
  • Real-time Data Processing: Ensures up-to-date attendance records.
  • Cross-Platform Support: Compatible with MySQL and MSSQL databases.
  • Flexible Entry Methods: Supports device uploads, manual entry, and log parsing.
  • Enterprise-Ready Architecture: Seamless ERP and network integration.

PrismADC provides an efficient and automated attendance data processing solution with seamless device integration, ensuring high accuracy, security, and real-time data synchronization. This system is designed to cater to enterprise needs, eliminating manual errors and improving workforce management efficiency.

PrismERP provides a comprehensive attendance data processing system that seamlessly integrates with various attendance devices. This document outlines the technical aspects of device integration, data processing, and automation within PrismERP.

System Architecture​

The attendance data processing system within PrismERP is designed to support real-time data synchronization, secure authentication, and cross-platform compatibility. The architecture includes:

  • Direct device-to-system integration
  • API-based data exchange
  • Automated data validation and processing

Key Components​

  • Device Integration Layer – Supports biometric scanners, NFC readers, and other authentication devices.
  • Data Processing Engine – Handles data validation, transformation, and storage.
  • Database Management – Compatible with MySQL and MSSQL for seamless data handling.
  • API Gateway – Facilitates communication between devices and PrismERP.
  • Security Layer – Ensures encrypted data transmission and secure authentication.

Device Integration​

Supported Devices​

  • Biometric Fingerprint Readers
  • Facial Recognition Systems
  • NFC-based Smart Cards
  • IP-based Attendance Terminals

Data Transmission Methods​

  • Manual Entry: Single and batch entry through the ERP interface.
  • Device API Integration: Direct POST API for real-time data updates.
  • Data Upload: Supports both manual file uploads and automated device sync.
  • EVTX Log Parsing: Extracts attendance records from system event logs.
  • PrismADC Mobile App: Facilitates mobile-based attendance tracking.
  • Database Synchronization: Enables MySQL and MSSQL integration.

API Endpoints​

  • POST {BaseUrl}/adc_data/async

    • Description: Allows direct entry of attendance records.
    • Headers:
      • Content-Type: application/json
    • Parameters:
      • employee_no: Unique identifier for the employee.
      • entry_time: Entry time.
      • entry_date: Entry Date
      • device_serial: Source device identifier.
    • Response:
      • 200 OK: Entry recorded successfully.
      • 400 Bad Request: Invalid parameters or missing data.
      • 404 Not Found

  • GET /attendance/logs

    • Description: Retrieves attendance logs for a given period.
    • Parameters:
      • start_date: Beginning of the time range.
      • end_date: End of the time range.
    • Response:
      • 200 OK: Returns list of attendance records.
      • 404 Not Found: No records available.

Data Processing & Validation​

Required Data Fields​

  • Employee ID: Must match ERP employee records.
  • Timestamp: Accurate date and time of entry.
  • Device Authentication: Fingerprint, Face Recognition, or NFC verification.
  • Valid URL & IP: Ensures authorized data submission.

Data Processing Workflow​

  • Data Reception: Attendance records are received from supported devices.
  • Validation: Employee ID, timestamp, and device details are verified.
  • Storage: Valid data is stored in the PrismERP database.
  • Synchronization: Data is updated across relevant ERP modules.
  • Reporting: Attendance logs are available for payroll and HR analysis.

Security & Compliance​

Authentication & Encryption​

  • Secure API Tokens: API access is secured using authentication tokens.
  • Data Encryption: Attendance data is transmitted over SSL/TLS.
  • Role-Based Access Control (RBAC): Ensures only authorized users can access or modify data.

Compliance Standards​

  • GDPR & Data Protection: Employee attendance data is stored securely and complies with international privacy laws.
  • Audit Logging: All attendance modifications are logged for security monitoring.

Key Features​

  • Real-time Data Processing: Instant updates from attendance devices.
  • Multiple Integration Methods: API, file uploads, and direct database connections.
  • Biometric & NFC Authentication: Secure employee verification.
  • Cross-Platform Compatibility: Supports MySQL and MSSQL databases.
  • Automated Attendance Tracking: Reduces manual data entry and errors.
  • ERP Synchronization: Seamless integration with PrismERP modules.

PrismERP’s attendance data processing system provides a robust, automated, and secure solution for workforce management. With real-time device integration, secure data processing, and seamless ERP synchronization, it ensures efficiency, accuracy, and compliance in employee attendance tracking.