Using a Hypertext Pre-processor Code in Converting .csv File into a Civil Service Commission Daily Time Record Format Applying Agile Model

Abstract

The system was designed and developed for the administration, faculty and staff of Isabela State University Cauayan Campus providing an efficient, organized and well-defined Daily Time Record. Aside from that, the software also gives strong security in recording the attendance of the employees due to the device used. The primary objective of the system is to convert the .csv file from the stand-alone face recognition device into a MariaDB database and arranged it into an organized printable output based on the prescribed DTR format of the Civil Service Commission. The proponents have applied the Agile Model (See Fig.1) and utilizes the different developmental platform for developing the project like the MariaDB Database, PHP (Hypertext pre-processor) and Web browser. Also, the Civil Service Commission Daily Time Record Form for designing the printed DTR. Testing was undergone and some errors shown in the printed DTR encountered by some of the employees. It is found out that errors were come from both to the users and to the face recognition device. The reasons behind problems are, users have multiple ID for both the device and the system and users were missed to register their time in their prescribed remark. To be able to have complete data in the DTR, it is suggested that faculty and staff should have one DTR ID and check the device always if it is under time-in or time-out. Despite the problems arisen, the testing still shows the success of the system because the software provides the converted data into a printable and organized output.