EUVIMEDEUVIMED entdecken
Open Access · CC BY-SA 4.0

Rancang Bangun Sistem Import dan Transformasi Data Excel ke Database Mysql pada Koperasi Syariah Benteng Mikro Indonesia

Erick Tarantino, Farizi Ilham, Pipin Haeriyanti, Tijan Daruri

Router : Jurnal Teknik Informatika dan Terapan · 23.06.2026 · 4 (2) · 25-41

DOI: 10.62951/router.v4i2.887 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Router : Jurnal Teknik Informatika dan Terapan, online erschienen am 23.06.2026. Verfasst von Erick Tarantino und 3 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Koperasi Syariah Benteng Mikro Indonesia is a microfinance institution that manages member data, financing, and financial transactions. Currently, data processing is still largely conducted using unstructured Excel files, which often leads to data duplication, formatting errors, information inconsistency, and delays in database integration. The objective of this internship project is to design and develop a web-based system for importing and transforming Excel data to improve efficiency, accuracy, and consistency in data management.The development method uses the SDLC Waterfall model, which consists of analysis, design, implementation using Python Flask and MySQL, and testing. Data collection methods include interviews, observations, and literature studies involving administrative staff and the IT division of the cooperative.The system scope includes eight main features: (1) Excel file upload; (2) data preview; (3) interactive column mapping; (4) automatic data validation; (5) data format transformation; (6) import process simulation; (7) data import into a MySQL database; and (8) logging and reporting of import results.The expected outcomes are to reduce data errors by up to 85%, accelerate data entry processes, improve database consistency, and support structured and integrated digitalization of cooperative data.

Zitieren

APA

Tarantino, E., Ilham, F., Haeriyanti, P., & Daruri, T. (2026). Rancang Bangun Sistem Import dan Transformasi Data Excel ke Database Mysql pada Koperasi Syariah Benteng Mikro Indonesia. Router : Jurnal Teknik Informatika dan Terapan, 4(2), 25-41. https://doi.org/10.62951/router.v4i2.887

Vancouver

Tarantino E, Ilham F, Haeriyanti P, Daruri T. Rancang Bangun Sistem Import dan Transformasi Data Excel ke Database Mysql pada Koperasi Syariah Benteng Mikro Indonesia. Router : Jurnal Teknik Informatika dan Terapan. 2026;4(2):25-41. doi:10.62951/router.v4i2.887

BibTeX
@article{Tarantino2026,
  author = {Tarantino, Erick and Ilham, Farizi and Haeriyanti, Pipin and Daruri, Tijan},
  title = {Rancang Bangun Sistem Import dan Transformasi Data Excel ke Database Mysql pada Koperasi Syariah Benteng Mikro Indonesia},
  journal = {Router : Jurnal Teknik Informatika dan Terapan},
  year = {2026},
  volume = {4},
  number = {2},
  pages = {25--41},
  doi = {10.62951/router.v4i2.887}
}
Kostenlos starten →