/
Prepare csv import files that will create new Contact Profiles

Prepare csv import files that will create new Contact Profiles

This guidance outlines how to prepare a CSV file that will create a new Contact Profile, i.e. using the image example below, it will create a Contact Profile page for Abigail Holmes and specifically populate the red box.

 

CSV file formatting requirements

  • Remove any paragraph breaks from the cells in the spreadsheet

  • Remove all empty columns from the spreadsheet. (It is fine for a column to have a header - i.e. title but to not have any information below that; but there cannot be any columns that are completely empty)

  • Remove all empty rows from the spreadsheet

  • Check that the spreadsheet contains no more than 800 rows - if it does, create multiple spreadsheets as they will be imported separately

Instructions for preparing CSV files to import Contacts

  • Each person you work with will exist in Makerble as a Contact. The format of the CSV is as follows:

  • Rows: Each person you work with should exist as one row in the spreadsheet. 

  • Columns: The columns in the spreadsheet will be matched to the fields on Makerble. Therefore, you must ensure that the column titles of your spreadsheet are identical to the names of the fields described in your Blueprints in the Fields per Form tab.

  • Unique Identifier Column: The Unique Identifier code for each Contact is important as it enables us to easily attach survey responses and attendance data to that person when we are importing stories. We recommend that you use a Unique Identifier for each contact.

  • Contacts can be imported into a specific project or into the organisation as a whole. 

    • If you have contacts that are part of multiple projects, they should be imported contacts into the organisation as a whole and then you can subsequently assign them to their corresponding projects using the Bulk Assign page: Bulk assign contacts to a project   

    • If each of your contacts only appear in a single project, you can import them directly into that project

If you are importing contacts into the organisation:

  • supply a spreadsheet with a list of the contacts

  • Contacts are imported in batches of 800 at a time so if you have more than 800 contacts, create multiple spreadsheets, with each one holding no more than 800 rows

If you are importing contacts into individual projects:

  • Supply a set of spreadsheets; one for each project however note that if any contacts appear in multiple projects, duplicate contacts will be created for them which you will need to merge once they are imported.

  • Each spreadsheet should contain a list of the contacts.

  • Contacts are imported in batches of 800 at a time so if you have more than 800 contacts, create multiple spreadsheets, with each one holding no more than 800 rows. 

Sample files

Here are the download links to the sample csv files:

Next steps

Related content

Import Contacts via CSV
Import Contacts via CSV
More like this
Step 1 of 3: Prepare the csv files
Step 1 of 3: Prepare the csv files
More like this
Import Instructions
Import Instructions
More like this
Preliminary steps to importing stories with tagged contacts using a CSV file
Preliminary steps to importing stories with tagged contacts using a CSV file
More like this
Prepare the import csv files for creating new Session Notes and Attendance records
Prepare the import csv files for creating new Session Notes and Attendance records
More like this
Step 2 of 3: Organise your import data
Step 2 of 3: Organise your import data
More like this