How do I bulk import content?

Getting Started

There are two ways to get your content into Trivie: one is to create each question individually using the question creation form. See how to do that here: How do I manually add content? The other is to bulk import them via CSV or Excel file.

Here we'll step you through the process of bulk importing your content starting at the beginning.

Once you're signed in to the management system, click on the "Content" button (see the icon above) on the main left-side navigation and you will be taken to the Content section.

Then click on the "Import Content" button in the top bar:

Templates

Download one of these import templates:

• Excel Format
• CSV Format

It doesn't really matter which one you pick, all popular spreadsheet editors should be able to open and save files in either format. But, you will need a spreadsheet editor such as Microsoft Excel, Google Sheets, Apple Numbers, or even OpenOffice Calc.

You can use this template to populate multiple-choice questions, multiple correct answers, or true/false questions. When you open the template you'll see the following headers:

Here's a breakdown of what each header means: 

• Topic
  • This is where you can group all of your quizzes.
• Quiz
  • Enter the name of a Quiz to associate the question with.
• Question
  • Here's where you enter the text of the question itself (e.g. "How were my employees ever remembering anything without Trivie?).
• Correct_answer
  • In this field, you'll type in the correct answer to the question (e.g. "They probably weren't")
• Wrong_answer_1
  • In this field, and the next one (wrong_answer_2) you'll enter in your distractors.
• Wrong_answer_2
• Factoid
  
  • The factoid field is entirely optional, but if you want to include any extra information that the user will see after they answer the question, here is where you can enter that.

Wait, but how do you enter multiple correct and true/false questions?

True/False Questions:

You only need to enter the correct answer in the correct_answer column. The system will automatically fill in the wrong answer. Sweet! 

Save and Upload

Save the document to a place you can find it (such as to your desktop), and then import it by either clicking or dragging & dropping over the "Drag & drop or click to select file..." section that looks like this one:

Checking for Errors

If any errors are detected in the file, you will be shown the errors immediately.

Otherwise, if there are no errors you will just see something like this:

Completing the Import

Don't forget to click the "Import Content" button to send your file to the server.