Difference between revisions of "Load Account"

From PC2wiki
Jump to: navigation, search
m (Steps: added note about save button)
m (Optional Columns: added inst fields)
Line 63: Line 63:
|<code>externalid</code>||same as group||CSUS Hornets
|<code>externalid</code>||same as group||CSUS Hornets
|<code>longschoolname</code>||Institution Name (long) ||University of Virginia
|<code>shortschoolname</code>||Institution Name (short))||U Virginia
|<code>countrycode</code>||Country Code string ISO 3166-1 alpha-3  ||USA

Revision as of 10:15, 24 October 2016

Load Account loads/overwrites account information from a text file.


Administrator module, Accounts Tab, Load button


  1. User creates a load accounts file, use "Save" button to create a new file
  2. User uses Generate Accounts to generate accounts
  3. On the Admin, user clicks Load button and is presented with the Review Accounts Loading screen
  4. Click Accept button to apply the changes

Load Accounts File format (Version 9)

In Version 9 the load account file has been made more flexible, in Version 8 the format was fixed and had 4 fields (team #, display name, active and password) and the fields were pipe "|" delimited, see below for more details and an example.

In Version 9 the field delimiter has changed to a Tab character, a number of fields have been added and the order of the fields is determined by the new required first line of the file.

The first line of the Load Account file is a list of fields (columns) separated by tabs. The list of field names are case-insensitive.

The remaining lines of the file should be the values corresponding to the fields listed on the first line.

Lines starting with # are considered comments (ignored)

Required Columns

If any of these columns are not present on the first line a error message will be displayed.

Name Description Example
site site number 4
account description of account name (short) team5

Optional Columns

Name Description Example
password password for account foobar12
group Group name associated with account North Site
displayname Name to be displayed on scoreboard CSUS Hornets
permdisplay Account displayed on scoreboard true or false
alias Alias name to be displayed for the judges Alias 54
permlogin Account permitted to login true or false
permpassword Account allowed to change their password true or false
externalid same as group CSUS Hornets
longschoolname Institution Name (long) University of Virginia
shortschoolname Institution Name (short)) U Virginia
countrycode Country Code string ISO 3166-1 alpha-3 USA

Sample Account Load file

site	account	password	displayname
1	team1	passone	Team One

Load Account (Version 8)

Version 8 load file was limited to importing team information. Version 8 load only loaded account information for the current site.

The field delimiter is a vertical bar, not a tab.

Required Columns

Name Description Example
Team Number Team account number 4
Display Name description of account name (short) team5
Active whether account shown on board true or false
Password password for account foobar12

Example File

1|Number 1|true|pass1
2|Team Number 2|true|myPass
3|My School Name|false|

See Also