Follow

Bulk Re-Register Members

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.

 

Step 1

    • 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.
    • #Forename
    • #Surname
    • #Member ID - the 7 digit number stored with a member when they are added to the system.
    • #LGFA Player Type - must be 'Player' or 'NonPlayer'.
    • #LGFA Member Type -
      • If LGFA Player Type = 'Player', Member Type must be: U10, U12-U18, Adult, G4M&O.
      • If LGFA Player Type = 'NonPlayer', Member Type must be: Team Official, Match Official, Administrator, Coach.
    • #Parental Consent - can be Y or N.
    • #InjuryFund - can be Y or N.

 

NOTES :

      • 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.
      • Do not insert a '#' key anywhere else in the spreadsheet other than the Column headings.
      • All columns must be filled in.

 

      1. Edit the fields for each member you would like to re-register with the correct information.
      2. Once the spreadsheet is complete click 'File' and 'Save As'.
      3. Give the spreadsheet an appropriate name, ensure the file type is 'CSV (Comma Delimited)'.
      4. Once you are aware of where you are saving the file to (e.g Desktop, My Documents) click 'Ok'.

 

Step 2

      1. On the LGFA Management system, Click 'Choose file' as shown in Figure 1.
      2. Locate the Bulk Reregister Members file on your computer, click on the file name.
      3. Click 'Open'.
      4. 'File Ready to Upload' will appear beside the attachment.

 

Step 3

      1. Click 'Preview'.
      2. The Preview page will show you -
        • Total Number of Members Previewed.

        • Total Number of Members with Good(valid) data.

        • Total Number of Members with Bad(invalid) data.

        • Hover over the column names to see the validation for each column.
      3. Members who's data is invalid will be marked with a red '!' and will not be imported.
      4. Click 'Import' to import the members who's data is valid.
      5. A drop down will appear announcing the number of members who were successfully registered and the number of members that were not registered due to errors.
      6. After this, the page will display a table of the members who were not imported. You can click 'Export Bad Records' to export the 'Bad Records' to another Excel spreadsheet were you can edit the invalid data and re-submit the spreadsheet. If you wish to do so click 'Export Bad Records'.
      7. Otherwise click 'Ok'.

Figure 2 - Bad Data Records

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.

 

    1. Correct the fields that contain invalid data.
    2. Save the file as 'CSV (Comma Delimited)'.
    3. Follow the steps above to import the corrected file.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments