HOW TO UPLOAD MEMBERS IN BULK VIA CSV FILE
Note that the format of the CSV provided below and the things to note when filling it, as stated in number 2 and 3, must be FULLY adhered to, else data will be inserted incorrectly!
(1) Download the CSV file for inputting the details of the members in bulk HERE
(2) In the course of filling the details of the members in bulk - prayer group, deanery, diocese, position and province name will be needed. Click here to see how to properly add these details
(3) When filling in the details of the CSV file, the following should be taken into consideration:
(2) In the course of filling the details of the members in bulk - prayer group, deanery, diocese, position and province name will be needed. Click here to see how to properly add these details
(3) When filling in the details of the CSV file, the following should be taken into consideration:
| S/N | COLUMN | FORMAT | SAMPLE | NOTES |
|---|---|---|---|---|
| 1 | DOB | Day Month FullYear | 07 May 2025 | If the day of birth of the person falls between 0-9, the day must be preceded by a zero. e.g 06, 08 and also ensure that the name of the month and the year is written in full such as January, June, May, 2025, 2019 etc |
| 2 | Gender | Male or Female | Male or Female | The gender of the member must either be male or female |
| 3 | Phone number | - | 08123456789 | Ensure that the phone number is valid and must be made up of only numeric characters as subsequent updates will be periodically sent as SMS to members |
| 4 | Email address | - | support@ccrnigeria.org | Ensure that the email is a valid one as subsequent updates will be periodically sent to members |
| 5 | Date Joined CCRN | Day Month FullYear | 07 May 2025 | If the day the person joined CCRN falls between 0-9, the day must be preceded by a zero. e.g 06, 08 and also ensure that the name of the month and the year is written in full such as April, July, May, 2025, 2019 etc |
| 6 | Done life in spirit seminar | Yes or No | Yes | This field must either be yes or no |
| 7 | Marital status | Single or Married | Married | This field must either be single or married |
| 8 | Baptism, Communion, Marriage, Holy Order, Religious, Sacrament | Yes or No | Yes | Each of these fields must either be yes or no |
| 9 | Exco in prayer group? , Exco in deanery? , Exco in diocese? , Exco in province? , Exco in national? , Exco in NEC? , Deanery wing leader?, Diocese wing leader?, National wing leader?, Other national duty?, International duty? | Yes or No | No | Each of these fields must either be yes or no |
| 10 | Prayer group, Prayer group position, Deanery, Deanery position, Deanery wing position, Diocese, Diocese position, Diocese wing position, Province, Province position, National position, National wing position, Other national duty position, International duty position, NEC position | The ID of each of these fields must ONLY be supplied. Click click here to see how to properly add these details | 4 | - |
| 11 | Start Year and End Year | 2025 | 2025 | All column which has start year or end year as part of the heading title must be in a full year format such as 2025, 2019 etc |