Bulk update

Bulk update

To perform a bulk update on your members, you first need to export them on the "Members > View Coaches/Members/Parents" page. Click on the EXCEL button.

Once you have the exported file, edit the file then go to "Members > Bulk Update".


If you are only updating one or two fields, you can safely delete all other columns except the first one (System ID) and the column(s) you are updating.

Errors

If you receive the error "System can't read file, please check there are no blank columns", try the following:

Open the file in Excel and press "Ctrl + End (the end key)". If the active cell is past the last column in the spreadsheet, select a few columns after the last one and delete them. Then try again.



See the image above. The active cell is 3 columns past the last column (BX). What this means is that there are "blank" columns after the BX column that need to be deleted.

    • Related Articles

    • View members

      You can view a list of your members by going to "Members > View" and selecting one of the following 4 options: All coaches All members All parents All swimmers All volunteers Use the buttons to filter the table. To deactivate or archive members in ...
    • Bulk import

      To import members go to "Members> Bulk import". There are 2 steps to importing data: Upload your CSV/Excel file Match the columns in your file to the fields in the database Importing data adds NEW records each time. It does not update any records ...
    • Importing your members

      To import members go to "Members > Bulk Import". There are 2 steps to importing data: Upload your CSV/Excel file Match the columns in your file to the fields in the database Importing data adds NEW records each time. It does not update any records ...
    • Add member

      There are 3 ways to add members: 1) Adding Members Manually Click on the "Add Member" link on the navigation menu, or click on the "+ Add Member" button when viewing your members. Complete the form and click on the "Add" button at the bottom. You can ...
    • Members not attending

      Run this report to see which members haven't attended specific sessions between dates.