Child pages
  • Downloading Person List

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width60%

 

 

Column
width40%
Panel
bgColor#F0F0F0
borderWidth1

On this page

Table of Contents

Purpose

  • Search/filtering capability
  • Access to edit, delete and email records
  • Customisation of output fields (standard fields only, not including custom fields)
  • Data download/extract

Although the page gives a wide range of features, further customisation is possible by creating a Custom List. Please see the Custom List help topic for more information.

Go to Mode: Any* Menu: People -> Person List

* Except Website (SportzVault)

...

Searching for people within your organisation

...

Selecting output fields

Info

The output fields selector may be hidden. Click the Show/hide Output Fields heading to toggle the visibility of this area.

You can display up to 20 columns of information. Make a selection from the Available Fields list by clicking the Add button. Fields in the Chosen Fields list may be removed by clicking the Remove button, and can also be re-ordered by clicking the Move Up or Move Down buttons.

...

Displaying the list

Click the Display List button to search on the selected criteria, or to refresh the list at any time.
If any records have recently been transferred to your organisation, all fields except for the person name will be masked with an asterisk (*). These records cannot be viewed or edited for a period of 5 days after the transfer.

Notes:

  • Long lists are broken up into pages - in this case each page of data can be accessed by clicking the page numbers which display at the bottom of the list.
  • Sort any column by clicking the column heading.
  • Records can be grouped by dragging the column heading to the top of the list. Ungroup by dragging the heading off the top of the list.
  • 'In place' filtering of records can also be carried out by typing into the Filter List box at the top of the list, then pressing the _ Enter_ key. Clear the Filter List box and press Enter again to redisplay all records.

Downloading the list

To download the displayed data, click the Download data link which is located at the bottom of the list. You will be prompted to save the file on your local hard drive. The data is extracted as a tab separated values (TSV) file - that is, each data row is on a new line, and data fields are separated by tab characters. This type of file can be directly opened in most spreadsheet programs such as Microsoft Excel for further manipulation, or in any text editor.

...

Editing/deleting/emailing

Depending on a number of factors including the User Roles that have been assigned to your login, you may be able to access these features.

Editing a record

  • Select a record by clicking it
  • To edit, either double click the record, or right click and select Edit Record
  • The record will open for editing, you can also control whether it opens in a new window, and the active Edit tab by selecting the relevant options just above the list.

Deleting a record

  • Select a record by clicking it
  • Right click and select Delete Record
  • Note - that it is not possible to delete a record if certain information has already been entered for it, e.g. a player cannot be deleted if he/she has played in matches. The system will prevent deletion in these cases.

Emailing

...

Use this function to download person data for reporting, newsletter sending or other administrative functions.

 

There are three ways to sort and download Person Lists:

 

Expand
titleUsing person list (default)

Image Added

  1. On the Person List screen, use the standard filtering criteria such as role, sub-role, name, date of birth, gender, to create your person list to download.
  2. Click Display Output Fields link to display output field options. Select the fields you wish to download.
    Image Added
  3. Click Download Data link at the bottom of the screen.
    Image Added
  4. Select your download format option and click OK.
Expand
titleUsing custom person list

 

Image Added

  1. On the Custom Person List Management screen, select the custom person list and click View. The Custom Person List will display.

    Image Added
  2. Click Download Data at the bottom of the screen.
    Image Added
  3. Select your download format option and click OK.

 

 

Expand
titleUsing person filter
Image Added
  1. On the Person Filter Management screen, select the person filter and click Edit. The Person Filter will display.
    Image Added
  2. Click Download Data at the bottom of the screen.
    Image Added
  3. Select your download format option and click OK.