001-04 Import Your Own Data
00:00:05:26 - 00:00:29:46
There is another way you can create people and organisations in SwiftFox via the data importer. Now I know what you're thinking. Data? Importer? Sounds a little bit spreadsheet-y, it is, but once you import, you can enjoy the sweet comfort of knowing that your data is safe and way better looking in SwiftFox. Now let's dive in to how you can import your data into SwiftFox.
00:00:30:00 - 00:00:52:06
You need to prepare and clean your data thoroughly before importing it. What does that mean? Well, firstly make sure all your information is accurate. So check every name, every email, mobile. You're importing this data for longevity. So take the time to make sure that it's right. Ensure that all the column headings match with custom fields in SwiftFox.
00:00:52:10 - 00:01:15:06
So if you're tracking member type on a spreadsheet, make sure this is the same custom field in SwiftFox. Important. Check the guidelines and an example sheet right here within our data import at all. Step two. Once your data is checked, triple checked, and then checked again, save your Excel sheet as a CSV. Step three. Import your data.
00:01:15:10 - 00:01:48:12
Select the plus button on the top right of your SwiftFox page and select Import Data. Then select either people and organisations or just organisations depending on what data you will be importing. Today I'm going to upload people. We’ll drag and drop our CSV file onto the page and select next. Step four. Find your match. Select your matching criteria to determine how the importer will match people in your sheet to your current SwiftFox database.
00:01:48:16 - 00:02:12:47
Here we recommend full name and contact information, but SwiftFox provides several options to choose from. Step five. Now, you must match each column within your imported sheet to a SwiftFox custom field. Exact matches between the column headings and SwiftFox will automatically be matched. Here we can see that all but one of our spreadsheet columns have matched.
00:02:13:01 - 00:02:37:21
D.O.B. was short for date of birth, so we'll match it with the appropriate field in SwiftFox. Warning, any columns left without a SwiftFox field match will be skipped and not imported. Okay, now select next. Step six. It's our turn. SwiftFox will analyse the importer file and then provide a full table of all rows that will be imported.
00:02:37:25 - 00:03:03:00
Do one final check. Make sure you review any of the highlighted fields. These are areas that SwiftFox thinks are empty, incomplete, or incorrectly formatted. Here you can filter by record status to easily find certain field types. Import status will highlight whether this row will be imported or skipped, and profile match shows whether a row matches an existing profile in SwiftFox.
00:03:03:04 - 00:03:17:42
The moment has arrived. Once you have completed your final check, select Import. Make sure to keep this page open until the import is complete. So now you're done. You made it! Now enjoy a world of contact and organisation profiles.
Not what you were looking for?
Get in touch and learn how easy it is to join SwiftFox, our team is available to help you every step of the way.