Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

You can import CSV spreadsheets into Makerble that contain stories.

Read the Considerations and Preliminary Steps before importing your CSV file

Steps

  1. Click Create in the top menu

  2. Select Import

  3. You arrive on the New Import page

Tab

Steps

Upload Spreadsheet: this allows you to upload the spreadsheet that will be imported

  1. Choose the type of record: select Import updates with anonymous progress

  2. Give the Upload the same name as the csvs file with the prefix of the folder(s) that it’s from as the csvs file 

  3. Choose the right project

  4. Specific survey: select No

Preview & Edit: this displays the spreadsheet that has been imported. If necessary you can edit each cell of the spreadsheet on this page. However if you have significant edits to make it will be faster to edit the spreadsheet using a tool such as Google Sheets or Microsoft Excel and then re-upload the spreadsheet.

Scroll to the bottom and click Next

Match Authors: this lets you allocate each of the stories being imported to the users on Makerble who will be recorded as being the Authors of those stories. You can select any user within your organisation as an author of an imported story. Therefore it is advisable to add all required users to your Makerble Organisation before starting the import process.

  1. Left dropdown: Select the Created by column

  2. Right dropdown: Select the Email address column 

  3. Press Find Matching Users

  4. A table appears showing the users that have been identified

  5. Press the Next button

Stories With Unidentified Authors: this lets you deal with any rows in the spreadsheet in which Makerble was unable to automatically detect the user to assign as the Author of that story.

Match any manually if necessary

Match Columns To Fields: this is where you assign columns in the spreadsheet to fields on Makerble. The column that has already been used to match Authors should not be selected on this page.

  • Description Field: this relates to the default text field on Makerble that appears on stories created using the web platform

  • Date the activity happened: this is the Date Happened field within a story that allows you to backdate a story

Set rules for matching: If there are any Multiple Choice Question fields that were chosen in the previous step, a box for those fields will appear on this page. Makerble will detect the different Answer Choices that appear in the spreadsheet and allow you to allocate each of those detected Answer Choices to one of the available Answer Choices to that particular Multiple Choice Question.

  • You must select an Answer Choice for every answer that was detected in the spreadsheet

  • You can choose “Skip”

  • Press Next

Confirm Import

  1. Press Next

  2. A popup appears letting you know that import has begun

  3. Press Okay

  4. You arrive on the Manage Imports page

  • No labels