Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • You can create new contacts on Makerble by importing a CSV spreadsheets containing their details.

  • When you create a contact, you populate the red section of their Contact Profile page. (You can populate the purple section - their Timeline - by importing attendance, notes and survey results using Import Stories about tagged contacts)

  • Makerble guides you through the steps to match the columns in your spreadsheet to the fields in your Contact Forms.

...

  1. Select Create in the top menu

  2. A dropdown menu appears

  3. Select Import

  4. In the Choose the type of record you are importing field: select Import Contacts

  5. There are six tabs

    1. TAB 1: UPLOAD SPREADSHEET:

      1. Give your import a Name - consider naming it after the file you are importing

      2. For the destination: you can choose whether to import the contacts to a

        1. single project (this will create the contacts and add them to that project within the organisation; they will also be visible at the organisation level because the organisation owns the project)

        2. organisation (this will create the contacts and only add them to the organisation)

      3. Attach the file - it must be a CSV file

      4. Press Next

    2. TAB 2: PREVIEW AND EDIT:

      1. This simply shows you the contents of your CSV file. You can edit it directly here if you want to, but you shouldn’t need to.

      2. If there are any fields that are not being matched, make sure you select Skip This Field. Otherwise you won’t be able to proceed.

      3. Press NEXT

    3. TAB 3: MATCH COLUMNS TO FIELDS

      1. Here you can match the columns in your spreadsheet to the fields

      2. Press NEXT

    4. TAB 4: SET RULES FOR MATCHING

      1. This displays each list field

      2. This relates mostly to the list type fields. It allows you to match the different Answer Choices in the column of the spreadsheet and match them to the Answer Choices available in that list field on Makerble

      3. If there are any Answer Choices that are not being matched, make sure you select Skip Column. Otherwise you won’t be able to proceed.

      4. Once you’ve matched these up you can press Next

      5. If you don’t have any list fields being matched, you can simply press Next

    5. TAB 5: SET RULES FOR MERGING

      Image Removed
      1. If enabled, this allows you to merge the imported contacts with existing contacts on MakerbleMerging is disabled. Please press Next.

    6. TAB 6: CONFIRM IMPORT

      1. This is a preview of what will be imported

      2. Simply scroll to the bottom and press Next (alternatively displayed as Start Import or Finish)

    7. A popup appears to let you know that the import has begun

  6. You arrive on the Manage Imports page - https://www.makerble.com/record_importer/ - and the import process happens in the background

...

Question

Answer

If there are 00 prefixes in the CSV file that don’t display when you open the CSV file in Excel

https://community.spiceworks.com/topic/270336-saving-as-csv-and-keeping-leading-zeros  

Info

Importing contacts via CSV is only compatible with Classic Contact Forms. If your organisation uses Custom Forms for Contacts, you will have to import your contacts via the API. You can do this using:

Contact helpdesk@makerble.com for guidance on how to action either of these options.

...