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

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

Found 2 Documents
Search

 1 
Sistem Konversi Data Excel Menjadi MySQL untuk Efisiensi Pengolahan Data pada PT. Afra Indo Safety Anggie Syahputra; Farizi Ilham; Barren Al Faridzi; Thio Mandala Putra
OKTAL : Jurnal Ilmu Komputer dan Sains Vol 5 No 06 (2026): OKTAL : Jurnal Ilmu Komputer Dan Sains
Publisher : CV. Multi Kreasi Media

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

Abstract

Microsoft Excel is still widely utilized by organizations for data management activities due to its user-friendly and flexible nature. Nevertheless, spreadsheet-based data storage faces several challenges, including duplicate records, input inaccuracies, inefficient information retrieval, and limitations in data integration. This study aims to develop a system capable of converting and integrating data from Excel files into a MySQL database in order to improve the effectiveness and accuracy of data management processes. The research methods include observation, interviews, literature review, and software development using the Waterfall approach, which consists of requirements analysis, system design, implementation, testing, and maintenance stages. The system was developed using PHP and MySQL and is equipped with features such as Excel file uploading, data mapping, data validation, and automated data migration into the database. The implementation results demonstrate that the system can accelerate data processing activities, minimize recording errors, maintain data consistency, and facilitate users in accessing and managing information in a more organized manner. Therefore, the developed system can serve as an effective solution for supporting more efficient, accurate, and integrated organizational data management.  
PENGEMBANGAN E-SYSTEM MANAJEMEN DATA SISWA DAN KEUANGAN SEKOLAH BERBASIS WEB STREAMLIT Faiz Rizqi Hanafi; Auzriel Zidan Arby; Lilis Roudhotul Jannah; Muhammad Rizky Ramadhan; Milani Nuril Sandi; Nandang Adriansyah; Shanasha Aulia Dianthi; Syerikha Ananda; Thio Mandala Putra; Zaqhluul Farhan; Nardiono
Abdi Jurnal Publikasi Vol. 4 No. 3 (2026): Januari
Publisher : Abdi Jurnal Publikasi

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

Abstract

The rapid development of information technology has encouraged educational institutions to adopt digital systems to improve administrative efficiency and data accuracy. However, many schools still rely on manual or semi-digital processes, particularly in managing student data and school financial administration. This condition was found at Sekolah Plus Pelita Insani Parung, where administrative and financial records were managed using spreadsheets, resulting in data duplication, reporting delays, and limited integration between student and financial data. This community service activity aims to develop a web-based e-system for student data and school financial management using the Streamlit framework, equipped with automated administrative reporting features. The implementation method included initial consultation, field observation, system design and development, system implementation, and training for administrative and financial staff. The developed system supports multi-user access, integrated student and financial data management, automated report generation, and data visualization to assist decision-making. The results show that the developed e-system successfully improves the efficiency and accuracy of administrative and financial data management. School staff were able to generate periodic reports more quickly and manage data in a centralized and structured manner. This system contributes to the digital transformation of school administration and enhances transparency and accountability in financial management.
Co-Authors Anggie Syahputra Auzriel Zidan Arby Barren Al Faridzi Faiz Rizqi Hanafi Farizi Ilham Lilis Roudhotul Jannah Milani Nuril Sandi Muhammad Rizky Ramadhan Nandang Adriansyah Nardiono Shanasha Aulia Dianthi Syerikha Ananda Zaqhluul Farhan