...
Every contact that is imported will be recorded as being created by a particular user. The default will be that you will be set as the creator of each contact. However if you would like contacts to be shown as being created by other users, you should do these two steps before importing:
1. Add those users to your Organisation on Makerble
2. Add a column called “Created by” to your CSV spreadsheet and include the email addresses of those users. (Note that the email address used for the users must match the email address that those users use to login to their Makerble Account)
Ensure that any Fields that are being imported have been created on Makerble.
Import steps
Go to Create and select Import
Select Contacts (rather than Updates about tagged contacts or Updates with anonymous progress)
There are six tabs
TAB 1: UPLOAD SPREADSHEET:
Give your import a Name - consider naming it after the file you are importing
For the destination: you can choose whether to import the contacts to a
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)
organisation (this will create the contacts and only add them to the organisation)
Attach the file
TAB 2: PREVIEW AND EDIT:
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.
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.
Press NEXT
TAB 3: MATCH COLUMNS TO FIELDS
Here you can match the columns in your spreadsheet to the fields
Press NEXT
TAB 4: SET RULES FOR MATCHING
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
If there are any Answer Choices that are not being matched, make sure you select Skip. Otherwise you won’t be able to proceed.
Once you’ve matched these up you can press Next
TAB 5: SET RULES FOR MERGING
This allows you to merge the imported contacts with existing contacts on Makerble.
TAB 6: CONFIRM IMPORT
This is a preview of what will be imported
Simply scroll to the bottom and press Next (alternatively displayed as Start Import or Finish)
You arrive on the Manage Imports page - https://www.makerble.com/record_importer/ - and the import process happens in the background
Troubleshooting
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 |