# How to Add The Vehicle and Pre-Shift Check Data to Laravel Nova
###### tags: `Driver XQ`

There are two Excel Files shared with you.

1. Forklifts Pre-checks.xlsx
2. Forklifts brands and models rev1.xlsx

Here are the instruction on adding data to the production database.

1. Go to [Laravel Nova](https://driverxq.com/nova). This is the Admin Panel where you can start adding data.
2. The credential for the Laravel Nova has already been shared with Lucks.
3. The following tabs (Manufactures, Pre-Shift Forms, Vehicle CLasses, and Vehicle Models) are the ones we need your help in populating. Please do not touch the other tabs as they are user generated data.

### Add Manufacturer Data
First to add is the **Manufacturer**.
1. Open **Forklifts brands and models rev1.xlsx**
2. Click on `Manufacturer` Tab
3. You will already see a list of manufacturers added. Check against the `Manufacturer` tab of Excel and add what's not yet part of the list in the Laravel Nova. If you see any manufacturer that is not in the excel, you can delete them for now.

### Add Pre-Shift Forms
Next to add is the `Pre-Shift Forms`.
1. Open `Forklifts Pre-checks.xlsx`
2. Ignore the **Class Type** Sheet
3. Click `Create Pre Shift Form`
4. You will be asked to add a Title. Use the Title of the Sheet as the Title of Pre Shift Check Form. For example, the first pre shift check form to add is the **Class I - Rider**
5. Click Create Pre Shift Form
6. In the next page, click the `Create Form Item`
7. Go to the Excel Sheet that corresponds to the title of the pre shift form. For example, `Class I Rider` is the title of the form for `Class I Rider` sheet.
8. When you add pre shift form items, you will fill the `Content` and `Type`. The Type of Column A in Excel Sheet is `Section` and the Type of Column B in Excel Sheet is `Pass or fail`. For Column B, **please add the word "is in good condition" to all words in Column B (for example, "Overhead guard" should be "Overhead guard is in good condition")**. Also, **Please Add the data from Row 1 in order**. For example for Class I - Rider, 1st to add is [Content: KEY OFF Procedures]-[Type: Section], 2nd to add is [Content: The vehicle inspection]-[Type: Section], 3rd to add is [Content: Overhead guard]-[Type: Pass or fail], and so on.
9. After you are done adding all the form items, press the `Pre Shift Forms` tab Again.
10. Repeat Steps 3-9 for all sheets in excel
11. Delete the Default Form

### Add Vehicle Classes
1. First, Click on `Vehicle Classes` tab
2. remove all classes existing right now
3. open the `Forklifts Pre-checks.xlsx`
4. Press `Create Vehicle Class`
5. The name of the Class is the name of the sheet. Please start from Sheet 2 which is `Class I - Rider`.
6. image url is this https://driverxq.imgix.net//forklift-side-06.png
7. For description, go to the `Class Type` sheet. For example, if the class is Class I, put the description found in column B for Class I. There are multiple sub classes for one class but you can sue the same description for the same class (for example, same description for all sub classes of Class 3s)
8. For the Pre-Shift Form, pick the same name as the Class name you chose (For example, `Class I Rider` Pre-shift Form for `Class I Rider` class)
9. Press `Create & Add Another`
10. Repeat Steps 5 - 9 untill all Classes in `Forklifts Pre-checks.xlsx` is added

### Add Vehicle Models
1. Open **Forklifts brands and models rev1.xlsx**
2. Click on `Vehicle Models` Tab
3. Click `Create Vehicle Model`
4. Start from the `Aisle Master` Sheet
5. Pick the right Manufacturer
6. The name is the name under each class
7. Choose the right class which is above the name (it's in row 2)
8. Pick the correct Pre-Shift Form that is the same name as the class
9. repeat 5-8 until all models are added

That's all! 🎉