Step by Step Guide to Bulk Re-register Members
The Bulk Re-register Members function enables the Club Administrator to re-register a large number of unregistered club members at the same time by uploading an Excel document in CSV format.
To Bulk Re-register Members -
- Go to Members > Register Members
- Click 'More Actions'
- Click 'Bulk Reregister'.
Figure 1 - Bulk Re-register Members Page.
- Click 'Click Here' under Step 1 to download and then open the pre-populated template containing last years registration details for all currently unregistered members.
- #Member ID* - the 7 digit number stored with a member when they are added to the system.
- #GAA Membership Type* - can be Full, Youth or Social.
- #Player* - can be Y or N.
- #Parental Consent* - can be Y or N.
- In order for the upload to be successful columns must be in the order shown above.
- Column Names must begin with the '#' key as shown above.
- The GAA Member Type can only be ‘Full’, ‘Youth’, ‘Honorary’ or ‘Social’.
- Parental consent is only applicable to Juvenile playing members.
- Do not insert a '#' key anywhere else in the spreadsheet other than the Column headings.
- Edit the fields for each member you would like to re-register with the correct information.
- Once the spreadsheet is complete click 'File' and 'Save As'.
- Give the spreadsheet an appropriate name, ensure the file type is 'CSV (Comma Delimited)'.
- Once you are aware of where you are saving the file to (e.g Desktop, My Documents) click 'Ok'
- Click ' Browse'
- Locate the Bulk Reregister Members file on your computer, click on the file name.
- Click 'Open'.
- Click 'Preview'.
- The Preview page will show you -
Total Number of Members Previewed.
Total Number of Members with valid data.
Total Number of Members with invalid data.
- Hover over the column names to see the validation for each column.
Export Bad Records
- 'Export Bad Records' will export the members that contain 'bad data' to a new spreadsheet to enable you to make changes to the errors.
- The fields that contain invalid data will be highlighted in red
- After the last column you can see information on how to correct the invalid data.
- Correct the fields that contain invalid data.
- Save the file as 'CSV (Comma Delimited)'.
- Follow the steps above to import the corrected file.