UPDATE NIS SISWA DI SISTER

1. Convert File Excel (.xlsx) Menjadi CSV

Cara A — Menggunakan Microsoft Excel

1. Buka file .xlsx.
2. Pastikan kolom hanya berisi:
   • Kolom A: OLD_NIS
   • Kolom B: NEW_NIS
     Contoh:
   OLD_NISNEW_NIS101010202020101011202021……
3. Klik File → Save As
4. Pilih tipe file → CSV (Comma delimited) (*.csv)
5. Simpan dengan nama: nis_update.csv

Selesai! File CSV siap dipakai

2. Script SQL Update NIS di 17 Tabel Menggunakan map_nis

Langsung copy & paste ke MySQL / MariaDB CLI atau phpMyAdmin.

— 1. KEJADIANPENTING
UPDATE kejadianpenting k
JOIN map_nis m ON k.NIS = m.old_nis
SET k.NIS = m.new_nis;

— 2. RATAUS
UPDATE rataus r
JOIN map_nis m ON r.NIS = m.old_nis
SET r.NIS = m.new_nis;

— 3. RIWAYATKELASSISWA
UPDATE riwayatkelassiswa rk
JOIN map_nis m ON rk.NIS = m.old_nis
SET rk.NIS = m.new_nis;

— 4. PHSISWA
UPDATE phsiswa p
JOIN map_nis m ON p.NIS = m.old_nis
SET p.NIS = m.new_nis;

— 5. KOMENRAPOR
UPDATE komenrapor kr
JOIN map_nis m ON kr.NIS = m.old_nis
SET kr.NIS = m.new_nis;

— 6. TAMBAHANDATASISWA
UPDATE tambahandatasiswa t
JOIN map_nis m ON t.NIS = m.old_nis
SET t.NIS = m.new_nis;

— 7. MUTASISISWA
UPDATE mutasisiswa ms
JOIN map_nis m ON ms.NIS = m.old_nis
SET ms.NIS = m.new_nis;

— 8. NAP
UPDATE nap n
JOIN map_nis m ON n.NIS = m.old_nis
SET n.NIS = m.new_nis;

— 9. PPSISWA
UPDATE ppsiswa ps
JOIN map_nis m ON ps.NIS = m.old_nis
SET ps.NIS = m.new_nis;

— 10. PPSISWAHADIR
UPDATE ppsiswahadir ph
JOIN map_nis m ON ph.NIS = m.old_nis
SET ph.NIS = m.new_nis;

— 11. RIWAYATDEPTSISWA
UPDATE riwayatdeptsiswa rd
JOIN map_nis m ON rd.NIS = m.old_nis
SET rd.NIS = m.new_nis;

— 12. RIWAYATFOTO
UPDATE riwayatfoto rf
JOIN map_nis m ON rf.NIS = m.old_nis
SET rf.NIS = m.new_nis;

— 13. KOMENWALAS
UPDATE komenwalas kw
JOIN map_nis m ON kw.NIS = m.old_nis
SET kw.NIS = m.new_nis;

— 14. ALUMNI
UPDATE alumni a
JOIN map_nis m ON a.NIS = m.old_nis
SET a.NIS = m.new_nis;

— 15. KOMENNAP
UPDATE komennap kn
JOIN map_nis m ON kn.NIS = m.old_nis
SET kn.NIS = m.new_nis;

— 16. NILAIUJIAN
UPDATE nilaiujian nu
JOIN map_nis m ON nu.NIS = m.old_nis
SET nu.NIS = m.new_nis;

— 17. NAU
UPDATE nau ns
JOIN map_nis m ON ns.NIS = m.old_nis
SET ns.NIS = m.new_nis;

— 18. SISWA
UPDATE siswa ss
JOIN map_nis m ON ss.NIS = m.old_nis
SET ss.NIS = m.new_nis;