Schedule Upload Tips
This Tip Sheet accompanies our Upload Guide (PDF). We've tried to make Uploading as simple as possible. If you need any help, please contact us.
Quick Guide
- Prepare an Excel file in one of our two standard formats - (one date per row, dates in columns) containing fields such as Course Code, Course Location, Course Date, Price, Duration and Course name/title.
- Save the spreadsheet file as an XP/2003 file.
- Login to www.coursemonsterdata.co.uk
- Select - "Upload Schedule" or "Outlines" type
- Select the Excel Spreadsheet on your computer system, that you wish to upload (browse)
- Click on the spreadsheet format on our upload form that your spreadsheet has been created in (one date per row, dates in columns or outlines)
- Click upload
You can also use CourseMonsterData® to:
- View/download your existing schedule
- Amend, add or delete Training Courses and/or dates
- Amend or add Training Course Locations
- Amend/Add Training Centre locations, including travel information and other information which delegates may find important
- Edit or add your contacts and contact information
Format 1 - Row Format Spreadsheet
(One date per row)
Use this format if a new row is used for every scheduled course date.
Make sure that your columns all have a Header Row, these can be whatever you like and to explain what each column contains, but are generally similar to those listed below:
| Column A |
Course Code (even above an empty column, if you don't use codes) |
| Column B |
Location |
| Column C |
Date (Please ensure that you use the UK format DD/MM/YYYY) |
| Column D |
Price (Please ensure that the price excludes VAT) |
| Column E |
Duration (or No of Days) |
| Column F |
Course Name/Title |
Format 2 - Column Format Spreadsheet
(Course dates in Columns)
Use this format if your course dates are created in one column for every month.
As for Format 1, make sure that your columns all have a Header Row. If you have multiple dates for the same course, make sure that you use a "comma" to separate the course dates. The Header Row Columns, should be headed:
| Column A |
Course Code (even above an empty column, if you don't use codes) |
| Column B |
Location |
| Column C |
Price (Please ensure that the price excludes VAT) |
| Column D |
Duration (or No of Days) |
| Column E |
Course Name |
| Column F |
Month/year (i.e. Apr 09) |
| Column G |
Month/year (i.e. May 09) |
| Column H |
Month/year (i.e. Jun 09) |
| Column I |
Month/year (i.e. July09) |
| Column J |
Month/year (i.e. Aug 09) |
| Column K |
Month/year (i.e. Sep 09) |
Remember:
- When "uploading" new course dates, please ensure that the dates are new dates and not dates that we already have
- If uploading in "Column Format", don't forget to add a "comma" if assigning multiple dates (i.e. 12,15,21)
- If uploading in the "Row Format Spreadsheet", don't forget to ensure that the course date is in the UK format. If a course has a training date of 01/03/2009 (1st March 2009), if the date column is formatted in the USA format, our systems will read the date - 3rd January 2009.
- Don't forget to include VAT in the price of the training course.
- Remember to include the "Course Code", this makes it easier for us to match up previously submitted courses.
Uploading Course Outline Content
Course Outline contents are used to send to delegates as part of their joining instructions, and are a useful confirmation to the delegate of what to generally expect from the training course.
The Course Outline is just as important as the scheduled dates to ensure that the delegate is prepared.
When uploading Course Outline Content, please ensure that you use header rows in your spreadsheet. These can be whatever you wish and are just to give an explanation of what each column contains, three Header Rows is sufficient. Examples of "Header Rows" could be:
| Column A |
Course Code (even above an empty column, if you don't use codes) |
| Column B |
Course Name |
| Column C |
Outline |
Remember:
- Use HTML format when inserting the text/copy of the Course Outline;
- We suggest following our Standardised Headings for Outlines »
- The course outline headings should be surrounded with the HTML coding: <H3> and </H3>
Just before the beginning of a Course heading, insert <h3> and at the end of the heading insert </h3>.
For example, the course "Overview" would be <h3> Overview</h3> followed by the description/overview paragraph of the course. "Audience" would be <h3>Audience</h3> followed by a description paragraph of the "audience" and so on.
- Paragraphs should be surrounded with HTML: <p> and </p>
- Please make sure that you only use one column & one row for each section i.e. don't use multiple rows for each description
- If you are still confused about inserting HTML coding, please contact us. We'll try and work together to explain the coding or for a way that you can provide your outlines in another format.