Claim Missing Document
Check
Articles

Found 34 Documents
Search

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 Vol. 4 No. 2 (2026): Juni : Router : Jurnal Teknik Informatika dan Terapan
Publisher : Asosiasi Profesi Telekomunikasi dan Informatika Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62951/router.v4i2.887

Abstract

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.
Rancang Bangun Aplikasi form online untuk pemesanan dan pengadaan barang internal pada Puskesmas Cogreg Duta Agung Pramana; Farizi Ilham; Mohammad Hadi Purnomo; Zacky Nurfaqih Permana
Modem : Jurnal Informatika dan Sains Teknologi. Vol. 4 No. 3 (2026): Juli : Modem : Jurnal Informatika dan Sains Teknologi
Publisher : Asosiasi Profesi Telekomunikasi Dan Informatika Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62951/modem.v4i3.889

Abstract

The rapid growth of information technology has driven healthcare institutions to modernize their data management and administrative workflows. Puskesmas Cogreg, a primary healthcare facility, still depends on manual procedures for internal goods ordering and procurement. This practice generates recurring operational problems: records remain disorganized, documents are prone to loss, and approval workflows frequently experience delays due to the lack of a centralized digital system. To resolve these issues, this study designs and builds a web-based online form application using the Waterfall method, which progresses sequentially through five stages: requirements analysis, system design, implementation, testing, and maintenance. The application equips medical staff with a digital request submission feature, enables warehouse heads to verify and approve requests, and provides real-time procurement status tracking for all authorized users. System validation used black-box testing across 24 functional scenarios, all returning results consistent with expected outputs. The application demonstrably improves procurement efficiency, reduces recording errors, accelerates approval decisions, and produces a more structured, transparent, and accountable administrative process at Puskesmas Cogreg.
Perancangan Dan Implementasi Sistem Informasi Customer Relationship Management (CRM) Berbasis Web Pada CV Anugerah Interindo Ilham Sholahuddin; Farizi Ilham; Muhamad Farhan; Muhammad Fathan Antony
Router : Jurnal Teknik Informatika dan Terapan Vol. 4 No. 2 (2026): Juni : Router : Jurnal Teknik Informatika dan Terapan
Publisher : Asosiasi Profesi Telekomunikasi dan Informatika Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62951/router.v4i2.880

Abstract

CV Anugerah Interindo is a company engaged in interior design, providing various products such as curtains, upholstery fabrics, and wallpaper. Currently, the company does not have a system to record and manage customer data in a structured manner. As a result, customer data management and interaction history are still handled manually, leading to difficulties in recording, searching for customer information, and monitoring the sales process. The purpose of this internship project is to design a web-based Customer Relationship Management (CRM) application to help the company manage customer data and sales processes more effectively. The development method used is the SDLC Waterfall model, which includes requirement analysis, design development, implementation using Laravel as the framework and MySQL as the database, testing, and maintenance. Data collection was conducted through observations and interviews with the company’s operational manager. The project scope includes eight main features: (1) customer contact management, (2) a Kanban-based sales pipeline, (3) activity management and follow-up scheduling, (4) customer interaction history, (5) quotation management, (6) sales reports, and (7) data export to Excel. The expected result is the development of a CRM system capable of storing and managing customer data, facilitating interaction recording, and helping monitor the progress of the sales process in a more structured manner.
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 Vol. 4 No. 2 (2026): Juni : Router : Jurnal Teknik Informatika dan Terapan
Publisher : Asosiasi Profesi Telekomunikasi dan Informatika Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62951/router.v4i2.887

Abstract

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.
Co-Authors Aditya Ikhwanul Ikhsan Adrian Agam Lintang Praja Ahmad Galuh Maulana Aldy Dharmawan Alfan Halyan ANDRI KURNIAWAN Arjuna Duta Persada Aziz Ripkal Mutaqin Bagus Nurcandra Wijaya Bayu Dwi Putra Bayu Eka Saputra Bryan Niko Mahendra Chikal Faqih Muharom Daffa Ahmad Rasula Darma Eko Prasojo Dimas Lendensi Dimas Sugiana Diyat Ilham Mustakim Duta Agung Pramana Dzikri Al Hafidz Erick Tarantino Fadhil Nur Rochim Fardian Zahri Chaniago Fariz Areyhan Fariz Faqih Farshal Revolino Fathan Mujaddid Akmal Fico Muhammad Firdaus Filzah Mutiah Fito Wahyu Pratama Halili Maar Heru Setio Wibowo Idham Mustaqopul Fikri Ilham Sholahuddin Imam Malik Sya’roni Indah Mardianti Tanjung Iqbal Zaka Firdana Irene Mareta Widya Ningtyas Juan Ewaldo Lingga Kevin Novebrianto Kian Fajar Alam Kresno Adi Kuncoro M. Alif Rahadiansyah M. Keysa Herdiansyah M. Sahrul Ajis Mahmud Abas Mas Albar Ajibaskoro Mathew Nathaniel Lawalata Michael Marsello Serang Miftah Nur Fadlilah Anwar Moch Rais Kabilah Miftahuzen Mochamad Averoes Fasha Mochammad Rizqy Hidayatullah Mohamad Arif Rahmadhani Mohammad Hadi Purnomo Morista Amelia Putri NingTias Muhamad Farhan Muhamad Nuno Muhamad Sidik Muhamad Syahdan Muhamad Yunus Saputra Muhamad Zaldi Muhammad Fathan Antony Muhammad Fikri Nurwibowo Muhammad Parvez Bahiyuddin Nasrul Abdul Karim Noorza Adi Nugroho Nur Annisa Ahmad Nurul Hidayatul Atika Pipin Haeriyanti Rafina Otla Pratiwi Raihan Rajesh Syawal Ferdinan Ricky Rifaldy Rizal Pujiwijaya Rohmat Iktafal Maarif Rosidin Fahmi Abdillah Sabrina Febrian Komala Dewi Shauma Wahyu Saputra Sherlinda Irdianov Shifa Afifah Sigit Pratama Sitiyani Basuki Sofyan Rizky Andra Effendi Suhail Fadhlu Ramadhan Tegar Ramadhan Tripriya Setiawan Tijan Daruri Triningsih Widi Ananda Wibowo Zacky Nurfaqih Permana Zaki Ramliza