๐ฅ Import Members from CSV
CSV format matches your Excel register (ebcs.xlsx) exactly โ column A to P
๐ Column Format (A โ P)
Exactly matches your ebcs.xlsx structure
| Col | Field | Example | Notes |
|---|---|---|---|
| A | HOUSE HOLD | 1, 2, 3 | Leave blank for same household as above โ carries forward automatically |
| B | MIN | 1, 2 | Member index within household |
| C | Name | H Kaikhomang, Zamzakim | Full name โ last word auto-split as surname |
| D | Relation | s/o X, w/o X, d/o X | s/o=Male ยท w/o or d/o=Female |
| E | Date of Birth | 02.10.1971, 1977 | DD.MM.YYYY or year only |
| F | Baptism Date | 16.01.1994, tang, 1991 | tang = baptised but date unknown |
| G | Baptism Pastor | Vumsong, Khupzatun | |
| H | Marriage Date | 07.01.1996, 2023 | DD.MM.YYYY or year only |
| I | Marriage Pastor | Nangzakham | |
| J | (skip) | โ | Not imported |
| K | Givings | pia, NIL | pia=contributes ยท NIL=does not |
| L | FCM marker | 1 | 1 = Full Church Member |
| M | PM marker | 1 or blank | 1 = Probationary Member |
| N | JCM marker | 1 or blank | 1 = Junior Church Member |
| O | Obligation Date | 2005-03-10 | Optional |
| P | Remarks | Upa, Elder, Deacon | Title or free notes |
๐ก How to export your Excel file: Open ebcs.xlsx in Excel โ File โ Save As โ choose CSV UTF-8 (Comma delimited). Then upload that CSV here. Header and blank rows are skipped automatically.
โฌ Upload Your CSV