Using the data importer tool

Importing mass data to generate social impact data

Siddesh Iyer avatar
Written by Siddesh Iyer
Updated over a week ago

Note: If you are using the importer tool to add data about participants, please make sure you have considered if it might be easier for you to invite participants to SportFin so we can collect the data for you directly - this is the easiest way to add data about your participants. Read this guide.

To use the importer tool, navigate to your club management tab, then click the "Add Data" button. From here you will be redirected to the data importer tool.

You can use the importer tool to:

  • Add data about the people who are a part of your club by uploading a CSV file.

  • Add multiple check-ins at once to add data for impact analytics.

Add Club Members/Participants

When selecting 'Add Club Members/Participants' you can upload a CSV file with member and participants data quickly and easily.

When preparing your CSV document, you may utilize the tools and information in the highlighted blue tab. Here you can find a downloadable CSV template to help guide you through what information is necessary.

Next, you need to match the columns in you CSV file to what data point they correspond to. Once you have marked all your columns and fixed errors that show up, you can import all your data by clicking the 'Import Data' button.

If you are using your own CSV file, make sure to include the required and recommended information for best impact data results.

Required Data Points

To import people, you will be required to provide the below data points for each person:

  • First Name

  • Last Name

  • Email address

  • Date of Birth

Data Points for Impact Analytics

You can further add the following data about each person in your CSV to allow us to generate impact analytics for them:

  • Gender: Select between:

    • 'Male'

    • 'Female'

    • 'Other'

  • Biological Sex: Select between:

    • 'Male'

    • 'Female'

  • Height (in centimeters): Positive Integer between 30 and 272.

  • Weight (in kilograms): Positive Integer greater than 3.

  • Ethnicity: Select between:

    • White - British

    • White - Irish

    • Traveller of Irish heritage

    • Any other white background

    • Gypsy / Roma

    • White and Black Caribbean

    • White and Black African

    • White and Asian

    • Any other mixed background

    • Indian

    • Pakistani

    • Bangladeshi

    • Chinese

    • Any other Asian background

    • Black Caribbean

    • Black - African

    • Any other Black background

    • Any other ethnic group

  • Participation Rate: Select between:

    • Less than 30 minutes per week

    • Between 30 to 89 minutes per week

    • Between 90 to 149 minutes per week

    • Over 150 minutes per week

  • First Line of Address: UK addresses only.

  • Second Line of Address: UK addresses only.

  • City/Town of Address: UK addresses only.

  • Postcode of Address: UK addresses only.

(Note: you will be able to find all this data in the blue support button on the 'Add club members/participants' section of the importer tool)

Fixing Errors

Should an error pop up when you import your data, you will have two ways of fixing it.

1. The first way to fix an error is through the drop down selection. This pop up will show up if you are able to select a data point from a set list of correct responses.

2. The second way to fix an error is through the fill in the text option. This will pop up if you have entered a data point outside the normal threshold. Once you have fixed the data point, you will be able to import the data.

Successfully Importing Data

Once all the information is completed and correctly put in, you may hit the 'Import Data' button to submit it and start generating your impact data.

Adding Check-Ins

In the data importer tool you also have ability to conduct check-ins for your activities. This new tool was developed to streamline and ease the process of check-ins.

After opening the importer tool, select 'Add Check-ins' button. You will automatically be directed to the page show in the image below.

Here you can create check-ins for staff and participants that attended multiple activities at once. Just select participants and staff by clicking on their name, and select the activities they attended by clicking on the activity names in the right.

Then, click the 'Add Check-Ins' button to create check-ins. After creating check-ins, your impact analytics will be generated.

Read this article to find out more about SportFin's impact analytics.

Did this answer your question?