Check for Blanks in Members' Info
The steps here are used to check for blank details of members' information. You can use this to audit your OGD for missing details.
Note: The steps here require knowledge of Excel file. You can ask around or google for the steps to use certain functions.
Generate a report from OGD
Click Reports at the top menu.
Click Export Specific Fields.
Select these fields as shown here.
Click Export. This generates and downloads a CSV file to your Downloads folder.
Open the CSV file. The file name has this pattern "CFC_SpecificFields_yyyymmdd.csv", where yyyymmdd is the date when you generated the report.
Update the Audit Report Excel file
Download this Excel file (xlsx). This file has sample data to used to generate the audit report.
In Google Sheet, click File > Download > Microsoft Excel (xlsx).
Click the Temp sheet/tab.
Delete all the contents of the Temp sheet/tab.
Copy the contents of the CSV file and paste them into the Temp sheet.
Insert 2 columns to the right of CHAPTER column. These will be used when you split the Chapter column into 3.
Use the "Text to Columns" function for the Chapter name to split it into 3 columns -- Area, Cluster, Chapter.
If you do not know how to do this, check this reference.
Here is a video capture of the procedure.
At the top row
Change "CHAPTER" to "AREA".
Enter "CLUSTER" and "CHAPTER" to label their respective columns.
Click the "OGD" sheet and delete all its contents.
Click the "Temp" sheet and copy all its contents.
Click the "OGD" sheet. Go to the A1 cell and press Ctrl-V to paste all contents from the "OGD" sheet.
The Report sheet should auto update.
Update the date.
Here is a sample report:
We may have some members who do not want to have their personal data in OGD. Please refer to this guide.