Bulk upload allows you to easily send all your provision in a single file. The Comma Separated Values (CSV) format used is simply a series of rows and columns, and can be exported from many information management systems, or simply prepared using spreadsheet programs such as Microsoft Excel. Preparing your first bulk upload will take some work, but once you've set it up, it is a simple way to keep all your information up to date.
If you’re a provider only uploading provision run by you, please note that each time you upload, all existing provision will be deleted and replaced with what you’ve uploaded. If you’re uncertain, you can always back up your existing provision using the “Download CSV” function on the Bulk Upload page. This gives you file containing all your provision in bulk upload format that can be uploaded at any time.
If you’re a provider who is a member of one or more Organisations, you can upload provision that you run for that Organisation or promote under that Organisation’s brand. The Opportunity fields OFFERED_BY and DISPLAY_NAME are used for this. OFFERED_BY should be set to the ID of who has the contract with the Agency for this opportunity, and DISPLAY_NAME should be set to what name you wish learners to see on the National Careers Service site. If they are different, you can choose to have both searchable if you wish using BOTH_SEARCHABLE. You can see all Organisation IDs on the Organisations screen.
Note if you do not include any provision for a particular Organisation in an upload file, any existing provision you run for that Organisation will be preserved. Only if at least one opportunity for that Organisation is included will your provision be affected. This also applies if you only upload provision offered by yourself directly – any existing provision for Organisations will be preserved. If you need to delete all your provision for a Organisation or for yourself, please contact the service desk.
If you’re an Organisation superuser, you can upload provision for your member providers in the same way they do (if they have allowed you to do so), except you must preface each bulk upload file with the Provider ID. Click here to download an example. All member Provider IDs can be viewed on the Organisation home screen. You can put one, some or all of your providers in a single file.
Step 1: Read the Data Standards & Help Guide
The Data Standards list the name and format of every piece of data used in the Course Directory. Not all fields are mandatory, but the more you supply, the more useful your data will be to learners. The Help Guide contains instructions on how to use Bulk Upload. For fields such as Study Mode, you will need to supply a code rather than the value itself. For example, instead of "Full Time", your file will contain "SM1", A complete list of fields requiring codes and the codes themselves can be found in Appendix 2 of the Help Guide.
Step 2: Understand the file format and create your file
Bulk upload files are in Comma Separated Values (CSV) format with a defined column and section order. You can review a blank example with headers only and an example with test data. This page always has the latest versions. Previous versions may not work. Take careful note of the following:
Step 3: Save & upload your file
Your file may be named anything, but must have the extension .csv. Once uploaded it will begin processing immediately. The time to process the file will depend on the size of the file, complexity of the information and the time of day.
Step 4: Review errors and re-upload if necessary
If your file contains errors, the entire file will be rejected and no data will be published. You will likely have errors the first time you try an upload, and will likely need several attempts to get it exactly right. The errors are reported on the Provider Portal. The error list is broken down into Provider, Venue, Course and Opportunity errors and where possible a line number is given. You will be sent an email on the same day as the upload if it contains errors. You will not be sent an email the same day if your file is processed successfully without error. You will receive an email overnight to say your data has been published successfully to the Provider Portal and learner websites.