Upload Files

From UnionCloud Support
Revision as of 11:48, 28 October 2015 by Ash (talk | contribs) (Created page with "Uploading Files, (CSV's) is one most common ways Unions import data into the system, and there are currently four different areas you can upload data to the system for current...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Uploading Files, (CSV's) is one most common ways Unions import data into the system, and there are currently four different areas you can upload data to the system for currently.

  • Upload Student File - To upload bulk groups of your students to Union Cloud
  • Upload Programme File - To upload a list of courses, course codes, departments, and schools/colleges to Union Cloud
  • Upload Member File - To upload members to a group, if for example people paid membership for a Club / Society in cash, and you wanted to add them to Union Cloud
  • Upload Club Admins File - If you have run elections separately to Union Cloud, but you want to upload groups of students as admins for certain Clubs / Societies

The first thing we need to say, and is rather important, is that all CSV File uploads, are processed over night, the same day they are uploaded. So long as your upload is complete by around 23:45 on any given night, the file will be processed just after midnight, depending on the size of the files, and how many other unions are also processing large numbers of uploads, the speed at which this is processed will vary.

We recommend that any editing you plan to do of CSV's is done in Excel, and when saving the file type you choose which file type to save, choose comma-delimited, comma separated values file, not the tab-delimited type. It is always worth downloading the CSV template for the for the particular file you wish to upload from the Upload Files section, as this saves coming up with any unnecessary errors.

Upload Student File

Upload Student File Screen

This is the primary, and most common method that Unions use to get data into Union Cloud, a CSV Upload, though there are two other methods of getting the data, one is through allowing manual registration, which you can filter by certain email extensions, for example only allow emails that have .ac.uk endings, or the third method is you can have data added to your site automatically, by a data transfer using SOAP, or JSON (if this is something you'd like to move to your lead Union Cloud contact should speak to us about it).

These files that yo upload make up the majority of your members, and after upload, can all be found in the User Account Details section. The fields for the Student Upload are

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
id* forename* surname* dob* gender institution_email* nationality domicile_country fee_status hall_of_residence programme_id study_type programme_level start_date end_date record_type alternate_email_address library_card department erasmus ethnicity finalist mode_of_study placement address postcode
501 John Smith 30/04/1983 male john.smith@domain.ac.uk IND GBR UK INDLC PRG001 PGT 1 10/10/2012 31/05/2020 new abc@email.com L12345 EL Y Full-Tiime R 123 Street Example Example Example
Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example

Upload Programme File

Upload Programme File Screen

The

Upload Member File

Upload Member File Screen

Upload Group Admins File

Upload Group Admins File Screen