Page History

This page primarily allows the import of new person records, but can also be used to bulk update certain information for existing records. A file (in a particular format) can be uploaded which and can contain a mixture of new (which that have no ID supplied) and existing (which that have an ID supplied) person records.

...

This section allows you to generate an import template file in the correct format - which that may optionally include current data to update.

...

Click the Download import file template link, and save the file to your hard disc. The file will be in tab delimited format with a header row.

...

• Open the file - recommend in Microsoft Excel. Each data field should be in a separate column. If using a text format such as CSV/TSV, and opening in Excel, care should be taken that Excel does not convert text columns that look like numbers (eg e.g. mobile phone numbers) to numbers which that may result in loss of information. Consult the Excel help on how to import text documents and override the data types of certain fields.
• Remove records (rows) in the file that you do not wish to change by deleting the entire row. If you are importing only new records, then delete all rows except for the headings.

• If importing/updating custom fields, then you can remove custom fields you don't want to import/update.
  For example, if the template you downloaded includes 4 custom fields, and you only want one, then delete the other 3 custom field headings, and data relating to these, for all rows of information. If importing custom fields, the Import Custom Fields checkbox must be checked, otherwise any custom fields present in the import file will be ignored.

  Note
  Do not remove any Standard Field information or headings from the import file.

• Change the appropriate information for existing records (if any). First and last names cannot be changed by this process, and changes to these fields will be ignored.

  Hint:

  Tip
  You may be able to copy and paste from existing data files you may have.

• Add the appropriate information for new records (if any). For new records, first and last names must be specified and the ID field must be blank.
• Save the file in Excel (or text) format.

...

This is optional. You only need to download helper files if you want to import certain custom information, for example, roles, registration type and participant team lists. The helper file will provide you with a list of correct roles, names, team names and registration type types to fill in the import file for both existing and new records. 

...

Tick this checkbox if the import file contains custom fields.

Data Updating (for existing records)

These options determine the behavior when updating existing records from the import file. It is not relevant for importing new records. 

• Overwrite ALL data - any  

  Warning
  Use with care! Any blanks in the import file will be written, which could lead to loss of data.

  Use with care!

  
  
  Example:

  Home phone	Work phone	Mobile phone
  Value for Player X in database	9399 9999	9488 8888	0411 111111
  Value for Player X in import file	9877 7777	(blank)	0411 111111
  Value for Player X in database after file is imported	9877 7777	(blank)	0411 111111

• Only overwrite missing data - only fields that have been provided in the import file AND are missing from existing data will be written. This option means that you can leave fields blank in the import file without overwriting existing data.
  
  Example:

  	Home phone	Work phone	Mobile phone
  Value for Player X in database	9399 9999	9488 8888	0411 111111
  Value for Player X in import file	9877 7777	(blank)	0411 111111
  Value for Player X in database after file is imported	9877 7777	9488 8888	0411 111111

...

A Role and at least one sub role must be selected. This only affects new person records. These selections are used for: 

• These roles are added to any new records. Existing records do not have their roles modified.

  Note: the

  Note
  The Bulk Change Roles

  screen

  screen can be used to change roles of existing records

  .
• If the Import Custom Fields option is checked, then custom fields that apply to these roles can be imported.
  
  

Registration

Tick the check Registration box if you want to register people as part of the import process.

Untick Un-tick the check Registration box if you do not want to register people as part of import process.

Importing the data

Once all options have been selected, including the file to import, click the Upload and Preview button. The system will validate your choices, and if import is possible, a preview screen will display. This screen lists data for the records present in your import file, and gives an indication of what the values of each field will be after the import.

At the Preview screen, you can click the Re-upload file to make changes to the import file and reload into the Preview screen.

Once you have reviewed the data in the Preview screen, click the Import Data button to save your changes to the database. Any records that have been marked as in error (in red) will be skipped. Once imported, changes cannot be undone, although data can be re-imported, and/or individual records can be edited in the usual way. A final confirmation screen displays after import which that indicates the import status of each row with colour-coding, the same as in the Preview screen.

...

• Microsoft Excel (97 onwards) Excel (97 onwards) file:
  • The data can be in any Worksheet within the imported workbook, however the name of the Worksheet containing the data must be specified exactly in the Worksheet Name text box (this is case-sensitive). Alternatively, leave this field blank to automatically use the first worksheet in the workbook.
  • The Worksheet must contain data for standard fields in columns 1 to 19 as per the Field order specified below. If custom fields are being imported, these are supplied in columns 20+ onward. However, most data is optional, and does not need to be supplied in each column.
  • Header row - a row containing the field names. Field names in the header row for standard fields are ignored. If custom fields are being imported, the field name as obtained from the downloaded template must not be changed.
  • If data is not available for a particular field for a record, leave the appropriate cell empty.
  • Use one row per record - ID numbers must not be repeated. Use as many rows as required and leave all subsequent rows blank.

...

Further information about whether a field is mandatory, and the allowable values can be found within the_Required file format and validation rules_ table which displays during the import process. The same validation rules apply irrespective of whether records and are added/modified using the bulk import process, or manually editing records one by one using the person edit screen.