# Courses

Importing a course can be done in three different parts. 

1. Import Courses
2. Import Chapters
3. Import Lessons

### Import Courses

Let's start with importing the basics of a course Start with a CSV file that contains the following column names.

| Column Name | Value                                                |
| ----------- | ---------------------------------------------------- |
| id          | the id of the course in the old system               |
| title       | title of the course                                  |
| slug        | slug of the course (the part of the url with dashes) |
| created\_at | creation date in datetime format                     |
| excerpt     | non-html text description of the course              |
| free        | is the course free, true or false                    |

When you're ready to import courses, log into your Mavenseed site and click on the [Account menu item](https://mavenseed.com/account) in your Avatar drop-down menu. 

1. Click on the Sites Tab, 
2. On the site you're looking to import data into, click the three dot menu item and choose Data Imports, 
3. Click on the "New Data Import" green button in the top-right corner,
4. Choose "Courses" as the import type 
5. Click the "Select CSV File" and choose your saved .csv file from above with your customer information. 
6. Click "Begin Import"

## Import Chapters

Next, we'll need to import the chapters for the courses. Here's what your CSV file should look like before importing.

| Column Name | Value                                                               |
| ----------- | ------------------------------------------------------------------- |
| id          | the id of the chapter in the old system                             |
| title       | the title of the chapter                                            |
| created\_at | creation date in datetime format                                    |
| content     | the chapter description                                             |
| ordinal     | the numerical position of the chapter in the course                 |
| course\_id  | the id of the course in the old system this chapter was attached to |

When you're ready to import the chapters, log into your Mavenseed site and click on the [Account menu item](https://mavenseed.com/account) in your Avatar drop-down menu. 

1. Click on the Sites Tab, 
2. On the site you're looking to import data into, click the three dot menu item and choose Data Imports, 
3. Click on the "New Data Import" green button in the top-right corner,
4. Choose "Chapters" as the import type 
5. Click the "Select CSV File" and choose your saved .csv file from above with your customer information. 
6. Click "Begin Import"

### Import Lessons

Finally, we'll need to import the lessons that are part of the chapters, inside of the course. This one is a little more in depth due to the nature of a lesson.

| Column Name      | Value                                                             |
| ---------------- | ----------------------------------------------------------------- |
| id               | the id of the lesson in the old system                            |
| title            | the title of the lesson                                           |
| slug             | slug of the lesson (the part in the url)                          |
| type             | the type of lesson (Lesson, Resource, Quiz, Exercise)             |
| free             | is the lesson free, true or false                                 |
| created\_at      | create date in datetime format                                    |
| content          | the lesson content                                                |
| ordinal          | numerical position of the lesson in the chapter                   |
| lessonable\_type | where was this lesson attached to (Chapter)                       |
| lessonable\_id   | id of the chapter in the old system that this lesson was attached |

{% hint style="warning" %}
It's important that the ids of each content piece are correct, as the course import process relies on them in order to be built back up correctly.
{% endhint %}