![](https://i.imgur.com/GQQ0Ear.png) ###### tags: `List Project` `reportojk` `documentation` # Pelaporan Data FDC OJK. [TOC] ## Alur Proses. ``` sequence UangTeman->DB CRO: Query data \ntransaksional\n(Exp,Outstanding & WriteOff) DB CRO-->UangTeman: CSV Format \nZIP with encrypt 'inipunyauangteman' UangTeman->FDC OJK: Send ZIP File via SFTP FDC OJK-->UangTeman: Report Result ``` ***Keterangan*** : - *Database CRO* : ```Config IP :116.206.196.7 Port :3309 User : reza_cro Passoword : Rezacro@123 Db : cro_reports ``` - *Query Data* Transaksional : ```Mysql SELECT * FROM cro_reports.upload_to_sik WHERE tgl_pelaporan_data=DATE_FORMAT(NOW()-INTERVAL 1 DAY,'%Y%m%d') ``` - Data sudah tersedia pukul 02.15 pagi. - Format CSV : | ID Penyelenggara | Tgl pelaporan data| Version| | -------- | -------- | -------- | | 820012 | 20200121 | SIK01| *Result* : **82001220200121SIK01.CSV** - Konversi ke ZIP File dan Enkripsi. ```Password Password: inipunyauangteman ``` - Kirim ZIP File via SFTP. ```ConfigSFTP Host : pusdafil.afpi.or.id Username : 820012 Password :6@Ni$&5266SvR}$s Location : folder /in sent file : 2.30 Pagi ``` - Hasil pelaporan terdapat di folder /out.