Data Migration - Data Cleaning Guideline

MOE App / File / Cleaning Guidelines
SMM / TMURID /
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.
  • Custom ‘Tarikh Lahir’ field with ‘dd/mm/yyyy’
  • Add ‘0’ infront of ‘No Telefon’. Example : 196452341 change to 0196452341
  • 2decimal for ‘Agama’ field. Example : 02
  • Must fill the blank field for PBAPA,PIBU,PJAGA,KBAPA,KIBU,KJAGA,BILAHLI,BILBELAJAR,BILSPBT,BILRMT and BILASRAMA. At least put ‘0’ or ‘TIADA’
  • Custom ‘Kemaskini’ field with ‘dd/mm/yyyy’
  • Remove trailing timestamp 00:00:00 at end of each record [ ‘Tarikh Lahir’ and ‘Kemaskini’ field ]
  • Change file to csv format.

BMM / TWARIS / Remove trailing timestamp 00:00:00 at end of each record
EMIS / EkspStaff.txt /
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.
  • Custom all date field with ‘dd/mm/yyyy’
  • Add ‘0’ infront of ‘No. Telefon’. Example : 196452341 change to 0196452341
  • 2decimal for ‘Agama’ field. Example : 02
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Change file to csv format.

EkspElaun.txt /
  • Change extension to csv format.
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EkspIkhtisas.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EkspKelulusanAkademik.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EkspLDP.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EkspPengalamanAjar.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EkspSejarahPerkhidmatan.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EkspTugasKhas.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.

EMIS / EkspMatapelajaran.txt /
  • Change extension to csv format.
  • Remove trailing timestamp 00:00:00 at end of each record [ All date field ]
  • Custom all date field with ‘dd/mm/yyyy’

SSDM / Kes.txt /
  • Ensure no spaceinbetween IC / Birth date.
  • Change extension to csv format.
  • All ‘Kad Pengenalan’ field should change to ‘0’ decimal.