Skip to main content

Fetch Data from Third Party Application

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.

Conclusion​

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.