← Back to docs
Setup Docs

Bulk Uploads & Exports with CSV

Building forty milestones, sixty questions or a whole catalogue of skills one form at a time is slow. Most managers in Manage Content take a CSV upload instead: one row per thing, added in one go. The same idea runs the other way too: rosters, grades and reports come out as CSV files you can open in any spreadsheet. This page lists every upload and every export, and the rules they share.

Where You Can Upload

Only those who can edit the Adventure see the uploads; NPCs don't. Content lands where it belongs: milestones, achievements, items, Tabis, skills, speakers, posts and resources on the template, so every cohort gets them; guilds, tasks and schedule sessions on the Adventure you're in, as a cohort keeps its own.

Before You Pick a File

Under the header, each upload says exactly what it takes, before you choose anything:

A blank cell takes the same default the editor would give it. Choices the editor offers from a list (a status, a type, a Tabi's kind, a task's trigger, an icon) must be one of them; ids must belong to this Adventure. Tabis, posts and resources are always added published.

The Row-by-Row Report

After the upload, a report stays on the page until you close it: N added, M refused, then every refused row with its spreadsheet row number and the reason (Row 12: the milestone title is empty). A row whose name was already there is added anyway, and marked so; blank lines are skipped. Reload to see them shows what was added.

The report under the Blog tab's upload box after two posts were uploaded: Posts uploaded, a line per row added, and Reload to see them.
An upload's report. One line per row added or turned away, with the reason; the new rows appear in the table after a reload.

The sections below give each upload's columns, in order, one content type at a time.

Posts

Manage Content → Blog, Upload file. Up to 150 rows. Columns: quest_title (the post headline, required, up to 255 characters), quest_secondary_headline (up to 200), quest_content, mech_badge (the picture's web address), quest_style (text-right, text-left, news-highlight or headline; text-right when blank), mech_level (1 to 99, 1 when blank), mech_start_date and achievement_id (a path). Every row is added as a published post. Download the template gives a file with an example row.

The Blog tab's Upload file box with its limits, the columns in order and Download the template.
Posts from a CSV. The limits and the columns are listed before you pick a file.

Resources

Manage Content → Lore, Upload file. Up to 150 rows. Columns: quest_title (the resource name, required), quest_style (resource or article; resource when blank), mech_level, quest_secondary_headline (the file or link, a web address), quest_content, mech_badge (a picture's web address, or a book cover by name, book-1 to book-12), quest_color (amber when blank) and achievement_id (a path). Every row is added as a published resource.

The Lore tab's Upload file box listing the resource columns, with one resource uploaded.
Resources from a CSV. Here one row added a Resource-style entry with its PDF.

Speakers

Manage Content → Speakers, Upload Speakers. Up to 100 rows. Columns: speaker_first_name, speaker_last_name, speaker_bio, speaker_picture (a picture's web address), speaker_company, speaker_website and speaker_linkedin. Each row needs a first or a last name. Speakers land on the template, so every cohort shares the cast.

The Speakers tab's Upload Speakers box with the CSV limits and columns listed.
Speakers from a CSV. Every row is added as a new speaker.

Schedule Sessions

On the Schedule page itself, Upload Schedule. Up to 100 rows. Columns: session_title, session_description, session_start and session_end (all four required), session_room, then the ids of a milestone or challenge to attach (quest_id), a speaker (speaker_id), a path (achievement_id) and a guild (guild_id). Every row is added as a new session.

The speaker_id column is kept, but the schedule and the speaker pages don't show it: after an upload, tick each session's speakers in its editor.

The Schedule page's Upload Schedule box with the session columns in order.
Upload Schedule. The columns, in order, and what must be filled.
The report after a schedule upload, listing the session it added.
The schedule upload's report. What was added, and every refused row with its reason.

Achievements

Manage Content → Achievements, in the header. Up to 150 rows. Columns: achievement_name (required, up to 255 characters), achievement_badge (the badge picture, required), achievement_color, achievement_code (its magic code; blank makes a new random one), achievement_content, achievement_display (badge, path or rank), the XP, EP and BLOO it pays (achievement_xp, achievement_ep, achievement_bloo), achievement_max and achievement_order. Achievements land on the template. To hand an existing achievement to a list of people instead, see Awarding an achievement below.

Items

Manage Content → Items, in the header. Up to 150 rows. Columns: item_author (the id of someone in this Adventure, or blank), item_name (required, up to 150 characters), item_description, item_cost (in BLOO), item_type (consumable, key, reward or tabi-piece; gift-card and ticket are Enterprise types), item_badge, item_stock, item_player_max, item_level, item_category, item_order, tabi_id (the Tabi a piece belongs to, an id in this Adventure, or blank) and item_status (publish, draft or trash). Numbers left blank are 0.

item_stock blank or 0 means unlimited, and keys and rewards are always unlimited, as in the item editor; the upload report marks those rows "(stock: unlimited)".

Manage Content's Items tab with the CSV notes open: the limits, the thirteen columns in order with what each takes, and that item_name must be filled
Items from a CSV. The notes under the header list every column in order, with its default when blank. The cost column carries the Adventure's own name for BLOO.
The report after an item upload: Items uploaded correctly, 2 added, 0 refused, a line per row, the stock: unlimited note and Reload to see them
The item upload's report. Two rows added, each named by its row number, with the "(stock: unlimited)" note for an item with no stock set.

Challenge Questions

In a challenge's editor, on the Questions tab, once the challenge is saved. Up to 150 rows. Columns: question, correct and decoy1 (all three required), then decoy2 and decoy3. Each row becomes a multiple-choice question with one right answer among the decoys; other question types are made in the editor.

The CSV upload on a challenge's Questions tab: the limits and the five columns, question, correct, decoy1, decoy2 and decoy3
Questions from a CSV. Five columns: the question, the right answer and up to three decoys.
The report after a question upload on a challenge's Questions tab: 3 questions uploaded correctly, 3 added, 0 refused, a line per row, and Reload to see them
The question upload's report. Three rows in, none refused; Reload to see them adds them to the question list below.

Guilds

Manage Content → Guilds, Upload file beside Add New Guild. Up to 150 rows. Columns: guild_name (required, up to 255 characters), guild_logo (a web address, required), guild_color (a colour name like blue or a code like #1c8ca6; deep orange when blank), guild_group, guild_capacity (a number, 0 or more; blank is 0), assign_on_login (1 for yes or 0 for no; blank is 0) and guild_status (publish or draft; publish when blank). Guilds land on the Adventure you're in, since a cohort keeps its own. Download the template gives a file with an example row.

Manage Content's Guilds tab with the CSV notes open: the seven guild columns in order, what must be filled and Download the template, above the Assign players to a guild box
Guilds from a CSV. The columns, what must be filled and the template, with the separate Assign players to a guild upload just below.

Uploads That Work on People

These take an email address per row and act on people already enrolled, or enrol them:

An achievement's Players tab: the Upload a CSV of email addresses box and the What each upload did record listing the results of earlier uploads
Awarding an achievement from a list. Upload a file of email addresses; the record below keeps what happened to every address on each run.

Exports

Everything you can download as a CSV:

Every export is formula-safe. A cell that starts with =, +, -, @, a tab or a line break gets an apostrophe in front, so a spreadsheet shows it as text instead of running it. A player who names themselves =HYPERLINK(...) can't plant anything in your spreadsheet. Plain numbers, negative ones included, are left as they are. Files open cleanly in Excel, accents and all.

Related