Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal OKTAL : Jurnal Ilmu Komputer dan Sains
Dara Nabilah
Universitas Pamulang
Astronomy Chemistry Computer Science & IT Electrical & Electronics Engineering Social Sciences

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Aplikasi Konversi Data Buku dari Excel ke Database MySQL Berbasis Web pada Percetakan Braille Yayasan Raudlatul Makfufin Dara Nabilah; Farizi Ilham; Abyaz Lutfi Wibowo; Andhika Julianto
OKTAL : Jurnal Ilmu Komputer dan Sains Vol 5 No 06 (2026): OKTAL : Jurnal Ilmu Komputer Dan Sains (INPRESS)
Publisher : CV. Multi Kreasi Media

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Raudlatul Makfufin Braille Printing Foundation (YARFIN) is a social institution producing Braille books for the visually impaired with a production capacity of 150 books per day. The production process requires book catalogue data in database format before being sent to the printing machine. However, data is still stored manually in separate Microsoft Excel files, making the transfer to the database a time-consuming manual process. This condition hinders the targeted increase in production capacity. This study develops a web-based application using PHP, MySQL, and the PhpSpreadsheet library to automatically convert book data from Excel to MySQL through validation, duplicate cleaning, and column mapping processes. Development uses the waterfall method with data collected through observation and interviews. Black-box testing on 10 scenarios shows a 100% success rate across all features. This system is expected to accelerate production datapreparation and support the improvement of YARFIN's printing capacity.
Co-Authors Abyaz Lutfi Wibowo Andhika Julianto Farizi Ilham