We maintain a list of foster homes including orphanages (LKSA/PSSA). The database is maintained collaborating with Forum Nasional LKSA-PSAA.
Custom App for Frappe/ERPNext
We maintain a custom app called raiseupkids. It has several DocTypes:
- Foster Home
Importing Foster Home Records from Excel File
We get list of orphanages from Forum Nasional LKSA-PSSA as Excel file. This documentation shows how to import that into ERPNext.
- Go to Foster Home List
- Click Menu > Import
- Click New Data Import
- Import Type > Insert New Records
- Download Template > Export type: 5 Records, File type: Excel, Fields: All
- Upload & open this file in Google Sheets
Some field values need to be translated:
- Jenis Pelayanan: Panti Asuhan -> Orphanage
- Status Kepemilikan:
Milik Masyarakat -> Citizen
Milik Pemerintah Kab/Kota -> Municipal Government
Milik Pemerintah Provinsi- > Provincial Government
7. Download Foster_Home_yyyy-mm-dd.xlsx
8. Upload that file to Data Import
9. Click Start Import
Troubleshooting: Partial Success. Solution: Refresh the Data Import document, and inspect the “Show Failed Logs” section.