A CSV parsing program for SAC data coming from LGUs. This program is still on its development stage.
These are the steps needed to make sac parser running on your local machine:
- You need to download the program.
- Then, you need to have a web server to set-up it quickly, you can use usbwebserver.
- Copy the sac-parser folder in the root folder of the usbwebserver.
- Then, access the program by running the usbwebserver.exe and enabling the Apache by navigating to Apache > Start.
- It is recommended that before performing sanitization or cleansing you need to check duplicates first.
- Also, it is recommended to remove duplicate barcodes because this will be returned to the LGU. After removing duplicates, you can now perform cleansing by clicking the Perform Sanitize button. A cleansed data by means of a csv file will be downloaded automatically. Then, you can now upload the csv file in the SAC Uploading website.
Version 1.0
- Checked barcode duplicates
- Sanitize and format birthdate
- Relationship to the household head, Uri ng ID, Sector and Kondisyon ng Kalusugan Finder
- Proper tagging of Nakakatanda Sektor (dependent to birthdate)
- Cellphone number checker
- Fill-out blank Household head fields such as Benef UCT, Benef 4Ps, Katutubo, Katutubo Name, Bene Others, Others Name, Brgy. Capt and MSWDO
- Compute buwanang kita includes words with per day, per week etc.
Version 1.1
- Removed special characters excluding dash for names
- Removed extra blank rows created
- Reformat registration dates
Version 1.2
- Updated various functions and performed code cleansing.
- Fixed various issues such as issues number 1, 2 and 3.
Version 1.3
- Solved multiple issues raised by focals and personnel, please refer to SAC Parser Issue.
- Added better cleansing technique for Barangay PSGC, Relationship to Household Head and other fields.
- Important patches were included, please upgrade your version.